Ticket
Can't set form to Hard in Mysql+issues
I'm using svn trunk, r694. I cannot seem to set the a +*rform to Hard, which prevents my having plus cards that are Searches. In particular, I can't seem to change it for Search cards (e.g. designs_for_status+*rform). I change to Hard, click Save... and it doesn't get saved. Marked urgent since this will likely affect 0.10 (plus I want to demo wagn to my company next week!).
I'm running with MySQL 5.0, ruby 1.8, rails 2.0.2.
Can't set form to Hard in Mysql+example
Here's what the log says:
# Logfile created on Fri Jul 18 17:30:24 -0400 2008
ActiveRecord::StatementInvalid (Mysql::Error: #HY000You can't specify target table 't' for update in FROM clause: update cards t set references_expired=1 where (t.tag_id in (select id from cards tx where tx.id = '53' and tx.trash='f' ))):
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:281:in `execute'
/app/models/card/templating.rb:148:in `expire_templatee_references'
/app/models/card/references.rb:19:in `update_references_on_update'
(more in changes history)
This page seems to describe the issue:
http://www.xaprb.com/blog/2006/06/23/how-to-select-from-an-update-target-in-mysql/
Changed priority to high. We use urgent only for items that are so critical that we'll drop everything else to work on them. I hear that it's urgent for you, and right now there are just other things that are even more important to us - like getting Wagn 0.10 out.
--John Abbe.....Thu Jul 24 14:03:33 -0700 2008
Also tagged it Connectipedia, as they are likely to want it if shifting to mysql depends on this.
--John Abbe.....Thu Jul 24 14:04:13 -0700 2008
no longer have hard forms. closing.
--Ethan McCutchen.....Tue May 11 14:33:47 -0700 2010