• View
  • Changes
  • Options
  • Related
  • Edit
  • , ,  Add +commit
     
  • View
  • Changes
  • Options
  • Related
  • Edit
  • 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.

     

    Add +solution

     

  • View
  • Changes
  • Options
  • Related
  • Edit
  • 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)

     

    Related support tickets: 
    Relevant user stories: 
     add one

  • View
  • Changes
  • Options
  • Related
  • Edit
  • 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

     

    Notes

    add a note

    Download Docs Sandbox Hosting Support

  • View
  • Changes
  • Options
  • Related
  • Edit
  •  

    Wagn News

    1 to 5 of 24Next-page 1 to 5 of 24Next-page

     

    Ideas

     

     

    Support Tickets



    Wagn at github

    Wheeled by Wagn v. 1.7.2