We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 31389
    • 4 Posts
    Firstly I’d like to thank the developers for addressing the TinyMCE bug with languages! Now it works perfectly smiley

    Today I finally upgraded my site’s MODx (Advanced) from 2.0.0-pl to 2.0.7-pl and everything runs smoothly except for FC. Not only that all the form rules that I had before misteriously disappeared, but also it seems that I cannot create any new rule! sad I just keep getting an error message whenever I attempt to save the rule, no matter what it contains. Also I noticed these errors in my log:

    (ERROR @ /connectors/security/forms/rule.php) Error 42S22 executing statement: 
    Array
    (
        [0] => 42S22
        [1] => 1054
        [2] => Unknown column 'rank' in 'order clause'
    )
    
    (ERROR @ /connectors/security/forms/rule.php) Error 42S22 executing statement:
    INSERT INTO `modx_actiondom` (`set`, `action`, `name`, `description`, `xtype`, `container`, `rule`, `value`, `constraint`, `constraint_field`, `constraint_class`, `active`, `for_parent`, `rank`) VALUES (0, 51, 'modx-resource-settings', '', '', '', 'tvMove', 'test', '', '', '', 1, 0, 0)
    Array
    (
        [0] => 42S22
        [1] => 1054
        [2] => Unknown column 'rank' in 'field list'
    )
    
    (ERROR @ /manager/index.php) Error 42S22 executing statement: 
    Array
    (
        [0] => 42S22
        [1] => 1054
        [2] => Unknown column 'modActionDom.rank' in 'order clause'
    )
    
    


    My configuration (shared hosting):
    OS: Ubuntu 5.10
    Server: Apache 2.2.8
    PHP: 5.2.4 (pdo_mysql installed)
    MySQL: 5.0.51a
    Browser: Firefox 3.6 / Chrome 8.0

    I don’t have any clue of what’s causing this huh so... please help!!
      • 31389
      • 4 Posts
      It’s just starting to get some sense... I looked into mysql table modx_actiondom and it really doesn’t have this new column ’rank’ (is this a bug in setup?).

      So I’ve added it manually (int(11), no default value), but could someone check this, please? What is it for anyway?
        • 11076
        • 159 Posts
        There were many changes from 2.0.0-pl to 2.0.7-pl especially with FC.
        FYI, http://rtfm.modx.com/display/revolution20/Upgrading+from+Versions+Earlier+than+2.0.5
          Michael Shraibman( gOmp)  | Freelance Design & Development | wink  impossible is nothing...
          • 31389
          • 4 Posts
          Quote from: gOmp at Jan 15, 2011, 11:13 AM

          There were many changes from 2.0.0-pl to 2.0.7-pl especially with FC.
          FYI, http://rtfm.modx.com/display/revolution20/Upgrading+from+Versions+Earlier+than+2.0.5

          Yes, I had been aware of that before I upgraded wink

          Update: After the above fix my old rules showed up in the list and there are no more errors, but they don’t seem to work sad I’ll look into that now...