Because i have to set reverse association to
config.nested.add_link "Subgroups", [:subgroups]
config.columns[:subgroups].association.reverse = :subgroups
Im getting this SQL below which isnt picking up the correct subgroups
SELECT "groups".* FROM "groups" INNER JOIN "groups_subgroups" ON
"groups_subgroups".group_id = "groups".id INNER JOIN "groups"
subgroups_groups ON "subgroups_groups".id =
"groups_subgroups".subgroup_id WHERE (groups_subgroups.subgroup_id =
E'7') ORDER BY groups."name" ASC LIMIT 15 OFFSET 0
The correct SQL for groups.subgroups from the console returns
SELECT * FROM "groups" INNER JOIN "groups_subgroups" ON "groups".id =
"groups_subgroups".subgroup_id WHERE ("groups_subgroups".group_id =
7 )
I cant seem to override the sql using conditions_for_colelction or
active_scaffold_joins so how can i go about fixing this so it works
not only for nested finds but creates, updates etc??
JB
On 21 May, 09:44, johnnybutler7 <[email protected]> wrote:
> Im still stuck on this,
>
> The SQL generated from the console is below:
> SELECT * FROM "groups" INNER JOIN "groups_subgroups" ON "groups".id =
> "groups_subgroups".subgroup_id WHERE ("groups_subgroups".group_id =
> 7 )
>
> And the SQL Active Scaffold is generating for
>
> active_scaffold :group do |config|
> config.columns = [:subgroups]
> end
>
> config.nested.add_link "Subgroups", [:subgroups]
> config.columns[:subgroups].association.reverse = :subgroups
>
> is
>
> SELECT "groups".* FROM "groups" INNER JOIN "groups_subgroups" ON
> "groups_subgroups".group_id = "groups".id INNER JOIN "groups"
> subgroups_groups ON "subgroups_groups".id =
> "groups_subgroups".subgroup_id WHERE (groups_subgroups.subgroup_id =
> E'7') ORDER BY groups."name" ASC LIMIT 15 OFFSET 0
>
> So its getting the columns in the conditions confused -
> groups_subgroups.subgroup_id = E'7' when it should be
> groups_subgroups.group_id = E'7'
>
> Ive tried various things using conditions for collection and
> active_scaffold_joins, like:
>
> def conditions_for_collection
> active_scaffold_joins << :subgroups
> "groups_subgroups.group_id = 7"
> end
>
> But i cat seem to figure out how to solve this issue.
>
> Can anyone help??
>
> JB
>
> On 20 May, 11:21, johnnybutler7 <[email protected]> wrote:
>
> > Yes i understand. Will try your suggestions and reply my sesults.
> > Thanks!
>
> > On 20 May, 08:46, "Sergio Cambra .:: entreCables S.L. ::."
>
> > <[email protected]> wrote:
> > > On Miércoles, 20 de Mayo de 2009 09:33:16 johnnybutler7 escribió:
>
> > > > Please see below, thanks.
>
> > > > ActiveScaffold::MalformedConstraint (Malformed constraint
> > > > `Group#groups'. If it's a legitimate column, and you are using a
> > > > nested scaffold, please specify or double-check the reverse
> > > > association name.):
>
> > > groups is neither a column nor an association, I think you must set
> > > reverse to
> > > subgroups, look at generated sql query, and compare it with sql you get in
> > > console. Maybe you can fix it adding conditions_for_collection or
> > > active_scaffold_joins methods to your controller.
>
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/constraints.rb:
> > > > 42:in `each'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/constraints.rb:
> > > > 42:in `conditions_from_constraints'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/finder.rb:
> > > > 125:in `all_conditions'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/finder.rb:
> > > > 158:in `find_page'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/actions/
> > > > list.rb:65:in `do_list'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/actions/
> > > > list.rb:12:in `table'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:1253:in `send'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:1253:in `perform_action_without_filters'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/filters.rb:617:in `call_filters'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/filters.rb:610:in `perform_action_without_benchmark'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:68:in
> > > > `perform_action_without_rescue'
> > > > c:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:68:in
> > > > `perform_action_without_rescue'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/rescue.rb:136:in `perform_action_without_caching'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/caching/sql_cache.rb:13:in `perform_action'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/
> > > > active_record/connection_adapters/abstract/query_cache.rb:34:in
> > > > `cache'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/
> > > > active_record/query_cache.rb:8:in `cache'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/caching/sql_cache.rb:12:in `perform_action'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:524:in `send'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:524:in `process_without_filters'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/filters.rb:606:in
> > > > `process_without_session_management_support'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/session_management.rb:134:in `process'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:62:in `process_with_components'
> > > > /vendor/plugins/active_scaffold/lib/extensions/
> > > > component_response_with_namespacing.rb:13:in `component_response'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:91:in
> > > > `render_component_as_string_without_deprecation'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:152:in `component_logging'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:90:in
> > > > `render_component_as_string_without_deprecation'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/
> > > > active_support/deprecation.rb:94:in `render_component_as_string'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:68:in `__send__'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/components.rb:68:in `render_component'
> > > > /vendor/plugins/active_scaffold/lib/extensions/
> > > > action_view_rendering.rb:59:in `render'
> > > > /vendor/plugins/active_scaffold/frontends/default/views/
> > > > _nested.rhtml:39:in
> > > > `_run_rhtml_vendor47plugins47active_scaffold47frontends47default47views47_n
> > > >ested46rhtml_locals_nested_object'
> > > > /vendor/plugins/active_scaffold/frontends/default/views/
> > > > _nested.rhtml:11:in `each'
> > > > /vendor/plugins/active_scaffold/frontends/default/views/
> > > > _nested.rhtml:11:in
> > > > `_run_rhtml_vendor47plugins47active_scaffold47frontends47default47views47_n
> > > >ested46rhtml_locals_nested_object'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > renderable.rb:39:in `send'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > renderable.rb:39:in `render'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > renderable_partial.rb:20:in `render'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:26:in `benchmark'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/
> > > > active_support/core_ext/benchmark.rb:8:in `realtime'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:26:in `benchmark'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > renderable_partial.rb:19:in `render'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > template.rb:73:in `render_template'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > renderable_partial.rb:45:in `render_partial'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > partials.rb:152:in `render_partial'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_view/
> > > > base.rb:258:in `render_without_active_scaffold'
> > > > /vendor/plugins/active_scaffold/lib/extensions/
> > > > action_view_rendering.rb:61:in `render'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:926:in `render_without_benchmark'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:51:in
> > > > `render_without_active_scaffold'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/
> > > > active_support/core_ext/benchmark.rb:8:in `realtime'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/benchmarking.rb:51:in
> > > > `render_without_active_scaffold'
> > > > /vendor/plugins/active_scaffold/lib/extensions/
> > > > action_controller_rendering.rb:13:in `render'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/base.rb:948:in `render_to_string'
> > > > /vendor/plugins/active_scaffold/lib/extensions/
> > > > action_controller_rendering.rb:9:in `render'
> > > > /vendor/plugins/active_scaffold/lib/active_scaffold/actions/
> > > > nested.rb:18:in `nested'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:135:in `call'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:135:in `custom'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:164:in `call'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:164:in `respond'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:158:in `each'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:158:in `respond'
> > > > c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/
> > > > action_controller/mime_responds.rb:107:in `respond_to'
> > > >
>
> ...
>
> read more »
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en
-~----------~----~----~----~------~----~------~--~---
