Hi there!

Im using Drupal 6.3 and the latest ImageCache module 6.x-1.0-alpha1, and there is a SQL error, when I try to create a new preset:

warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "module" violates not-null constraint in /.../includes/database.pgsql.inc on line 138.

user warning: query: INSERT INTO imagecache_action (presetid, weight, action, data) VALUES (1, 1, 'imagecache_scale', 'a:3:{s:5:"width";s:2:"64";s:6:"height";s:2:"64";s:7:"upscale";i:0;}') in /.../includes/common.inc on line 3308.

In the current version the field "module" of table "imagecache_action" ist preset to NOT NULL, what eventually causes the aforementioned error. A fix of the database schema should fix this error, as imagecache.module seems to use the function drupal_write_record(...) to save the preset.

Best regards,
Henry

Comments

henmue’s picture

This seems to be a related error:

http://drupal.org/node/188462

dopry’s picture

Status: Active » Closed (fixed)

this is also fixed in HEAD.