By don@robertson.net.nz on

Greetings - I have just installed Drupal using Postgres as a back end.

if I turn on the 'Moderation results' block I get the following error as an authenticated user and as the admin user:
warning: pg_exec() [function.pg-exec]: Query failed: ERROR: pg_atoi: zero-length string
. in /usr/share/pear/DB/pgsql.php on line 164.

user error: DB Error: unknown error
query: SELECT n.*, u.uid, u.name FROM node n LEFT JOIN users u ON u.uid = n.uid WHERE n.nid = '' in /var/www/drupal/includes/database.pear.inc on line 74.

the problem seems to be in the n,nid=''.

I am just playing with this to see how it works, so mayby turning thi on is a silly idea. :-)

Also, if I search the drupal site for the error, I get a lot of sql errors returned - the search string seems to be being executed within the sql. Which is not a good thing.

don