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.

e[4;36;1mGreenRoom Load Including Associations (0.000000)e[0m
e[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, 15e[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

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