I have two MySQL servers, one's a test the other's development. This query;
select * from pr_stops as Stop where stop.id = 1
...works ok on my test server, but gives the error "Unknown column 'stop.id' in 'where clause'" on my development server. If I change 'Stop' to 'stop', it works ok.
Unfortunately this query is generated by the CakePHP framework, so I can't just edit the query manually.
test: MySQL 5.5.14
dev: MySQL 5.5.8
Can anyone help? Thanks.