White Wizzard
2007-Nov-07 20:50 UTC
acts_as_nested_set having a different query in production and in developoment
Hi all I have a set up that works in development but not in production and it all comes down to a query that is generated by rails. [4;36;1mGreenRoom Load Including Associations (0.000000) [0m [0;1mSELECT green_rooms.`id` AS t0_r0, green_rooms.`green_room` AS t0_r1, green_rooms.`team_level_id` AS t0_r2, green_rooms.`organizational_area_id` AS t0_r3, green_rooms.`meeting` AS t0_r4, green_rooms.`parent_id` AS t0_r5, green_rooms.`created_by` AS t0_r6, green_rooms.`created_at` AS t0_r7, green_rooms.`updated_by` AS t0_r8, green_rooms.`updated_at` AS t0_r9, green_rooms.`comment` AS t0_r10, green_rooms.`lock_version` AS t0_r11, organizational_areas.`id` AS t1_r0, organizational_areas.`org_area_name` AS t1_r1, team_levels.`id` AS t2_r0, team_levels.`level` AS t2_r1, parents_green_rooms.`id` AS t3_r0, parents_green_rooms.`green_room` AS t3_r1, parents_green_rooms.`team_level_id` AS t3_r2, parents_green_rooms.`organizational_area_id` AS t3_r3, parents_green_rooms.`meeting` AS t3_r4, parents_green_rooms.`parent_id` AS t3_r5, parents_green_rooms.`created_by` AS t3_r6, parents_green_rooms.`created_at` AS t3_r7, parents_green_rooms.`updated_by` AS t3_r8, parents_green_rooms.`updated_at` AS t3_r9, parents_green_rooms.`comment` AS t3_r10, parents_green_rooms.`lock_version` AS t3_r11 FROM green_rooms LEFT OUTER JOIN organizational_areas ON organizational_areas.id green_rooms.organizational_area_id LEFT OUTER JOIN team_levels ON team_levels.id = green_rooms.team_level_id LEFT OUTER JOIN green_rooms parents_green_rooms ON parents_green_rooms.id = green_rooms.parent_id WHERE (green_rooms.parent_id = ''4'') LIMIT 0, 15 [0m ^[[4;36;1mGreenRoom Load Including Associations (0.000872)^[[0m ^[[0;1mSELECT green_rooms.`id` AS t0_r0, green_rooms.`green_room` AS t0_r1, green_rooms.`team_level_id` AS t0_r2, green_rooms.`organizational_area_id` AS t0_r3, green_rooms.`meeting` AS t0_r4, green_rooms.`parent_id` AS t0_r5, green_rooms.`created_by` AS t0_r6, green_rooms.`created_at` AS t0_r7, green_rooms.`updated_by` AS t0_r8, green_rooms.`updated_at` AS t0_r9, green_rooms.`comment` AS t0_r10, green_rooms.`lock_version` AS t0_r11, organizational_areas.`id` AS t1_r0, organizational_areas.`org_area_name` AS t1_r1, team_levels.`id` AS t2_r0, team_levels.`level` AS t2_r1, childrens_green_rooms.`id` AS t3_r0, childrens_green_rooms.`green_room` AS t3_r1, childrens_green_rooms.`team_level_id` AS t3_r2, childrens_green_rooms.`organizational_area_id` AS t3_r3, childrens_green_rooms.`meeting` AS t3_r4, childrens_green_rooms.`parent_id` AS t3_r5, childrens_green_rooms.`created_by` AS t3_r6, childrens_green_rooms.`created_at` AS t3_r7, childrens_green_rooms.`updated_by` AS t3_r8, childrens_green_rooms.`updated_at` AS t3_r9, childrens_green_rooms.`comment` AS t3_r10, childrens_green_rooms.`lock_version` AS t3_r11 FROM green_rooms LEFT OUTER JOIN organizational_areas ON organizational_areas.id green_rooms.organizational_area_id LEFT OUTER JOIN team_levels ON team_levels.id = green_rooms.team_level_id LEFT OUTER JOIN green_rooms childrens_green_rooms ON childrens_green_rooms.parent_id green_rooms.id WHERE (green_rooms.id = ''3'') AND green_rooms.id IN (''3'') ^[[0m the first query is in development and the second is in production. The major difference is parent being replace with children and it looks at green_rooms from an eager loading query . Any reason why this is happening or how to fix it will be apprieciated. White Wizzard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
White Wizzard
2007-Nov-08 13:27 UTC
Re: acts_as_nested_set having a different query in production and in developoment
This was an active scaffold issue where it was generating the correct reverse association , when I added the reverse association in the active scaffold config, it works. White Wizzard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---