I have an older site I'm upgrading.
Currently running installer. Everything has check out fine, but when I run the installer, I get this message:
- - - -
MODx setup couldn't install/alter some tables inside the selected database.
The following errors had occurred during installation
Duplicate entry '2-0' for key 2 during the execution of SQL statement ALTER TABLE `modx_web_groups` ADD UNIQUE INDEX `ix_group_user` (`webgroup`,`webuser`).
- - - -
Can anyone explain what needs to be done so I can upgrade this site? My 'modx_web_groups' table has 118 entries. There is no id 2?
[ed. note: mtbinary last edited this post 14 years, 10 months ago.]
should I be upgrading from 0.9.5 to 0.9.6 first?
From the command line error noted above, it looks like the installer is attempting to modify
'modx_web_groups' by adding 'ix_group_user" - would the install work if I added it manually? ...anyone?
I've reverted to the original files and suspended my upgrade, but I hope somebody can help me hurdle this issue...