FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » Consistancy Check Failed
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 		 Switch to threaded view of this topic Create a new topic Submit Reply
Consistancy Check Failed [message #166717] Thu, 16 February 2012 11:13 Go to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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] Thu, 16 February 2012 22:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
 remove from buddy list
ignore all messages by this user
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 07:21 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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 07:31 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
 remove from buddy list
ignore all messages by this user
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 07:44 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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 07:53 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
 add to buddy list
ignore all messages by this user
Any thoughts, folks?

Report message to a moderator

Re: Consistancy Check Failed [message #166773 is a reply to message #166772] Tue, 21 February 2012 08:10 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
 remove from buddy list
ignore all messages by this user
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 08:46 Go to previous messageGo to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
Member
 add to buddy list
ignore all messages by this user
I think I see what I did wrong. Stand by.

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

Report message to a moderator

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

Report message to a moderator

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

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

Current Time: Mon Mar 27 06:28:30 EDT 2023

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

Powered by: FUDforum 3.1.0.
Copyright ©2001-2020 FUDforum Bulletin Board Software