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

Home » FUDforum » FUDforum Installation Issues » Problem with executing consistency checker
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Problem with executing consistency checker [message #27077] Thu, 25 August 2005 16:08 Go to next message
McGyver is currently offline  McGyver   Germany
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)
Re: Problem with executing consistency checker [message #27078 is a reply to message #27077] Thu, 25 August 2005 16:16 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: Problem with executing consistency checker [message #27079 is a reply to message #27078] Thu, 25 August 2005 16:28 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
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)
Re: Problem with executing consistency checker [message #27081 is a reply to message #27079] Thu, 25 August 2005 16:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Can you send your consist.php as an attachment, I want to make sure it is the correct version of that file.

FUDforum Core Developer
Re: Problem with executing consistency checker [message #27083 is a reply to message #27081] Thu, 25 August 2005 17:05 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
Here is the file out of the adm-folder (consist.php,v 1.121 2005/08/12 16:39:21)
  • Attachment: consist.php
    (Size: 27.55KB, Downloaded 1084 times)



"Problems cannot be solved at the same level of awareness that created them...
Once we accept our limits, we go beyond them." (Albert Einstein)
Re: Problem with executing consistency checker [message #27109 is a reply to message #27083] Fri, 26 August 2005 21:16 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is fixed by 2.7.2RC1, please upgrade.

FUDforum Core Developer
Re: Problem with executing consistency checker [message #27112 is a reply to message #27109] Fri, 26 August 2005 22:02 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
The upgrade works perfectly. Smile Thank you!

By the way: what was the problem ?



"Problems cannot be solved at the same level of awareness that created them...
Once we accept our limits, we go beyond them." (Albert Einstein)
Re: Problem with executing consistency checker [message #27114 is a reply to message #27112] Fri, 26 August 2005 22:09 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Win32 specific issues in MySQL, which required some code rewriting.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Error in maillist.php
Next Topic: How do I get 2.7.2 RC1?
Goto Forum:
  

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

Current Time: Wed Nov 27 18:49:06 GMT 2024

Total time taken to generate the page: 0.03649 seconds