We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 36571
    • 145 Posts
    I installed a fresh version of 0.9.7 alpha-1, but I was having some problems so I decided to reinstall.

    So I ran /setup again, having changed nothing at all. In the Intallation summary most things install fine, but I get the following error messages in there:

    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’
    )
    #

    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’
    )
    #

    Error upgrading table for class modActiveUser
    Array
    (
    [0] => 00000
    [1] => 1060
    [2] => Duplicate column name ’cachepwd’
    )
    #

    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] => 42S21
    [1] => 1060
    [2] => Duplicate column name ’xtype’
    )
    #

    Error upgrading table for class modContextSetting
    Array
    (
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name ’xtype’
    )
    #

    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] => 42S21
    [1] => 1060
    [2] => Duplicate column name ’xtype’
    )
    #

    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’
    )

    Don’t know if this is something I have done, or if it is a bug in the install script.
    • It’s not a bug; those are upgrade script attempts that are failing because your database is already current. These red on white background "errors" are actually warnings that will be hidden in the future. They are mostly there to let you know that the upgrade is attempting to bring your table structures up-to-date.
        • 36571
        • 145 Posts
        OK, cool.

        Cheers Jason.