MySQL 5 vs MySQL 4 - Broken plug-ins

[KimmiKat]

Here's one. Recently my cousin took control of one of my forums and moved it to a new host. The new host uses MySQL 5 and upon moving the mboard there, most of the plug-ins have broke. The Arcade, TalkerBot, etc. no longer function or toss more errors then someone here has squirrels.

My cousin has posted on vB.org, but got confusing answers, so he asked me to help out. Is there a way to make the plug-ins work with MySQL 5 or will he have to revert back to a host that uses 4?

[adb22791]

What version of vBulletin is it? IIRC 3.6 works fine on MySQL 5, and most of the plugins for 3.6 should work well. If not, it's most likely a syntax error with the queries. If thats the case, the best thing to do would be to isolate the specific queries that are giving errors, and modify them to conform to MySQL 5 standards.


Alex

[KimmiKat]

It is 3.6. Most of the errors say that it can't find the server or database. As for us modifying the plug-ins, my cousin knows little about how to do that and I wouldn't have a clue where to start.

One note, my cousin just got a response from a support ticket he lodged with the host and they said that have both MySQL 4 and MySQL 5 on their servers and they think the plug-ins are looking for a MySQL 4 database, which doesn't exist.

What version of vBulletin is it? IIRC 3.6 works fine on MySQL 5, and most of the plugins for 3.6 should work well. If not, it's most likely a syntax error with the queries. If thats the case, the best thing to do would be to isolate the specific queries that are giving errors, and modify them to conform to MySQL 5 standards.


Alex

[adb22791]

Hmm, it could very well be an error with his config.php. Have you tried disabling the plugin system globally and checked if everything works properly?


Alex

[KimmiKat]

Yep, no luck. My cousin went out of town, so he'll probably deal with it next week, although I might check some other things out.

[Frets]

db's areen't always local host. especially if you are on a grid server. I don't know about vbulliten but bring the whole thing into s local flat file editor that can sweep and replace across multiple files. replace any 'localhost' with the actual path.

[adb22791]

db's areen't always local host. especially if you are on a grid server. I don't know about vbulliten but bring the whole thing into s local flat file editor that can sweep and replace across multiple files. replace any 'localhost' with the actual path.

That could be the problem. It could also be the host has two MySQL servers running on different ports. It's very hard to diagnose, as there are so many different things that could be happening. Before you go replacing lines in files, it is best to try and find the source of the error. :)


Alex

[KimmiKat]

Thanks for your help. My cousin is registered on this mboard and he'll probably pop in and provide the error messages, etc. for more tips. I'm going to be offline after tomorrow for a few days for family stuff, so I'll let my cousin handle it.

That could be the problem. It could also be the host has two MySQL servers running on different ports. It's very hard to diagnose, as there are so many different things that could be happening. Before you go replacing lines in files, it is best to try and find the source of the error. :)


Alex