Helpful Information
 
 
Category: MySQL 4
MySQL 4 > 5 Problems

Hello

I have moved a system from a server with mySQL 4.1.19 to a server with mySQL 5 and it now does not work. It seems to bee the select statements that are the problem. Is there are hard anf ast rule somewhere that can tell me what the problem is?

THhanks

Andy

Hello

I have moved a system from a server with mySQL 4.1.19 to a server with mySQL 5 and it now does not work.

What doesn't work, exactly?


It seems to bee the select statements that are the problem.
Really? Why is that?


Is there are hard anf ast rule somewhere that can tell me what the problem is?

Yes, when you post a message on the forum, give us some details so we might help you.

mysql5 is less forgiving about joins than older versions. you must make sure to name your tables in correct order for your joins depending on other conditions you have in your join statements.

show us a join that isn't working. Our regular superhelper ESPs have gone wonky from what I can see.