Home »
FUDforum Development »
Bug Reports »
Consistency checker fails after forum import
| Consistency checker fails after forum import [message #186626] |
Wed, 08 October 2014 12:46 |
TonyMarston
Messages: 32
Registered: April 2006
Location: Surrey, UK
Karma:
|
Member |
|
|
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' => 'Yes', 'SQ' => '0', )<br /> Database version: 5.5.37-cll<br /> [Referring Page] http://radicore.org/fud/adm/consist.php?&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
|
|
|
|
Current Time: Wed Nov 27 18:50:47 GMT 2024
Total time taken to generate the page: 0.04928 seconds
Calendar
Search
Help
Members
Register
Login
Home
]