Greg Willits wrote in post #1109539: > Seems to me acts_as_list has a bug -- I have data where the row id is a > random alphaNumeric, not a simple integer. Using acts_as_list with a > scope of a related model id, acts_as_list crashes the app due to a > faulty query in MySQL something like this: > > Unknown column 'UXPzIdeIuIFkz6n' in 'where clause': UPDATE `line_items` > SET position = (position - 1) WHERE (order_id = UXPzIdeIuIFkz6n AND > position > 5)
Doh!! Gemfile did not have a specified version for acts_as_list and was using an older version. Version 0.2.0 appears to be working fine. With a simple scope, adding/deleting are working as I need them too. -- gw -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/079b1de9022af0dd2bdd5e9290ae5f23%40ruby-forum.com?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.