FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » Consistancy Check Failed
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Consistancy Check Failed [message #166717] Thu, 16 February 2012 16:13 Go to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
Running 3.0.2...

Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match

Fatal error: Uncaught exception 'Exception' with message '(/var/www/vhost/naospeedwagon.twtelecom.net/FUDforum/include/theme/default /db.inc:75 <br /> /var/www/vhost/naospeedwagon.twtelecom.net/forums/adm/consist.php:25<br /> /var/www/vhost/naospeedwagon.twtelecom.net/forums/adm/consist.php:171<br /> ) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mm FROM fud30_mod mm LEFT JOIN fud30_users u ON mm.user_id=u.id LEFT JOIN fud30_' at line 1<br /> Query: DELETE fud30_mod mm FROM fud30_mod mm LEFT JOIN fud30_users u ON mm.user_id=u.id LEFT JOIN fud30_forum f ON f.id=mm.forum_id WHERE u.id IS NULL OR f.id IS NULL<br /> _POST: array ( 'conf' =&gt; 'Yes', 'SQ' =&gt; 'ff0886b9ace736419ffc976bf0f63ec7', )<br /> Database version: 5.5.20<br /> [Referring Page] https://naospeedwagon.twtelecom.net/forums/adm/consist.php?&amp;SQ=ff0886b9ace736419ffc976bf0f63ec7<br /> ' in /var/www/vhost/naospeedwagon.twtelecom.net/FUDforum/include/core.inc:215 Stack trace: #0 /var/www/vhost/naospeedwagon.twtelecom.net/FUDforum/include/theme/default/d b.inc(75): fud_sql_error_handler('DELETE fud30_mo...', 'You have an err...', 1064, '5.5.20') #1 /var/www/vhost/naospeedwagon.twtelecom.net/forums/adm/consist.php(25): q('DELETE fud30_mo...') #2 /var/www/vhost/naospeedwagon.twtelecom.net/forums/adm/consist.php(171): delete_zero('fud30_mod', 'SELECT mm.id FR...') #3 {main} thrown in /var/www/vhost/naospeedwagon.twtelecom.net/FUDforum/include/core.inc on line 215


PLEASE HELP! Thanks.

Report message to a moderator

Re: Consistancy Check Failed [message #166724 is a reply to message #166717] Fri, 17 February 2012 03:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
You've upgraded MySQL to 5.5. However, FUDforum versions before 3.0.3 is not compatible with MySQL 5.5.

Two possible solutions:
1. Upgrade FUDforum!!!
2. Apply the patch at http://fudforum.org/forum/index.php?t=msg&th=119924

Report message to a moderator

Re: Consistancy Check Failed [message #166765 is a reply to message #166724] Mon, 20 February 2012 12:21 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
Just so I'm clear, to upgrade from 3.0.3, we also have to upgrade our PHP, correct? We're running 5.1.6 now.

Report message to a moderator

Re: Consistancy Check Failed [message #166766 is a reply to message #166765] Mon, 20 February 2012 12:31 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Yes, FUDforum 3.0.3 requires PHP 5.2.3 or higher.
See details at http://cvs.prohost.org/index.php/FUDforum_3.0.3

Report message to a moderator

Re: Consistancy Check Failed [message #166767 is a reply to message #166766] Mon, 20 February 2012 12:44 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
I applied the patch (manually edit of the referenced PHP to append it to the end) and now when I run a consistency check, I only get a blank page.

Report message to a moderator

Re: Consistancy Check Failed [message #166772 is a reply to message #166767] Tue, 21 February 2012 12:53 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
Any thoughts, folks?

Report message to a moderator

Re: Consistancy Check Failed [message #166773 is a reply to message #166772] Tue, 21 February 2012 13:10 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Double check if you've correctly applied the patch. In the unlikely event of it still not working, you need to debug, undo or restore.

Report message to a moderator

Re: Consistancy Check Failed [message #166774 is a reply to message #166773] Tue, 21 February 2012 13:46 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
I think I see what I did wrong. Stand by.

[Updated on: Tue, 21 February 2012 13:48]

Report message to a moderator

Re: Consistancy Check Failed [message #166775 is a reply to message #166774] Tue, 21 February 2012 13:51 Go to previous message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
Got it -- thanks. That cleared it right up.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: error deleting announcements
Next Topic: $EDIT_TIME_LIMIT = 0;
Goto Forum:
  

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

Current Time: Thu May 09 04:51:41 GMT 2024

Total time taken to generate the page: 0.02450 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software