FUDforum: Bug Reports » Problems with MySQL 5.5

Home » FUDforum Development » Bug Reports » Problems with MySQL 5.5 (NEVER MAKE Forum Consistency!!!)

Show: Today's Messages :: Polls :: Message Navigator

Re: Problems with MySQL 5.5 [message #164937 is a reply to message #164850]

Tue, 05 April 2011 18:20

Moachist
Messages: 35
Registered: April 2011

Karma:

Member

Hello - A novice here, but trying to setup a small forum. I tried to edit the consist.php file, but I am not sure where to put the code. Do I just cut and paste this code to the bottom of the file? I am getting this error when running it.

Thanks for the help.

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 '(E:\xampp\htdocs\fudforum\include\theme\default\db.inc:75 E:\xampp\htdocs\fudforum\adm\consist.php:25 E:\xampp\htdocs\fudforum\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 _POST: array ( 'conf' => 'Yes', 'SQ' => 'b21ccbfe2cbd65a9b7e2a96e68f43419', ) Database version: 5.5.8 [Referring Page] /FUDforum/adm/consist.php?&SQ=b21ccbfe2cbd65a9b7e2a96e68f43419 ' in E:\xampp\htdocs\fudforum\include\core.inc:215 Stack trace: #0 E:\xampp\htdocs\fudforum\include\theme\default\db.inc(75): fud_sql_error_handler('DELETE fud30_mo...', 'You have an err...', 1064, '5.5.8') #1 E:\xampp\htdocs\fudforum\adm\consist.php(25): q('DELETE fud30_mo...') #2 E:\xampp\htdocs\fudforum\adm\consist.php(171): delete_zero('fud30_mod', 'SELECT mm.id FR...') #3 {main} thrown in E:\xampp\htdocs\fudforum\include\core.inc on line 215

Report message to a moderator

[Message index]

		Problems with MySQL 5.5 By: Firebird on Fri, 18 March 2011 04:58
		Re: Problems with MySQL 5.5 By: naudefj on Fri, 18 March 2011 05:32
		Re: Problems with MySQL 5.5 By: Firebird on Fri, 18 March 2011 05:49
		Re: Problems with MySQL 5.5 By: naudefj on Fri, 18 March 2011 06:39
		Re: Problems with MySQL 5.5 By: Firebird on Fri, 18 March 2011 06:48
		Re: Problems with MySQL 5.5 By: Moachist on Tue, 05 April 2011 18:20
		Re: Problems with MySQL 5.5 By: Moachist on Tue, 05 April 2011 22:42
		Re: Problems with MySQL 5.5 By: naudefj on Fri, 08 April 2011 10:32

Previous Topic:	url tags and {link} not working on feed capture
Next Topic:	NNTP Import Stalls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:53:02 GMT 2024

Total time taken to generate the page: 0.03772 seconds