Page 1 of 1

Managing comments error in 0.9-alpha4 with postgresql

Posted: Tue Aug 09, 2005 6:30 pm
by lendulado
When trying to manage the comments I get two errors about that clause WHERE requires a boolean type

Code: Select all

Warning: pg_query(): Query failed: ERROR: el argumento de WHERE debe ser de tipo boolean, no tipo integer in /usr/local/www/htdocs/global/s9y-ce/include/db/postgres.inc.php on line 107
Error in SELECT COUNT(*) AS total FROM serendipity_comments c WHERE 1
ERROR: el argumento de WHERE debe ser de tipo boolean, no tipo integer
and the second one:

Code: Select all

Warning: pg_query(): Query failed: ERROR: el argumento de WHERE debe ser de tipo boolean, no tipo integer in /usr/local/www/htdocs/global/s9y-ce/include/db/postgres.inc.php on line 107
Error in SELECT c.*, e.title FROM serendipity_comments c LEFT JOIN serendipity_entries e ON (e.id = c.entry_id) WHERE 1 ORDER BY c.id DESC LIMIT 10 OFFSET 0
ERROR: el argumento de WHERE debe ser de tipo boolean, no tipo integer

Re: Managing comments error in 0.9-alpha4 with postgresql

Posted: Tue Aug 09, 2005 8:49 pm
by garvinhicking
Thanks a lot! Error fixed in SVN! :)

(Just replace "WHERE 1" with "WHERE 1 = 1" in your include/admin/comments.inc.php file.)

Regards,
Garvin