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

Home » FUDforum Development » Bug Reports » Consistency checker fails after forum import
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 checker fails after forum import [message #186626] Wed, 08 October 2014 08:46
TonyMarston is currently offline  TonyMarston   United Kingdom
Messages: 32
Registered: April 2006
Location: Surrey, UK
Karma: 0
Member
add to buddy list
ignore all messages by this user
I have FUDforum v3.0.5 installed on my site. I have tried to reload a backup file after moving from another server. THe data import works OK, but when I run the consistency checker it fails with the following error:

Disabling the forum for the duration of maintenance run.
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 '(/home2/radicore/fuddata/include/theme/default/db.inc:86<br /> /home2/radicore/public_html/fud/adm/consist.php:25<br /> /home2/radicore/public_html/fud/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; '0', )<br /> Database version: 5.5.37-cll<br /> [Referring Page] http://radicore.org/fud/adm/consist.php?&amp;SQ=1812f7c73ab7d6dab69f0b782637aeac<br /> ' in /home2/radicore/fuddata/include/core.inc:215 Stack trace: #0 /home2/radicore/fuddata/include/theme/default/db.inc(86): fud_sql_error_handler('DELETE fud30_mo...', 'You have an err...', 1064, '5.5.37-cll') #1 /home2/radicore/public_html/fud/adm/consist.php(25): q('DELETE fud30_mo...') #2 /home2/radicore/public_html/fud/adm/consist.php(171): delete_zero('fud30_mod', 'SELECT mm.id FR...') #3 {main} thrown in /home2/radicore/fuddata/include/core.inc on line 215


Tony Marston
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: All the plugin Documentation/Wiki links are broken
Next Topic: Datadump warnings - 3.0.6
Goto Forum:
  

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

Current Time: Sun Dec 17 22:22:19 EST 2017

Total time taken to generate the page: 0.00637 seconds