[SOLVED] mysql version prob???

[phat_hip_prog]

Hi,

I've got a sql statement which works on my local machine but when transferring to hosted site fails.

Yes my local version of mysql is 5.0.37 and on the host it is 4.1.22-standard.

From what I can see in the manual there isn't anything different concerning the syntax used (but i'm no sql expert!), can anyone suggest what's wrong?

 

$s = "SELECT ".$tn.".id, rip, time, response, method, link, agent, sid FROM ".$tn." left join ".$tnL." on link_id = ".$tnL.".id left join ".$tnA." on agent_id = ".$tnA.".id  left join ".$tnS." on sess_id = ".$tnS.".id  LIMIT ".$start.", ".$rows."";

 

Cheers

[btherl]

What error message does mysql_error() show you?

[phat_hip_prog]

On the host nothing, I presume error messaging is turned off and because I use a wrapper with a try catch statement nothing is ever outputted anyway. I'll do a direct test page to check though.

I've tried removing the limit statements, then changing the 'left join' to just join etc, but no avail?

BRB

[btherl]

The other thing you can do is to echo out the query before executing.  It's likely that the problem is not with mysql syntax, but rather with differing php configurations causing the query to be corrupted.

[phat_hip_prog]

Yes, just another manic moanday... A table wasn't getting installed, because somehow a varchar was trying to be 512???

Cheers, please have a nice day now!