I will try this on my development server and see if it helps.
On Apr 14, 9:02 pm, Kenny Ortmann <[email protected]> wrote:
> upgrade ruby and rails and then active scaffold.
>
> On Tue, Apr 14, 2009 at 6:08 PM, pattejam <[email protected]> wrote:
>
> > I am suddenly having problems updating records from a particular class
> > and I cannot seem to track down why. All of my other models are
> > working correctly and I have been doing some form_column overrides,
> > but nothing out of the ordinary.
>
> > ruby 1.8.5 (2006-08-25) [i486-linux]
> > rails 2.0.2
>
> > When I do an update, I never see an update in SQL.
>
> > It appears to update as normal from but just loads with the same
> > record open.
>
> > I can update the record from the console just fine.
>
> > >> @p = Product.find(643)
> > => #<Product id: 643, ...... status: "Discontinued">
> > >> @p.status = "Active"
> > => "Active"
> > >> @p.save
> > => true
> > >> @p = Product.find(643)
> > => #<Product id: 643, ....... status: "Active">
>
> > excerpt from development.log
>
> > Processing ProductController#update (for 192.168.1.6 at 2009-04-14
> > 19:07:25) [PUT]
> > Session ID: 850aed1df43c1d5ef746a52db4bfcdfa
> > Parameters: {"commit"=>"Update",
> > "authenticity_token"=>"b994deb197b5c70d4e2d4dc52a8ef66c6014da7c",
> > "_method"=>"put", "action"=>"update", "id"=>"643",
> > "category_id"=>"43", "controller"=>"admin/product",
> > "associated_id"=>"", "record"=>{"status"=>"Discontinued".......
> > Manufacturer Columns (0.001171) SHOW FIELDS FROM `manufacturers`
> > Product Load (0.000209) SELECT * FROM `products` WHERE
> > (`products`.`id` = 643)
> > SQL (0.000184) BEGIN
> > Manufacturer Load (0.000202) SELECT * FROM `manufacturers` WHERE
> > (`manufacturers`.`id` = 30)
> > CACHE (0.000000) SELECT * FROM `manufacturers` WHERE
> > (`manufacturers`.`id` = 30)
> > CategoryProduct Columns (0.000943) SHOW FIELDS FROM
> > `category_products`
> > CategoryProduct Load (0.000184) SELECT * FROM `category_products`
> > WHERE (category_products.product_id = 643)
> > Category Columns (0.001450) SHOW FIELDS FROM `categories`
> > Category Load (0.000196) SELECT * FROM `categories` WHERE
> > (`categories`.`id` = 43)
> > Fitment Columns (0.001136) SHOW FIELDS FROM `fitments`
> > Fitment Load (0.001428) SELECT * FROM `fitments` WHERE
> > (fitments.product_id = 643)
> > ProductOption Columns (0.001121) SHOW FIELDS FROM
> > `product_options`
> > ProductOption Load (0.000230) SELECT * FROM `product_options`
> > WHERE (product_options.product_id = 643)
> > Image Columns (0.001309) SHOW FIELDS FROM `images`
> > Image Load (0.000171) SELECT * FROM `images` WHERE
> > (images.product_id = 643)
> > ProductGuide Columns (0.000986) SHOW FIELDS FROM `product_guides`
> > ProductGuide Load (0.000300) SELECT * FROM `product_guides` WHERE
> > (product_guides.product_id = 643)
> > EbayItemSpecific Columns (0.001085) SHOW FIELDS FROM
> > `ebay_item_specifics`
> > EbayItemSpecific Load (0.000184) SELECT * FROM
> > `ebay_item_specifics` WHERE (ebay_item_specifics.product_id = 643)
> > Product Load (0.002078) SELECT * FROM `products` WHERE
> > (products.product_number = '1050320' AND products.id <> 643) LIMIT 1
> > SQL (0.000186) COMMIT
> > Rendering admin/product/update.rjs
> > Rendered admin/product/_agent_form_column (0.00131)
> > Rendered admin/product/_form_attribute (0.00148)
> > Rendered admin/product/_form_attribute (0.00146)
> > Rendered admin/product/_form_attribute (0.00159)
> > Rendered admin/product/_form_attribute (0.00157)
> > Rendered admin/product/_form_attribute (0.00139)
> > Rendered admin/product/_form_attribute (0.00166)
> > Rendered admin/product/_form_attribute (0.00159)
> > Rendered admin/product/_form_attribute (0.00016)
> > Rendered admin/product/_form_attribute (0.00161)
> > Rendered admin/product/_form_attribute (0.00156)
> > Rendered admin/product/_form_attribute (0.00138)
> > Rendered admin/product/_form_attribute (0.00153)
> > Rendered admin/product/_form_attribute (0.00390)
> > Rendered admin/product/_form_attribute (0.00136)
> > Rendered admin/product/_form_attribute (0.00159)
> > Rendered admin/product/_form_attribute (0.00134)
> > Rendered admin/product/_form_attribute (0.00163)
> > Manufacturer Load (0.000468) SELECT * FROM `manufacturers`
> > Rendered admin/product/_form_attribute (0.10940)
> > Rendered admin/product/_form_association_header (0.02663)
> > Category Load (0.000280) SELECT * FROM `categories`
> > Rendered admin/product/_form_attribute (0.00803)
> > Rendered admin/product/_form_association_record (0.03074)
> > CACHE (0.000000) SELECT * FROM `categories`
> > Rendered admin/product/_form_attribute (0.00711)
> > Rendered admin/product/_form_association_record (0.02207)
> > SQL (0.000210) SELECT count(*) AS count_all FROM
> > `category_products` WHERE (product_id IS NULL)
> > Rendered admin/product/_form_association_footer (0.00967)
> > Rendered admin/product/_form_association (0.10537)
> > Rendered admin/product/_form_association_header (0.00582)
> > Rendered admin/product/_form_attribute (0.00162)
> > Rendered admin/product/_form_attribute (0.00165)
> > AutoMake Columns (0.000982) SHOW FIELDS FROM `auto_makes`
> > AutoMake Load (0.000196) SELECT * FROM `auto_makes` WHERE
> > (`auto_makes`.`id` = 8)
> > AutoMake Load (0.000190) SELECT * FROM `auto_makes`
> > Rendered admin/product/_form_attribute (0.01577)
> > AutoModel Columns (0.001049) SHOW FIELDS FROM `auto_models`
> > AutoModel Load (0.000182) SELECT * FROM `auto_models` WHERE
> > (`auto_models`.`id` = 27)
> > AutoModel Load (0.000185) SELECT * FROM `auto_models`
> > Rendered admin/product/_form_attribute (0.01523)
> > AutoEngine Columns (0.001187) SHOW FIELDS FROM `auto_engines`
> > AutoEngine Load (0.000250) SELECT * FROM `auto_engines` WHERE
> > (`auto_engines`.`id` = 38)
> > AutoEngine Load (0.000265) SELECT * FROM `auto_engines`
> > Rendered admin/product/_form_attribute (0.12318)
> > Rendered admin/product/_form_association_record (0.17722)
> > Rendered admin/product/_form_attribute (0.00185)
> > Rendered admin/product/_form_attribute (0.00171)
> > AutoMake Load (0.000350) SELECT * FROM `auto_makes` WHERE
> > (`auto_makes`.`id` = 6)
> > CACHE (0.000000) SELECT * FROM `auto_makes`
> > Rendered admin/product/_form_attribute (0.00382)
> > AutoModel Load (0.000304) SELECT * FROM `auto_models` WHERE
> > (`auto_models`.`id` = 12)
> > CACHE (0.000000) SELECT * FROM `auto_models`
> > Rendered admin/product/_form_attribute (0.00414)
> > AutoEngine Load (0.000292) SELECT * FROM `auto_engines` WHERE
> > (`auto_engines`.`id` = 10)
> > CACHE (0.000000) SELECT * FROM `auto_engines`
> > Rendered admin/product/_form_attribute (0.00342)
> > Rendered admin/product/_form_association_record (0.03676)
> > Rendered admin/product/_form_attribute (0.00183)
> > Rendered admin/product/_form_attribute (0.00193)
> > CACHE (0.000000) SELECT * FROM `auto_makes` WHERE
> > (`auto_makes`.`id` = 6)
> > CACHE (0.000000) SELECT * FROM `auto_makes`
> > Rendered admin/product/_form_attribute (0.00262)
> > AutoModel Load (0.000216) SELECT * FROM `auto_models` WHERE
> > (`auto_models`.`id` = 10)
> > CACHE (0.000000) SELECT * FROM `auto_models`
> > Rendered admin/product/_form_attribute (0.00403)
> > CACHE (0.000000) SELECT * FROM `auto_engines` WHERE
> > (`auto_engines`.`id` = 10)
> > CACHE (0.000000) SELECT * FROM `auto_engines`
> > Rendered admin/product/_form_attribute (0.00318)
> > Rendered admin/product/_form_association_record (0.03420)
> > Rendered admin/product/_form_attribute (0.00172)
> > Rendered admin/product/_form_attribute (0.00170)
> > CACHE (0.000000) SELECT * FROM `auto_makes`
> > Rendered admin/product/_form_attribute (0.00259)
> > CACHE (0.000000) SELECT * FROM `auto_models`
> > Rendered admin/product/_form_attribute (0.00322)
> > CACHE (0.000000) SELECT * FROM `auto_engines`
> > Rendered admin/product/_form_attribute (0.00290)
> > Rendered admin/product/_form_association_record (0.03252)
> > SQL (0.000220) SELECT count(*) AS count_all FROM `fitments` WHERE
> > (product_id IS NULL)
> > Rendered admin/product/_form_association_footer (0.00571)
> > Rendered admin/product/_form_association (0.31623)
> > Rendered admin/product/_form_association_header (0.01272)
> > Rendered admin/product/_form_attribute (0.00144)
> > Rendered admin/product/_form_attribute (0.00163)
> > Rendered admin/product/_form_attribute (0.00163)
> > Rendered admin/product/_form_attribute (0.00158)
> > Rendered admin/product/_form_attribute (0.00173)
> > Rendered admin/product/_form_association_record (0.03574)
> > SQL (0.000197) SELECT count(*) AS count_all FROM `product_options`
> > WHERE (product_id IS NULL)
> > Rendered admin/product/_form_association_footer (0.00965)
> > Rendered admin/product/_form_association (0.06492)
> > Rendered admin/product/_form_association_header (0.00484)
> > Rendered admin/product/_form_attribute (0.00158)
> > Rendered admin/product/_form_attribute (0.00157)
> > Rendered admin/product/_form_association_record (0.01380)
> > SQL (0.000205) SELECT count(*) AS count_all FROM `images` WHERE
> > (product_id IS NULL)
> > Image Load (0.000202) SELECT * FROM `images` WHERE (product_id IS
> > NULL)
> > Rendered admin/product/_form_association_footer (0.11086)
> > Rendered admin/product/_form_association (0.13619)
> > Rendered admin/product/_form_association_header (0.01230)
> > Rendered admin/product/_form_attribute (0.00179)
> > Rendered admin/product/_form_attribute (0.00173)
> > Rendered admin/product/_form_association_record (0.02206)
> > SQL (0.000207) SELECT count(*) AS count_all FROM `product_guides`
> > WHERE (product_id IS NULL)
> > Rendered admin/product/_form_association_footer (0.01137)
> > Rendered admin/product/_form_association (0.05248)
> > Rendered admin/product/_form_association_header (0.01204)
> > Rendered admin/product/_form_attribute (0.00142)
> > Rendered admin/product/_form_attribute (0.00166)
> > Rendered admin/product/_form_association_record (0.02001)
> > SQL (0.000200) SELECT count(*) AS count_all FROM
> > `ebay_item_specifics` WHERE (product_id IS NULL)
> > Rendered admin/product/_form_association_footer (0.00972)
>
> ...
>
> 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
-~----------~----~----~----~------~----~------~--~---
