SQL Error

i can't seem to find any queries in any of the image modules that looks like that. could you provide some more info? perhaps a link?

I get the same warning:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/virtual/zonanordovest.fi.it/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '' in /var/www/virtual/zonanordovest.fi.it/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/virtual/zonanordovest.fi.it/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '' in /var/www/virtual/zonanordovest.fi.it/includes/database.pgsql.inc on line 144.

I have tried a little to track down the offending bit, but am not familiar enough with the system to find it. It looks to me like it's trying to look up data for galleries with no images. In fact, if I remove all galleries with 0 images (either by deleting them or putting at least one image in them), the warning disappears.

In which case, my guess would be use of %s rather than %d for n.nid in the WHERE clause.

Please note that I haven't looked at the code - it's just seems likely to me.

Hope that helps someone track it down.

Terry

yeah, the %s shouldn't be used for the IN query... i'll have to look around and see what the correct way to do that is.

here's a patch. please test it out.

committed to HEAD and DRUPAL-5.