[thelist] MySQL oddness

Dan Parry dan at virtuawebtech.co.uk
Tue Jan 29 04:39:15 CST 2008

Hi all

I really hope this email gets to the list (every computer hates me just at
the moment)

I've just transferred a client site from our to server to their new host and
something slightly odd has happened... Every query that has a join in it is
failing... for example:

SELECT DISTINCT `c`.`id` AS `course_id`, `c`.`course_name`, `mr`.* FROM
snip_map_request `mr`, snip_course_details `c` INNER JOIN
snip_course_details ON `c`.`id` = `mr`.`course_id` WHERE `mr`.`status` = 1
ORDER BY `mr`.`created` ASC

Works perfectly on our server but the new one throws this error:

#1054 - Unknown column 'mr.course_id' in 'on clause'

Our server is running 4.1.20 and the target server is running 4.1.22

Anyone got any ideas? I'm stumped, stressed and knackered and would very
much appreciate any help :)



Dan Parry

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.15/1248 - Release Date: 28/01/2008

More information about the thelist mailing list