Hello, We have been developing project on windows and then moving the same files to linux box and it seems that there is something wrong as all sql selects statements have lost JOINs.
Example. Users and Articles Select on Users with recursive 1 or more will give only Users table content and not from both tables. Here is sample sql on Win box - --- SELECT `Translation`.`id`, `Translation`.`company_id`, `Translation`.`language_id`, `Translation`.`stringid_id`, `Translation`.`title`, `Translation`.`active`, `Company`.`id`, `Company`.`name`, `Company`.`info`, `Company`.`created`, `Company`.`modified`, `Company`.`branch`, `Language`.`id`, `Language`.`name`, `Language`.`english_name`, `Language`.`created`, `Language`.`modified`, `Language`.`iso2`, `Stringid`.`id`, `Stringid`.`string_id`, `Stringid`.`max_length` FROM `translations` AS `Translation` LEFT JOIN `companies` AS `Company` ON (`Translation`.`company_id` = `Company`.`id`) LEFT JOIN `languages` AS `Language` ON (`Translation`.`language_id` = `Language`.`id`) LEFT JOIN `stringids` AS `Stringid` ON (`Translation`.`stringid_id` = `Stringid`.`id`) WHERE `Company`.`id` = 54 AND `Language`.`id` = 14 AND `Stringid`.`string_id` IS NOT NULL ORDER BY `Translation`.`active` DESC, `Company`.`name` ASC, `Language`.`english_name` ASC, `Stringid`.`string_id` ASC --- Same page when opening on Linux box - SELECT `Translation`.`id`, `Translation`.`company_id`, `Translation`.`language_id`, `Translation`.`stringid_id`, `Translation`.`title`, `Translation`.`active` FROM `translations` AS `Translation` WHERE 1 = 1 ORDER BY `Company`.`name` ASC, `Company`.`branch` ASC, `Language`.`english_name` ASC, `Stringid`.`string_id` ASC Any ideas? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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?hl=en -~----------~----~----~----~------~----~------~--~---
