Upgrading from 1.9.16 to 2.2
Linux, Apache, MySQL
- used xml editor to clean DB prior to upgrade
- upgrade started, system check OK but stopped about 10 minutes in with the many duplicate entry errors:
DDL sql execution error
Debug info: Duplicate entry '20470-blogpagesize' for key 'mdl_userpref_usenam_uix'
CREATE UNIQUE INDEX mdl_userpref_usenam_uix ON mdl_user_preferences (userid, name)
I can go through and remove all the duplications manually but the upgrade continues to halt on new records. I have no idea how many records have these duplicate entries so doesn't seem realistic to have to remove each one manually.
- has a non-specific relationship to
-
MDL-31337 Database error when doing a selective restore
-
- Closed
-
- is duplicated by
-
-
- Closed
-