When I try to administer imagecache I get this message:

Imagecache Administration
user warning: Table 'heirloom.imagecache_action' doesn't exist query: SELECT actionid, weight, data FROM imagecache_action where presetid=2 order by weight in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\heirloom\includes\database.mysql.inc on line 172.

$Id: imagecache.module,v 1.19.2.15 2007/02/21 22:39:22 quicksketch Exp $

And if I try to add a preset namespace I get this error:

Imagecache Administration

* user warning: Table 'heirloom.imagecache_action' doesn't exist query: SELECT actionid, weight, data FROM imagecache_action where presetid=2 order by weight in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\heirloom\includes\database.mysql.inc on line 172.
* user warning: Table 'heirloom.imagecache_action' doesn't exist query: SELECT actionid, weight, data FROM imagecache_action where presetid=2 order by weight in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\heirloom\includes\database.mysql.inc on line 172.

* Flushed Preset Images (ID: 2)
* Updated preset "" (ID: 2)

$Id: imagecache.module,v 1.19.2.15 2007/02/21 22:39:22 quicksketch Exp $

Comments

dopry’s picture

dopry commented

Did you receive any errors when you enabled the imagecache module? The tables we're not properly created it seems.

emersonlenon’s picture

emersonlenon commented

No I just went in and unenabled the module and saved then enabled it saved again and everything was green.

dopry’s picture

dopry commented
Status: Active » Closed (fixed)
tylermoody’s picture

tylermoody commented
Status: Closed (fixed) » Active

I am experiencing this problem as well. Disabling/re-enabling does not help the problem; all seems in order when I re-enable, but this error is printed when I try to create a new preset (none are currently defined):

user warning: Table 'example-com-main.imagecache_preset' doesn't exist query: INSERT INTO imagecache_preset (presetid, presetname) VALUES (7, 'test') in /usr/local/www/drupal-5.3/includes/database.mysql.inc on line 172.
user warning: Table 'example-com-d5-main.imagecache_preset' doesn't exist query: SELECT presetid, presetname FROM imagecache_preset ORDER BY presetname in /usr/local/www/drupal-5.3/includes/database.mysql.inc on line 172.

Is there a way to manually force table creation?

edit: I didn't notice on first submission that my version is different than that of the original poster:
$Id: imagecache.module,v 1.19.2.28 2007/06/16 17:22:41 dopry Exp $

tylermoody’s picture

tylermoody commented
Status: Active » Closed (fixed)

I've fixed this. For some reason hook_install() wasn't operating correctly. Uninstalling from the admin>modules menu threw errors, but the module functions after being re-enabled.