Not sure if this is an imagecache or Image API problem. Whenever I try to create a new action to a preset, I get the following error:

user warning: Unknown column 'module' in 'field list' query: INSERT INTO kb_imagecache_action (presetid, weight, module, action, data) VALUES (0, 0, 'imagecache', 'imagecache_scale_and_crop', 'a:2:{s:5:\"width\";s:4:\"40px\";s:6:\"height\";s:4:\"40px\";}') in /home/northstudio/projects/includes/common.inc on line 3324.

The site was recently upgraded to Drupal 6.6 from a Drupal 5.12 site. Imagecache and Image API were updated to the latest versions before the conversion to Drupal 6. Image API.

And yes, I did run and update.php after the upgrade for all my modules.

Any help would be appreciated.

Sincerely,
Rene

Comments

jthaxton’s picture

jthaxton commented

I don't think this is a permanent solution, but I just added that column manually:
ALTER TABLE imagecache_action ADD module VARCHAR(255) AFTER weight;

take note of the table name, if you have a prefix, as you do with kb_, you will want to add that. Of course, now I get another error and I suppose this is an indication of the module in a pre-release beta mode :)

drewish’s picture

drewish commented

did you run the updates? worst case you might try doing a full un-install and re-install.

drewish’s picture

drewish commented
Status: Active » Postponed (maintainer needs more info)
SlipAngel’s picture

SlipAngel commented

I have a similar issue on a site that has undergone an upgrade. Whenever I try to add an action, I return to the preset screen but the action is not listed. I have run the database updates again and tried uninstalling and reinstalling the module.

In addition, I cannot create new presets from the ones I made in Drupal 5. When I try to create a preset, I get a Drupal message stating "Preset foo (ID: ) was created." The ID is blank, just as displayed here. We are using the following modules:

Imagecache
Ubercart
Imagecache UI
Image API
FCKeditor
Nice Menus
Path Auto
Thickbox
Token
Captcha
Google Analytics
Views

drewish’s picture

drewish commented

SlipAngel, I think that #304376: Update function from 5.x -> 6.x is more the issue you're facing.

drewish’s picture

drewish commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

marking as a duplicate of #304376: Update function from 5.x -> 6.x