MySQL 4 vs mySQL 5
 

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.

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.

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.

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.