Jump to:
| Project: | ImageCache |
| Version: | 6.x-2.0-beta10 |
| Component: | Miscellaneous |
| Category: | task |
| Priority: | normal |
| Assigned: | bjohn212@drupal.com |
| Status: | active |
Issue Summary
Hi there!
I'm running Drupal 6.13 with PHP 5.2.8. Until about an hour ago I was running the 2.0-beta9 version of the module, and everything was working very well (I use ImageCache to support a number of its "friend' modules such as Galleria). But after installing the new module and running update.php, suddenly things aren't working so well. I got these errors on running update.php:
Unknown column 'f.nid' in 'field list' query: SELECT f.nid, f.fid, f.filename, f.filepath FROM files f INNER JOIN node n ON f.nid = n.nid WHERE n.type = 'image' AND f.filename = '_original' AND NOT f.filepath LIKE 'sites/default/files/%' in ,,,/sites/all/modules/image/image.install on line 149.
Table 'usrdb_xxxxxxxx.file_revisions' doesn't exist query: DELETE FROM file_revisions WHERE NOT EXISTS (SELECT * FROM files WHERE files.fid = file_revisions.fid) in ...sites/all/modules/image/image.install on line 175.
Table 'image' already exists query: CREATE TABLE image ( `nid` INTEGER UNSIGNED NOT NULL, `fid` INTEGER UNSIGNED NOT NULL, `image_size` VARCHAR(32) NOT NULL, PRIMARY KEY (`nid`, `image_size`), INDEX image_fid(`fid`) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in ...sites/all/modules/image/image.install on line 237.
Unknown column 'f.nid' in 'field list' query: INSERT INTO image SELECT DISTINCT f.nid, f.fid, f.filename FROM files f INNER JOIN node n ON f.nid = n.nid WHERE n.type='image' AND f.filename IN ('_original', 'original', 'thumbnail', 'preview') in /www.website.com/sites/all/modules/image/image.install on line 252.
able 'usrdb_xxxxxxxx.file_revisions' doesn't exist query: DELETE FROM file_revisions WHERE EXISTS (SELECT * FROM image WHERE image.fid = file_revisions.fid) in ...sites/all/modules/image/image.install on line 255.On attempting to load a Galleria page, I now get these errors (which have never appeared before)::
* warning: Division by zero in /www.website.com/includes/image.inc on line 196.
* ImageMagick reported an error: /usr/bin/convert: Unrecognized option (-strip). .
* Unable to create scaled Original image.-- and I find myself staring at an empty page -- no thumbnails. On clicking through via the links (which *do* display) to an original image, that won't display either. Same errors.
Now, the -strip problem I've run into before, and last time I searched for and found a fix: set the "strip metadata" value to "0x0" and the problem vanishes. But this fix has no effect this time. The error persists.
...I'm working on a very time-sensitive client site, and don't have a lot of time to solve this problem. The images are key, and I need to get them running again ASAP. If anyone can help me find what's going on here within the next twenty-four hours, that would be great -- otherwise I'm going to have to roll back my database tomorrow and reinstall the beta9 version.
Help help, oh help. :)
Best regards -- Diane
Comments
#1
Just a note to close this down: I couldn't work out what had caused this problem and wasn't comfortable with hand-editing the database to try to resolve it, so I removed the beta10 version of the module, put back beta9, and rolled back the database to before the update. I've installed beta9 and the Image and ImageAPI modules in a separate install of Drupal 6, and I'll test the update again there and see what happens.
Thanks, all.
#2
Yes please keep this updated. I was about to update and decided to check the issues cue. I'm glad I did. I think I'll wait just a bit before updating.
Thank you.
#3
I am experiencing a similar problem. Fortunately, I tried the beta10 install on my development site first. Previously created content seems to work fine. But if I create a new content the image does not show.
update: sorry for the false alarm. my issue was pre-existing before I installed beta10. on the status page i had an error: /tmp is not writeable by the webserver. Fixed by going to administration>Site Configuration>File System and changing to "tmp" without forward slash.
#4