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
Image
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


User avatar
Newbie

Posts

Joined
Mon Jul 10, 2017 10:55 am
Location - New Delhi

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


Legendary Member

Posts

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

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 5 guests