Hi Colin,
It never gets to the delete sql at all. There is no delete sql in the
log. There is a 'select' on transaction which i cant figure out how.
the log o/p
Parameters: {"action"=>"destroy", "_method"=>"delete",
"authenticity_token"=>"2c84880c410eab07f8ed9125520c50e440eb3105",
"id"=>"80", "controller"=>"orders"}
...
[4;36;1mOrder Columns (0.003615) [0m [0;1mSHOW FIELDS FROM
`orders` [0m
[4;35;1mOrder Load (0.002041) [0m [0mSELECT `orders`.* FROM
`orders` INNER JOIN users ON orders.user_id = users.id WHERE
(`orders`.`id` = 80) [0m
[4;36;1mTransaction Load (0.001054) [0m [0;1mSELECT * FROM
`transactions` WHERE (`transactions`.order_id = 80) LIMIT 1 [0m
Redirected to http://localhost:3000/orders
...
What ive figured out so far is that @order.destroy returns whatever
"SELECT * FROM `transactions` WHERE (`transactions`.order_id = 80)
LIMIT 1" returns.
My model definitions couldnt possibly be simpler. Its as ive defined
them above.. just cant figure it out.. any ideas at all? doesnt seem
to be any ticket on it in Lighthouse.. could it?.. indeed.. be.. a...
BUG!!?!?
Im gonna try and install the query trace plugin and trace where that
query is coming from...
any other ideas?
On Jun 30, 12:27 pm, Colin Law <clan...@googlemail.com> wrote:
> 2009/6/29 Ram <yourstruly.vi...@gmail.com>:
>
>
>
> > Whats interesting is that if there is no transaction for a particular
> > @order, then @order.destroy fails. But if there IS a transaction for
> > the given @order, then @order.destroy returns true but the order is
> > still there. It doesnt get deleted!! WEIRD!
>
> > And the logs carry the same queries.. no difference.
> > I have another has_one association on the same Order model but that
> > doesnt give me any of this pain.. i just dont get it..
>
> Have you tried running the (failed) delete sql manually in phpmyadmin
> or whatever to see if it works then?
>
> Colin
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
