This morning I upgraded Image to 5.x-1.1, and run update.php with no problems.
I then upgraded Acidfree to latest 5.x-1.x-dev, and run update.php with no problems.
Following editing of an album image the system warned me about the db schema needing an update
Running the update I got the errors listed below (Drupal database update)
Checking the log I see the errors listed below (Recent log entries)
Maybe unrelated, Earlier on I had noticed the logs complaining about missing item: art/play_big.gif
I have a backup from last night but I am not familiar with db administration:
which table(s) should I restore? Should I "downgrade" acidfree too?
Any suggestion on how to proceed is welcomed. Thanks

!--break--

Drupal database update

* user warning: Table 'acidfree_album' already exists query: CREATE TABLE acidfree_album (aid INT(11) NOT NULL auto_increment, tid int(11) NOT NULL default '0', thumb INT(11) NOT NULL default '0', share INT(1) NOT NULL default '0', order_by VARCHAR(32) NOT NULL default 'n.nid DESC', view varchar(32) NOT NULL default 'grid', PRIMARY KEY (aid)) type=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT nid FROM node JOIN acidfree ON nid=aid JOIN acidfree_hierarchy ON aid=child WHERE parent='-1' in /var/www/cms50/includes/database.mysql.inc on line 172.
* warning: Invalid argument supplied for foreach() in /var/www/cms50/modules/node/node.module on line 504.
* warning: implode() [function.implode]: Bad arguments. in /var/www/cms50/modules/node/node.module on line 508.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT * FROM acidfree WHERE aid=0 in /var/www/cms50/includes/database.mysql.inc on line 172.
* warning: Invalid argument supplied for foreach() in /var/www/cms50/sites/all/modules/acidfree/acidfree.install on line 178.
* user warning: Table 'cms50.acidfree_hierarchy' doesn't exist query: SELECT parent FROM acidfree_hierarchy WHERE child = 0 in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT nid FROM node JOIN acidfree ON nid=aid JOIN acidfree_hierarchy ON aid=child WHERE parent='-1' in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT n.nid FROM node n JOIN acidfree a ON n.nid = a.aid JOIN acidfree_hierarchy h ON n.nid = h.child WHERE a.class = 'album' AND h.parent = 0 in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT n.nid FROM node n JOIN acidfree a ON n.nid = a.aid WHERE type='acidfree' AND class='photo' in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: UPDATE node n JOIN acidfree a ON n.nid=a.aid SET n.type='image' WHERE n.type='acidfree' AND a.class='photo' in /var/www/cms50/includes/database.mysql.inc on line 172.
* user warning: Table 'cms50.acidfree' doesn't exist query: SELECT n.nid from node n JOIN acidfree a on n.nid = a.aid WHERE type='acidfree' AND class='video' in /var/www/cms50/includes/database.mysql.inc on line 172.

Recent log entries

error php 04/05/2007 - 14:44 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:44 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:44 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:44 imagecreatetruecolor() [ error php 04/05/2007 - 14:44 Division by zero in ...
error php 04/05/2007 - 14:44 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:44 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:44 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:44 imagecreatetruecolor() [ error php 04/05/2007 - 14:44 Division by zero in ...
error php 04/05/2007 - 14:43 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:43 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:43 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:43 imagecreatetruecolor() [ error php 04/05/2007 - 14:43 Division by zero in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree_hierarchy' ...
error php 04/05/2007 - 14:42 Invalid argument supplied for foreach() in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 You have an error in your SQL syntax; check the ...
error php 04/05/2007 - 14:42 implode() [ error php 04/05/2007 - 14:42 Invalid argument supplied for foreach() in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'acidfree_album' already ...

Comments

skizzo’s picture

[...]
error php 04/05/2007 - 15:27 Division by zero in ...
error php 04/05/2007 - 15:27 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 15:27 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 15:27 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 15:27 imagecreatetruecolor() [ error php 04/05/2007 - 15:27 Division by zero in ...
error php 04/05/2007 - 15:27 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 15:27 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 15:27 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 15:27 imagecreatetruecolor() [ error php 04/05/2007 - 15:27 Division by zero in ...
error php 04/05/2007 - 14:44 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:44 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:44 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:44 imagecreatetruecolor() [ error php 04/05/2007 - 14:44 Division by zero in ...
error php 04/05/2007 - 14:44 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:44 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:44 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:44 imagecreatetruecolor() [ error php 04/05/2007 - 14:44 Division by zero in ...
error php 04/05/2007 - 14:43 imagedestroy(): supplied argument is not a valid ...
error php 04/05/2007 - 14:43 imagejpeg(): supplied argument is not a valid Image ...
error php 04/05/2007 - 14:43 imagecopyresampled(): supplied argument is not a ...
error php 04/05/2007 - 14:43 imagecreatetruecolor() [ error php 04/05/2007 - 14:43 Division by zero in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree_hierarchy' ...
error php 04/05/2007 - 14:42 Invalid argument supplied for foreach() in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 You have an error in your SQL syntax; check the ...
error php 04/05/2007 - 14:42 implode() [ error php 04/05/2007 - 14:42 Invalid argument supplied for foreach() in ...
error php 04/05/2007 - 14:42 Table 'cms50.acidfree' ...
error php 04/05/2007 - 14:42 Table 'acidfree_album' already ...

vhmauery’s picture

Status: Active » Fixed

I have seen this problem too. The worst part about this problem is that I can't fix it automatically. It will only affect a set of users that installed Acidfree 5 during a period of time that the acidfree.install script was broken. This broken script set the schema version to 2 when it should have been 4 because it was a fresh install. This problem is fixed in the install script now, but it will still affect users that upgraded during that time.

None of the tables are broken. The only bad side effect of upgrading again (which is what this bug causes) is bad settings in the image module. No need to restore databases or anything of that nature. Just go to admin/settings/image and reset the image sizes to numbers.

skizzo’s picture

glad to hear that... restored the thumbnail/preview sizes in Image and that fixed it. Only glitch: for some reason ..../acidfree now leads to ..../node/792 , which is a sub-sub-album. If I recall it correctly it was leading to the album's root before. Thank you for helping me out. On a sideline: I will soon contribute the Italian localization file.

vhmauery’s picture

hmmm. Maybe more went wrong than I thought. It might be a good idea to revert back to your old database. If you do, you might want to make sure that you set the schema version of acidfree to 4 so it doesn't try to upgrade again... Or maybe I should force a check in the install script...

vhmauery’s picture

Status: Fixed » Closed (fixed)