Maybe my problem is related, although we started using FUD around 2.6.11.
I get the following on a consistency check:
....
Rebuilding Topic Views
Warning: pg_query(): Query failed: ERROR: syntax error at or near "AND"
at character 133 in /local/www/apps/fudforum/include/theme/default/db.inc on line 148
Warning: pg_query(): supplied argument is not a valid
PostgreSQL link resource in /local/www/apps/fudforum/include/theme/default/db.inc on line 88
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource
in /local/www/apps/fudforum/include/theme/default/db.inc on line 88
(/local/www/apps/fudforum/include/theme/default/db.inc:148
/local/www/apps/fudforum/include/theme/default/th_adm.inc:67
/local/www/sites/forum/adm/consist.php:463
) : ERROR: syntax error at or near "AND" at character 133
Query: SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON
fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=
AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1121159239
_POST: conf=Yes&SQ=305f7e774144200e6ce486083ba05330&
Server Version:
[Referring Page] http://forum.sandcat.nl/adm/consist.php?rid=12&SQ=305f7e774144200e6ce486083ba05330
At first this wouldn't allow the upgrade to complete. I hacked around it by inserting the following code in src/th_adm.inc.t at the start of function rebuild_forum_view:
if (!$forum_id) {
return;
}
This allowed the consistency check to complete. However there is of course still an inconsistency somewhere in my database.
I'm willing to debug some more myself, but I'd appreciate any clues of the form 'maybe your forum_id is null because...'.
*EDIT*: forgot to say, I encountered this while upgrading from 2.6.13 to 2.6.15. Consistency checks using 2.6.13 would complete (at least the last time I'd run them).
[Updated on: Tue, 12 July 2005 09:24]
Report message to a moderator