We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 31979
    • 26 Posts
    I tried to install on MySQL 4.0.24_Debian-10sarge1 and got some Errors:

    Two tables could not be created:

    Error creating table for class transport.modTransportPackage

    Error creating table for class transport.modTransportProvider

    and a sql error occurred:

    Error saving the default admin user. Array ( [0] => SQLER [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 ’ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX ` )

    This particular sql-installation would not allow anything but empty in the field "collation" - Maybe this is a hint...
      www.waso.com
    • We likely will not be supporting MySQL before 4.1 with MODx 0.9.7, nor with xPDO 1.0.
        • 34162
        • 1 Posts
        Downloaded and installed Revolution Alpha 2 last week without any problems.

        Next day Alpha 3 was released, so I uploaded the new files and tried to do an upgrade. Unfortunately I got quite a few sql errors:

        Error upgrading table for class modResource
        Array
        (
        [0] => SQLER
        [1] => 1091
        [2] => Can't DROP 'content_ft_idx'; check that column/key exists
        )
        Error upgrading table for class modResource
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'content_type'
        )
        Error upgrading table for class modUserGroup
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'parent'
        )
        Error upgrading table for class modUserGroup
        Array
        (
        [0] => SQLER
        [1] => 1061
        [2] => Duplicate key name 'parent'
        )
        Error upgrading table for class modUserGroupMember
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'role'
        )
        Error upgrading table for class modUserGroupMember
        Array
        (
        [0] => SQLER
        [1] => 1061
        [2] => Duplicate key name 'role'
        )
        Error upgrading table for class modModule
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'disabled'
        )
        Error upgrading table for class modUser
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'cachepwd'
        )
        Error upgrading table for class modAction
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'lang_foci'
        )
        Error upgrading table for class modSystemSetting
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'setting_name' in 'modx_system_settings'
        )
        Error upgrading table for class modSystemSetting
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'setting_value' in 'modx_system_settings'
        )
        Error upgrading table for class modSystemSetting
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'xtype'
        )
        Error upgrading table for class modContextSetting
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'xtype'
        )
        Error upgrading table for class modUserSetting
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'setting_name' in 'modx_user_settings'
        )
        Error upgrading table for class modUserSetting
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'setting_value' in 'modx_user_settings'
        )
        Error upgrading table for class modUserSetting
        Array
        (
        [0] => SQLER
        [1] => 1060
        [2] => Duplicate column name 'xtype'
        )
        Error upgrading table for class modManagerLog
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'class_key' in 'modx_manager_log'
        )
        Error upgrading table for class modUserMessage
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'postdate' in 'modx_user_messages'
        )
        Error upgrading table for class modUserMessage
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'postdate' in 'modx_user_messages'
        )
        Error upgrading table for class modUserMessage
        Array
        (
        [0] => SQLER
        [1] => 1054
        [2] => Unknown column 'messageread' in 'modx_user_messages'
        )
        


        My testing site runs on PHP Version 5.2.4 and MySQL version 4.1.21

        Wouldn’t be a problem clearing the database and doing a new installation, but I should be able to do an upgrade.

        Anyone else experienced these problems or any suggestions what could be wrong?
        • I believe that it’s been mentioned before that upgrades are not doable at this time; you need to do a full new install. It is alpah, after all.
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org
            • 34162
            • 1 Posts
            Thank you for your quick reply.

            You’re right, it’s an alpha release, of course.

            Nevertheless I thought I could perform an upgrade. embarrassed
            • Sorry, didn’t mean to embarrass anybody, just explaining why upgrades don’t work yet.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org
                • 34162
                • 1 Posts
                Sorry if I gave the impression that it was your answer that embarrassed me, but there’s just no [oops] smiley available wink

                Did search the forums, but couldn’t find an answer if an upgrade was possible or not. The installation offered the option, so I presumed it should work. Could have been some bug too, right?

                Anyway, thanks for clarifying.
                • You can run upgrades from previous releases of Revolution.

                  Those SQL warnings that show up during the upgrade are normal, as it’s trying to run alter statements to make sure all the structures are the latest. If you can click next after the install process, then it was successful despite the red letter warnings on a white background. If you get an error, it will not show the Next button for you and you’ll see a red background error box with the error details.
                  • oooh, now I am embarrassed! embarrassed
                      Studying MODX in the desert - http://sottwell.com
                      Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                      Join the Slack Community - http://modx.org
                      • 34162
                      • 1 Posts
                      Quote from: sottwell at Jul 25, 2008, 08:52 PM

                      oooh, now I am embarrassed! embarrassed
                      You can’t know everything, can you?

                      Glad I asked. Guess we both learned something about this grin