FUDforum: FUDforum Installation Issues » Problem with executing consistency checker

Home » FUDforum » FUDforum Installation Issues » Problem with executing consistency checker

Show: Today's Messages :: Polls :: Message Navigator

Problem with executing consistency checker [message #27077]

Thu, 25 August 2005 16:08

McGyver

Messages: 6
Registered: August 2005

Karma: 0

Junior Member

Hi all,

I was trying to upgrade from 2.6.15 to 2.7.1 and I got an error log like this

Quote:

(G:\Inetpub\wwwroot\zzz_FUDforum2-Data\include\theme\default\db.inc:73
G:\Inetpub\wwwroot\zzz_FUDforum2-Data\include\theme\default\th_adm.inc:110
G:\Inetpub\wwwroot\htdocs\FUDforum2\adm\consist.php:672
) 1100: Table 'fud2_tv_2' was not locked with LOCK TABLES
Query: INSERT INTO fud2_tv_2 (thread_id) SELECT fud2_thread.id FROM fud2_thread INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE forum_id=2 AND fud2_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 THEN 4294967294 ELSE fud2_thread.last_post_date END) ASC, fud2_thread.last_post_id ASC
_GET: array ( 'enable_forum' => '1', 'S' => '9123921a804a67ed3f696196607980a1', 'SQ' => 'd46ccdadc576e3a188910bd8b7a595fd', )
Server Version: 4.1.13a-nt-max-log
[Referring Page] http://.../FUDforum2/upgrade.php

Now I can see only the Forum-Headers but no Entries inside. In the past I already upgraded all prior versions of FUDforum without any problems. Whats going on Sad

"Problems cannot be solved at the same level of awareness that created them...
Once we accept our limits, we go beyond them." (Albert Einstein)

Report message to a moderator

Re: Problem with executing consistency checker [message #27078 is a reply to message #27077]

Thu, 25 August 2005 16:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

If you run the consistency checker again it should run without errors.

The script ran fine on a 2.6.15 install with MySQL 4.1.8, I'll check it wth 4.1.13, it is possible some new MySQL weirdness was introduced.

FUDforum Core Developer

Report message to a moderator

Re: Problem with executing consistency checker [message #27079 is a reply to message #27078]

Thu, 25 August 2005 16:28

McGyver

Messages: 6
Registered: August 2005

Karma: 0

Junior Member

I tried this once more but the same problem: all rebuilds are done and checks are ok but on the end cames up the error log

Quote:

(G:\Inetpub\wwwroot\zzz_FUDforum2-Data\include\theme\default\db.inc:73
G:\Inetpub\wwwroot\zzz_FUDforum2-Data\include\theme\default\th_adm.inc:110
G:\Inetpub\wwwroot\htdocs\FUDforum2\adm\consist.php:672
) 1100: Table 'fud2_tv_2' was not locked with LOCK TABLES
Query: INSERT INTO fud2_tv_2 (thread_id) SELECT fud2_thread.id FROM fud2_thread INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE forum_id=2 AND fud2_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 THEN 4294967294 ELSE fud2_thread.last_post_date END) ASC, fud2_thread.last_post_id ASC
_POST: array ( 'conf' => 'Yes', 'S' => '9a7cff1fcea6d3f17215043e119b0958', 'SQ' => 'f426da94da993cc3ee4581b958a87ff2', )
Server Version: 4.1.13a-nt-max-log
[Referring Page] http://.../FUDforum2/adm/consist.php?S=9a7cff1fcea6d3f17215043e119b0958& ;SQ=f426da94da993cc3ee4581b958a87ff2

Any ideas ??

"Problems cannot be solved at the same level of awareness that created them...
Once we accept our limits, we go beyond them." (Albert Einstein)

Report message to a moderator