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)
Rendered admin/product/_form_association (0.05075)
Rendered admin/product/_form (1.13290)
Rendered admin/product/_update_form (1.14012)
Completed in 1.40820 (0 reqs/sec) | Rendering: 1.19561 (84%) | DB:
0.02459 (1%) | 200 OK [http://192.168.1.12/shop/admin/product/update/
643?category_id=43]
Can anyone shed some light on this? Thanks in advance!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
