I received the following error after upgrading from manual crop 7.x-1.4 to 7.x-1.5. It cropped up when saving a node.
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vid' in 'where clause': DELETE FROM {manualcrop} WHERE (fid = :db_condition_placeholder_0) AND (vid = :db_condition_placeholder_1) AND (style_name IN (:db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_pl...
It looks like the DB updates didn't run for this module when I ran update.php. I tried re-running update.php multiple times and it didn't pick it up so not sure what happened. I ran the two updates below on the database directly and that seemed to fix the issue:
ALTER TABLE `manualcrop` ADD `vid` INT UNSIGNED NOT NULL DEFAULT '0' ;
ALTER TABLE `manualcrop` DROP PRIMARY KEY, ADD PRIMARY KEY( `fid`, `style_name`, `vid`);
Just figured I would post here in case others are looking.
Comments
Comment #1
Anonymous (not verified) commentedI had the same issues and the fix work for me too. Thanks.