We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 3749
    • 24,544 Posts
    I updated a recent clean checkout to 3924 and, when I tried to log in, it didn’t recognize the admin username.

    I did a build and an upgrade install, which generated these errors (most are the usual, but some are SQL syntax errors where the column name is always set to ’e’).

    #
    
    Error upgrading table for class modResource
    Array
    (
    [0] => 42000
    [1] => 1091
    [2] => Can't DROP 'content_ft_idx'; check that column/key exists
    )
    #
    
    Error upgrading table for class modResource
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'content_type'
    )
    #
    
    Error upgrading table for class modUserGroup
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'parent'
    )
    #
    
    Error upgrading table for class modUserGroup
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'parent'
    )
    #
    
    Error upgrading table for class modUserGroupMember
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'role'
    )
    #
    
    Error upgrading table for class modUserGroupMember
    Array
    (
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'role'
    )
    #
    
    Error upgrading table for class modModule
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'disabled'
    )
    #
    
    Error upgrading table for class modUser
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'cachepwd'
    )
    #
    
    Successfully upgraded table for class modActiveUser
    Modified modActiveUser `action` field to allow longer action labels
    #
    
    Error upgrading table for class modAction
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'lang_foci'
    )
    #
    
    Error upgrading table for class modSystemSetting
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'setting_name' in 'modx_system_settings'
    )
    #
    
    Error upgrading table for class modSystemSetting
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'setting_value' in 'modx_system_settings'
    )
    #
    
    Error upgrading table for class modSystemSetting
    Array
    (
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `namespace` VARCHAR(40) NOT NULL DEFAULT 'core'
    ADD COLUMN `e' at line 2
    )
    #
    
    Error upgrading table for class modContextSetting
    Array
    (
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `namespace` VARCHAR(40) NOT NULL DEFAULT 'core'
    ADD COLUMN `e' at line 3
    )
    #
    
    Error upgrading table for class modUserSetting
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'setting_name' in 'modx_user_settings'
    )
    #
    
    Error upgrading table for class modUserSetting
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'setting_value' in 'modx_user_settings'
    )
    #
    
    Error upgrading table for class modUserSetting
    Array
    (
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD COLUMN `namespace` VARCHAR(40) NOT NULL DEFAULT 'core'
    ADD COLUMN `e' at line 3
    )
    #
    
    Error upgrading table for class modManagerLog
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'class_key' in 'modx_manager_log'
    )
    #
    
    Error upgrading table for class modUserMessage
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'postdate' in 'modx_user_messages'
    )
    #
    
    Error upgrading table for class modUserMessage
    Array
    (
    [0] => 00000
    [1] => 1054
    [2] => Unknown column 'postdate' in 'modx_user_messages'
    )
    #
    
    Error upgrading table for class modUserMessage
    Array
    (
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'messageread' in 'modx_user_messages'
    )


    Trying to log into the manager I get this:

    Fatal error: Call to undefined method modRequest::initialize() in C:\xampp\htdocs\NewM097\manager\index.php on line 77

    It happens in both IE7 and FF. I tried deleting the cache files and clearing the browser cache but get the same error.

    I can do a full install or a new checkout, but someone should try doing an upgrade install to make sure it’s not just my setup.
      Did I help you? Buy me a beer
      Get my Book: MODX:The Official Guide
      MODX info for everyone: http://bobsguides.com/modx.html
      My MODX Extras
      Bob's Guides is now hosted at A2 MODX Hosting
      • 22303 MODX Staff
      • 10,725 Posts
      Yeah, I think I hosed it...working on it...
        • 22303 MODX Staff
        • 10,725 Posts
        Quote from: OpenGeek at Aug 14, 2008, 03:22 PM

        Yeah, I think I hosed it...working on it...
        Maybe not; have a problem on new install at the moment where the language strings are not getting installed, but after an upgrade install it corrects itself. Do you have any access permissions set in your configuration? If so, what are they?
          • 3749
          • 24,544 Posts
          I’ve never messed with the access permissions, so they’re the defaults and are unchanged. If you mean file and directory access permissions, it’s a Windows box so I’ve never had to touch them (and I wouldn’t think they would cause SQL syntax errors).
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting
            • 22303 MODX Staff
            • 10,725 Posts
            Quote from: BobRay at Aug 14, 2008, 04:06 PM

            I’ve never messed with the access permissions, so they’re the defaults and are unchanged. If you mean file and directory access permissions, it’s a Windows box so I’ve never had to touch them (and I wouldn’t think they would cause SQL syntax errors).
            I did not mean file/dir permissions on the OS, I meant the MODx Access Permissions. Hmmm...I can’t imagine why it would not work, make sure to clear your sessions after the upgrade. You can truncate the modx_sessions table to force the issue.
              • 22303 MODX Staff
              • 10,725 Posts
              I think I found the culprit; can you update from SVN again and see if another run at the upgrade resolves the issue for you?
                • 3749
                • 24,544 Posts
                Quote from: OpenGeek at Aug 14, 2008, 05:55 PM

                I think I found the culprit; can you update from SVN again and see if another run at the upgrade resolves the issue for you?

                Sorry, looks like the same error message and same result:

                Fatal error: Call to undefined method modRequest::initialize() in C:\xampp\htdocs\NewM097\manager\index.php on line 77
                  Did I help you? Buy me a beer
                  Get my Book: MODX:The Official Guide
                  MODX info for everyone: http://bobsguides.com/modx.html
                  My MODX Extras
                  Bob's Guides is now hosted at A2 MODX Hosting
                  • 3749
                  • 24,544 Posts
                  Quote from: BobRay at Aug 14, 2008, 06:56 PM

                  Quote from: OpenGeek at Aug 14, 2008, 05:55 PM

                  I think I found the culprit; can you update from SVN again and see if another run at the upgrade resolves the issue for you?

                  Sorry, looks like the same error message and same result:

                  Fatal error: Call to undefined method modRequest::initialize() in C:\xampp\htdocs\NewM097\manager\index.php on line 77


                  More news. I did a fresh checkout in a new directory with a new database.

                  Build ok.
                  Install ok.
                  Login ok.
                  logout ok.
                  Ugrade install - all the same errors as before - including the SQL syntax errors.
                  Login ok !!!!

                  My previous install (also clean) is still hosed. I guess it could be a corrupt checkout. Let me know if you want to do any more testing on that install.

                    Did I help you? Buy me a beer
                    Get my Book: MODX:The Official Guide
                    MODX info for everyone: http://bobsguides.com/modx.html
                    My MODX Extras
                    Bob's Guides is now hosted at A2 MODX Hosting
                    • 22303 MODX Staff
                    • 10,725 Posts
                    No, I’m now reproducing your errors BobRay. Seems my security updates have raised a huge mutiny in the upgrade installation. Since contexts are now secured, it seems the installation process does not have permission to read the modContext objects from the database. LOL. Coded myself into a corner on this one; ugh!

                    I’m working it out by giving the installation process a mock principal (aka user) with the proper attributes to manipulate the objects and will commit once I confirm it works.
                      • 3749
                      • 24,544 Posts
                      Everything is copacetic now @ 3933. grin grin grin
                        Did I help you? Buy me a beer
                        Get my Book: MODX:The Official Guide
                        MODX info for everyone: http://bobsguides.com/modx.html
                        My MODX Extras
                        Bob's Guides is now hosted at A2 MODX Hosting