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

Home » FUDforum Development » Bug Reports » Consistancy Check Failed
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
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.
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: 3624
Registered: December 2004
Karma: 17
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
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.
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: 3624
Registered: December 2004
Karma: 17
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
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.
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?
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: 3624
Registered: December 2004
Karma: 17
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.
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.
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: Thu Oct 19 23:29:33 EDT 2017

Total time taken to generate the page: 0.00734 seconds