Upgrade 3.0.3.6 Error No: 1091

Post Reply

3 posts Page 1 of 1

ahimanshu

Newbie

Posts

Joined

Mon Jul 10, 2017 10:55 am

Location

New Delhi

Post by ahimanshu » 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.

Last edited by ahimanshu on Mon Nov 16, 2020 5:38 am, edited 1 time in total.

Regards
Himanshu

ahimanshu

Newbie

Posts

Joined

Mon Jul 10, 2017 10:55 am

Location - New Delhi

Re: Upgrade 3.0.3.6 Error No: 1091

straightlight

Legendary Member

Posts

17480

Joined

Mon Nov 14, 2011 11:38 pm

Location

Canada, ON

Post by straightlight » Mon Nov 16, 2020 4:30 am

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.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight

Legendary Member

Posts

17480

Joined

Mon Nov 14, 2011 11:38 pm

Location - Canada, ON

Re: Upgrade 3.0.3.6 Error No: 1091

straightlight

Legendary Member

Posts

17480

Joined

Mon Nov 14, 2011 11:38 pm

Location

Canada, ON

Post by straightlight » Mon Nov 16, 2020 7:28 pm

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).

straightlight

Legendary Member

Posts

17480

Joined

Mon Nov 14, 2011 11:38 pm

Location - Canada, ON

Post Reply