Rails - Nov 2007 - 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
-~----------~----~----~----~------~----~------~--~---

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
-~----------~----~----~----~------~----~------~--~---