Can't set form to Hard in Mysql

Ticket

+commit
 

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.

 

 

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