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

Home » FUDforum » FUDforum Installation Issues » Problem with executing consistency checker
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Problem with executing consistency checker [message #27077] Thu, 25 August 2005 12:08 Go to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 12: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
add to buddy list
ignore all messages by this user
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 12:28 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 12: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
add to buddy list
ignore all messages by this user
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 13:05 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 429 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 17: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
add to buddy list
ignore all messages by this user
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 18:02 Go to previous messageGo to next message
McGyver is currently offline  McGyver   Germany
Messages: 6
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 18:09 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Win32 specific issues in MySQL, which required some code rewriting.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sun Oct 22 22:42:03 EDT 2017

Total time taken to generate the page: 0.00591 seconds