FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Quirk while upgrading from 2.6.0 to 2.6.14
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Quirk while upgrading from 2.6.0 to 2.6.14 [message #26251 is a reply to message #26225] Tue, 12 July 2005 09:14 Go to previous messageGo to previous message
fritti is currently offline  fritti   Netherlands
Messages: 7
Registered: July 2005
Karma:
Junior Member
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

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: phpBB2 converter does not work
Next Topic: fudapi.inc.php
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 00:30:08 GMT 2024

Total time taken to generate the page: 0.05611 seconds