[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 :)
TIA
Dan
--
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
21:32
More information about the thelist
mailing list