Upgrade 3.0.3.6 Error No: 1091
Posted: Mon Nov 16, 2020 3:10 am
Hi, After change the plan shared to vps server during updated opencart 3.0.3.6 found the below error
Error Code(0): Error: Can't DROP 'PRIMARY'; check that column/key exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home/xxxx/public_html/system/library/db/mysqli.php on line 40

Please assist. how to fix this issue.
Error Code(0): Error: Can't DROP 'PRIMARY'; check that column/key exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home/xxxx/public_html/system/library/db/mysqli.php on line 40
Please assist. how to fix this issue.