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?