I installed node_gallery, created a gallery, added some jpegs. Everything seemed fine until I added the jpeg files, when I got the following errors:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character
varying = integer LINE 1: ...ocks WHERE module = 'devel_node_access' AND delta = 1 AND th... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/drupal-6.15/includes/database.pgsql.inc on line 139.

* user warning: query: SELECT status FROM blocks WHERE module = 'devel_node_access' AND delta = 1 AND theme = 'giordani' in /var/www/drupal-6.15/sites/all/modules/devel/
devel_node_access.module on line 212.

Thanks for your work. This looks like a great project...

-js

Comments

designwork’s picture

HI js,

can you please deactivate the devel module under admin->build->modules first and retry to upload an image. Your warning is refering to "devel_node_access" not to a node_gallery table.

If it`s still not working deactivate the node_gallery_access module and rebuild the node access permission table.

Cheers

Dirk

steggall’s picture

Dirk,

Excellent. That fixed it. That's what I get for trying out two new modules at the same time...

Thanks!

-js

justintime’s picture

Category: bug » support
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.