On Monday 22 February 2010 17:28:47 Sergio Cambra .:: entreCables S.L. ::. 
wrote:
> You get an error about catalog_items_catalog_items.catalog_item_id doesn't
> exist. Rails is trying to join the table with that column, as you can look
>  at here:
> LEFT OUTER JOIN `catalog_items` catalog_items_catalog_items ON
> catalog_items_catalog_items.catalog_item_id = catalog_items.id
> 
> Probably your association is wrong. You can test your named scope and
> association with script/console (better with unit tests) before trying to
>  use it in ActiveScaffold.

This named_scope in CatalogItem works just fine in the console:

named_scope :isotypecontrol, lambda { |conjugate, fragment, isotypeh, origin| 
{ :include => [:marker, :conjugate, :fragment, :isotypeh, :origin], 
:conditions => ['markers.name= "Isotype Control" AND 
catalog_items.conjugate_id = ? AND catalog_items.fragment_id = ? AND 
catalog_items.isotypeh_id = ? AND catalog_items.origin_id = ?', conjugate, 
fragment, isotypeh, origin] } }

When trying to use it with AS, I get:

Processing CatalogItemsController#nested (...) [GET]
  Parameters: {"action"=>"nested", "_method"=>"get", 
"adapter"=>"_list_inline_adapter", "id"=>"1", "controller"=>"catalog_items", 
"associations"=>"catalog_items"}
CatalogItem Load (0.3ms)   SELECT * FROM `catalog_items` WHERE 
(`catalog_items`.`id` = 1)
ActionView::TemplateError (undefined method `association' for nil:NilClass) on 
line #14 of 
vendor/plugins/active_scaffold/frontends/default/views/_nested.html.erb

After adding "has_many :catalog_items" to the same model, the error changes 
to:

ActiveRecord::StatementInvalid (Mysql::Error: Unknown column 
'catalog_items_catalog_items.catalog_item_id' in 'on clause': SELECT 
count(DISTINCT `catalog_items`.id) AS count_all FROM `catalog_items`  LEFT 
OUTER JOIN `markers` ON `markers`.id = `catalog_items`.marker_id  LEFT OUTER 
JOIN `conjugates` ON `conjugates`.id = `catalog_items`.conjugate_id  LEFT 
OUTER JOIN `fragments` ON `fragments`.id = `catalog_items`.fragment_id  LEFT 
OUTER JOIN `isotypehs` ON `isotypehs`.id = `catalog_items`.isotypeh_id  LEFT 
OUTER JOIN `origins` ON `origins`.id = `catalog_items`.origin_id  LEFT OUTER 
JOIN `manufacturers` ON `manufacturers`.id = `catalog_items`.manufacturer_id  
LEFT OUTER JOIN `catalog_items_reactivities` ON 
`catalog_items_reactivities`.catalog_item_id = `catalog_items`.id  LEFT OUTER 
JOIN `reactivities` ON `reactivities`.id = 
`catalog_items_reactivities`.reactivity_id  LEFT OUTER JOIN `isotypels` ON 
`isotypels`.id = `catalog_items`.isotypel_id  LEFT OUTER JOIN 
`applications_catalog_items` ON `applications_catalog_items`.catalog_item_id = 
`catalog_items`.id  LEFT OUTER JOIN `applications` ON `applications`.id = 
`applications_catalog_items`.application_id  LEFT OUTER JOIN `catalog_items` 
catalog_items_catalog_items ON catalog_items_catalog_items.catalog_item_id = 
catalog_items.id WHERE (((catalog_items.id = '5'))) AND (markers.name= 
"Isotype Control" AND catalog_items.conjugate_id = 1 AND 
catalog_items.fragment_id = 1 AND catalog_items.isotypeh_id = 2 AND 
catalog_items.origin_id = 1) )

It seems I need the self-referencing association for AS to work correctly, but 
then the extra JOIN  becomes a problem (even though the named scope still work 
in the console despite has_many :catalog_items being present). Is it possible 
to manually :exclude an association in the named_scope? What else can I try?

greetings,
ben

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

Reply via email to