Hi there! I had a cake app running on a windows box with xampp and it was working fine. Then i bought it over to OS X running mamp, and some of the queries did not work so I re-made them, changing the join type.
With Debug was set to 2, I'd get errors saying that table.field did not exist, then when removing 'table' it said 'field' was ambiguous. Which is fair enough because it occured in the other table. To fix the problem I had to do an INNER JOIN instead, and prefex all my fields with the table name before hand. I am running Model->execute() on this $sql statement (don't recommend find(), this is a unique components) This sounds like a Mysql setting, someone mentioned a case setting but it is set to 0. Another issue occured whereby I execute a ( $sql) statement, and on the PC the array returned was the plural [Cats], [Dogs] etc, then on the mac, it was [Cat], [Dog]. This sounds like it is more related to case. Checking mamp's mysql.log: "[Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system '/Applications/MAMP/db/mysql/' is case insensitive. This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_names to 1 or 2" I checked and 0 is for dev and the rest mostly for production. So my next question is, if i'm wrong about the case, where is my config for Apache in mamp? http.conf is for directives etc, but what about the startup options where lower_case_table_names has to go? Any help appreciated :) Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
