Managing comments error in 0.9-alpha4 with postgresql

[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

[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