Page 1 of 1

Upgrade 3.0.3.6 Error No: 1091

Posted: Mon Nov 16, 2020 3:10 am
by ahimanshu
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
Image
Please assist. how to fix this issue.

Re: Upgrade 3.0.3.6 Error No: 1091

Posted: Mon Nov 16, 2020 4:30 am
by straightlight
Either create a new service request in the Commercial Support section of the forum, or contact an Opencart partner by using the Resources link at the top of the site, or contact me directly via PM to get this done as a custom job.

Re: Upgrade 3.0.3.6 Error No: 1091

Posted: Mon Nov 16, 2020 7:28 pm
by straightlight
Custom job completed. Nothing to do with an upgrade. Store is already upgraded. .htaccess / server cache issue. OP user is using a VPS server IND (equivalent to shared server elsewhere).