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

Home » FUDforum » FUDforum Installation Issues » Consistency fail after update from 3.0.0 to 3.0.2
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
Consistency fail after update from 3.0.0 to 3.0.2 [message #164853] Fri, 18 March 2011 11:15 Go to next message
oeriksen is currently offline  oeriksen
Messages: 1
Registered: March 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I've got a consistency fail after update from 3.0.0 to 3.0.2. I've tried running the upgrade again but with same result.

Thank you for any help.
Oyvind Eriksen



Checking if moderator and users table match
Fatal error: Uncaught exception 'Exception' with message '(D:\FUDforum\include\theme\default\db.inc:86
D:\WWWDOCS\www\forum\adm\consist.php:25
D:\WWWDOCS\www\forum\adm\consist.php:171
) 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
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
_GET: array ( 'enable_forum' => '1', 'S' => '...', 'SQ' => '...', )
Database version: 5.5.10
[Referring Page] 172.16.36.3/forum/upgrade.php
' in D:\FUDforum\include\core.inc:215 Stack trace: #0 D:\FUDforum\include\theme\default\db.inc(86): fud_sql_error_handler('DELETE fud30_mo...', 'You have an err...', 1064, '5.5.10') #1 D:\WWWDOCS\www\forum\adm\consist.php(25): q('DELETE fud30_mo...') #2 D:\WWWDOCS\www\forum\adm\consist.php(171): delete_zero('fud30_mod', 'SELECT mm.id FR...') #3 {main} thrown in D:\FUDforum\include\core.inc on line 215
Re: Consistency fail after update from 3.0.0 to 3.0.2 [message #164854 is a reply to message #164853] Fri, 18 March 2011 13:19 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3654
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Apply the patch at http://fudforum.org/forum/index.php?t=msg&th=119924
and rerun the consistency checker.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Original admin password
Next Topic: Undefined template: "TEMPLATE" inside "registered_on_date"
Goto Forum:
  

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

Current Time: Fri Jun 22 10:53:55 EDT 2018

Total time taken to generate the page: 0.00619 seconds