MySQL 4 vs mySQL 5

[Wheels]

Recently I moved my forum to a new server. On the old one, it ran mySQL 4.1.x, the new one runs 5.0.x and it has broken many of the plug-ins on the forum like the TalkerBot, Arcade, and a few others. I lodged a support ticket and the host was able to get the forum working by adding some cold, but the plug-ins are still dead as a duck. Any ideas?

Thanks.

[AntonyF]

Do you have access to mySQL error logs? I've found normally that you just have to turn on a setting or something in the mySQL conf, but an error log will give you an indication of what is breaking when the module tries to work.

[Code Monkey]

The syntax for JOIN has changed. That's usually what cause the problems.

[Wheels]

The syntax for JOIN has changed. That's usually what cause the problems.

Would that cause "server not found" and othe errors like I was getting. I tried using "ini_set('mysqli.default_socket', '/tmp/mysql5.sock');" like I did on the config.sys for the forum, but it doesn't seem to work for the plug-ins. I have considering lodging a ticket to go back mySQL 4.

[AntonyF]

You shouldn't get server not found messages unless Apache is down or something like that. But without error logs, it's guess work what's going wrong.