I’m surprised this didn’t happen sooner. I’ve trashed my 0.9.7 site.
I decided I might as well be working with the current build so I did an SVN Update of everything to 3372.
I could log in, but the Manager was unusable in both FF and IE7.
I did an upgrade install (checked the two checkboxes) and got this:
Error upgrading table for class modResource
Array
(
[0] => 42S21
[1] => 1060
[2] => Duplicate column name 'content_type'
)
#
Successfully upgraded table for class modResource
Added new `content_ft_idx` full-text index on the fields `pagetitle`, `longtitle`, `description`, `introtext`, `content`.
#
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'
)
Manager still unusable.
I re-did the build and did another upgrade install and got the same error messages.
Manager even more unusable (the right panel fills the screen - no document tree - no toolbar). If I click on Resources, I can see the resources but can’t edit most of them.
The site is still there and looks the same, so it’s only the Manager that’s hosed. I didn’t try to clear the cache (can’t do it in the Manager and don’t know which cache files are safe to empty). Shouldn’t an upgrade install automatically clear the cache?
Any advice appreciated (before I start to rebuild the site from scratch).
Bob
☆ A M B ☆
MODX Staff