|
|
|
|
|
|
|
|
|
|
| Re: Re : Quirk while upgrading from 2.6.0 to 2.6.14 [message #26230 is a reply to message #26229] |
Mon, 11 July 2005 17:08   |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Ok here is what I've done:
1) Installed FUDforum 2.6.10 (MySQL Driver)
2) Removed content from category and forum tables.
3) Imported the content from your data dump.
4) Ran consistency checker.
At this point I could see all the categories and their forums.
5) Ran 2.6.14 upgrade script
6) Ran consistency checker.
At this point I see the exact same forum & category listing.
Another words, I could not replicate the problem.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
fritti
Messages: 7
Registered: July 2005
Karma: 0
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
and I am planning an upgrade to 2.6.14. Before doing it on the server, I installed 2.6.0 on my local machine running EasyPHP and imported a datadump of our server's forum.
).
]