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

Problems with MySQL 5.5 [message #164846]

Fri, 18 March 2011 04:58

Firebird
Messages: 4
Registered: March 2011

Karma: 0

Junior Member

Hello!

I have a freshly installed FudForum 3.0.2
And made tonight a Forum Consistency of my forum

After that I recieved SQL error.

And my forum was broken.

I transfered my forum data to another server with MySQL 5.0.x
And made Forum Consistency on this server. And all become OK!

So - if you have MySQL 5.5.x - NEVER MAKE a Forum Consistency!

Report message to a moderator

Re: Problems with MySQL 5.5 [message #164847 is a reply to message #164846]

Fri, 18 March 2011 05:32

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Can you please post details about the error so we can fix it?

Report message to a moderator

Re: Problems with MySQL 5.5 [message #164848 is a reply to message #164847]

Fri, 18 March 2011 05:49

Firebird
Messages: 4
Registered: March 2011

Karma: 0

Junior Member

Yes, of course.
It`s a very simple.
I have a CentOS 5.5 x86_64 with php 5.2.6 (now 5.2.10). MySQL 5.5.6 (now 5.5.10) - from remi repository and from mysql.org server - don`t matter.
Freshly installed FudForum 3.0.2 with some posts (now 175 messages).
When I go to the Admin Settings and press Forum Consistency I recieved an SQL error. No I can`t print error - because I closed this tab in my Firefox. I try represent it asap.
And the same error if I try to upgrade FudForum 3.0.1 to 3.0.2.

Report message to a moderator

Re: Problems with MySQL 5.5 [message #164849 is a reply to message #164848]

Fri, 18 March 2011 06:39

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Apply this patch to adm/consist.php:

if (__dbtype__ == 'mysql') {	// MySQL is full of crap (can't specify target table for update in FROM).
-	q('DELETE '. $tbl .' '. substr($q, 7, strpos($q, '.') - 7) .' '. strstr($q, 'FROM'));
+	q('DELETE '. substr($q, 7, strpos($q, '.') - 7) .' '. strstr($q, 'FROM'));

Report message to a moderator

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

Fri, 18 March 2011 06:48

Firebird
Messages: 4
Registered: March 2011

Karma: 0

Junior Member

Hello!

Thanx!
I just test it, and all OK!

Thank you again!

Wbr Victor

Report message to a moderator

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: 0

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

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

Tue, 05 April 2011 22:42

Moachist

Messages: 35
Registered: April 2011

Karma: 0

Member

I figured out how to change the PHP script and got the consistency checker to run, however, is there an update script, upgrade process, or something automated I am supposed to use to apply these types of patches? Or just manually editing the lines is the best way?

Report message to a moderator

Re: Problems with MySQL 5.5 [message #164949 is a reply to message #164940]

Fri, 08 April 2011 10:32

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Moachist wrote:

...is there an update script, upgrade process, or something automated I am supposed to use to apply these types of patches?

I agree, it should be automated.
Can you maybe help us to put something like this in place?

Report message to a moderator

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: Thu Nov 28 21:16:02 GMT 2024

Total time taken to generate the page: 0.02387 seconds