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 just started over with a fresh install of 0.9.7 with a new empty database.

    I checked out the latest version from SVN and did the build.

    The install went without a hitch but for testing purposes, I immediately ran an upgrade install and got these errors:

    Error upgrading table for class modResource
    Array
    (
    [0] => 00000
    )
    
    
    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'
    )
    
    
    Successfully upgraded table for class modUserGroup
    Added new index on `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] => 00000
    [1] => 1060
    [2] => Duplicate column 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'
    )


    I had been getting those errors before and thought it meant I had a corrupted install. Is this just a bug in the upgrade install that hasn’t been fixed yet (or yet another MySQL 5.0.51 bug)?

    MODx 0.9.7-alpha (according to the System Info page)
    Apache 2.2.6
    Php5.2.5
    MySQL 5.0.51 (I know, I know)
    Windows Vista


    Bob
      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
      These are just attempting to update tables that are up to date. In the original MODx, these were suppressed, but currently in 0.9.7 they are being shown, but as long as they are not red and it doesn’t make you retry the install, all is well.
        • 3749
        • 24,544 Posts
        Quote from: OpenGeek at Feb 24, 2008, 12:29 AM

        These are just attempting to update tables that are up to date. In the original MODx, these were suppressed, but currently in 0.9.7 they are being shown, but as long as they are not red and it doesn’t make you retry the install, all is well.

        They *are* in red but I got the continue button so I imagine things are ok.

        Bob
          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
          Let me clarify; as long as the background of the message is not red (the background should be white on these), all is well. We should probably style these warnings (vs errors) as hidden by default with links to expand the message.
            • 3749
            • 24,544 Posts
            Quote from: OpenGeek at Feb 24, 2008, 03:36 PM

            Let me clarify; as long as the background of the message is not red (the background should be white on these), all is well.
            Yup. Red text on white background. The successes are on a green background.
              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