[drupal-support] Problems with ImageGallery and Postgres

[Torsten Flammiger]

Torsten Flammiger schrieb:
> Hello once more,
> 
> i get an error (warning) from Drupal after adding the 1. gallery.
> 
> In my postgres logfile it shows like this:
> ERROR:  invalid input syntax for integer: ""
> 
> And Drupal reports:
> warning: pg_query(): Query failed: ERROR:  invalid input syntax for 
> integer: "" in /var/www/content/includes/database.pgsql.inc on line 45.
> 
> and on 2nd and 3rd line it says:
> user error:
> query: SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER 
> JOIN users u ON u.uid = n.uid WHERE n.nid = '' in 
> /var/www/content/includes/database.pgsql.inc on line 62.
> 
> If i add more galleries the 2 errors are raised for each gallery i add.
> 
> I use Drupal 4.6.3 and Postgres 7.4.1 on Debian Sarge

not Postgres 7.4.1 but 7.4.7

i included a patch that resolved the problem for me. I know its an
ugly hack, but... and i dont know if it works on mysql based systems
nor if it is really necessary in any way. So if one knows how i can
avoid using such ugly hacks let me know :-)

Torsten
-------------- next part --------------
A non-text attachment was scrubbed...
Name: node.module.diff
Type: text/x-patch
Size: 1464 bytes
Desc: not available
Url : http://drupal3.drupal.org/pipermail/support/attachments/20050815/5d2606f9/node.module.bin