I receive this error when trying to upgrade. I mention I just tried to access the admin panel when it took me straight to this upgrade page and when I hit upgrade it guves this error. I mention I do not know SQL. This is for a client. I searched on Google and I couldn't find no answer for this issue
Error Code(0): Error: Can't DROP INDEX `PRIMARY`; check that it exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home3/r80971daic/public_html/system/library/db/mysqli.php on line 40
Well, you did not mention anything about the OC Version used, and what you're trying to upgrade to,
but if you're not familiar with OC at all, you better get professional support on such.
Ernie
https://www.google.com/search?q=Error+N ... encart.com
but if you're not familiar with OC at all, you better get professional support on such.
Ernie
https://www.google.com/search?q=Error+N ... encart.com
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Well, then, next time, at least publish your postings in the correct Forum.
And better talk figures and facts, OC 3.3.x exists in multiple Subversions
already, and Upgrades usually don't work anyway. So, just install a clean
Version, one, that's already proven to work in full, and if you have an older
Version Database, get it upgraded by one of the Professionals, or you
won't get anywhere.
Good Luck!
And better talk figures and facts, OC 3.3.x exists in multiple Subversions
already, and Upgrades usually don't work anyway. So, just install a clean
Version, one, that's already proven to work in full, and if you have an older
Version Database, get it upgraded by one of the Professionals, or you
won't get anywhere.
Good Luck!
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
The latest version is tough to know what version if you do not know ... .the latest "production" is 3.0.3.6.
Also what is Very important is the current OC version. PLUS upgrading OC is NOT an lay persons activity. You MUST know Opencart and be ready to fix any bugs that are introduced from the upgrade.
So that is a long winded way of saying you REALLY should hire someone to perform this upgrade AND REALLY consider WHY you are upgrading.
Mike
cue4cheap not cheap quality
Anybody here knows what he's talking about? Can you actually HELP people?
Does anyone know anything about that error? This is unbelivable, is this the opencart support forum, right? You're a bunch of amateurs... I will not use opencart in the future.. there is no support whatsoever
Error NO. 1091 Has anybody ever heard of this?
Does anyone know anything about that error? This is unbelivable, is this the opencart support forum, right? You're a bunch of amateurs... I will not use opencart in the future.. there is no support whatsoever
Error NO. 1091 Has anybody ever heard of this?
No sorry, 1091 is part of the post-graduate level, amateur classes only cover up to 1085.Error NO. 1091 Has anybody ever heard of this?
Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.
First at all what is the version you are trying to upgrade?buburuzza wrote: ↑Wed Aug 05, 2020 6:35 pmI receive this error when trying to upgrade. I mention I just tried to access the admin panel when it took me straight to this upgrade page and when I hit upgrade it guves this error. I mention I do not know SQL. This is for a client. I searched on Google and I couldn't find no answer for this issue
Error Code(0): Error: Can't DROP INDEX `PRIMARY`; check that it exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home3/r80971daic/public_html/system/library/db/mysqli.php on line 40
Second what is the reason of upgrade?
Third do you have existing database?
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature 
Have a look here https://dba.stackexchange.com/questions ... ql-upgrade maybe it will tell you what to do with 1091buburuzza wrote: ↑Wed Aug 05, 2020 6:35 pmI receive this error when trying to upgrade. I mention I just tried to access the admin panel when it took me straight to this upgrade page and when I hit upgrade it guves this error. I mention I do not know SQL. This is for a client. I searched on Google and I couldn't find no answer for this issue
Error Code(0): Error: Can't DROP INDEX `PRIMARY`; check that it exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home3/r80971daic/public_html/system/library/db/mysqli.php on line 40
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
Guru Member
About 20 years ago when I was young and stupid I got frustrated with a certain version of Linux and started having a go at the developers on IRC. Let's just say it didn't help me get the support I wanted
Really you're trying to do something that requires a developer so you could pay a developer such as ourselves or post a job in the Commercial Support Forum.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member
It's a database error. The upgrade script is trying to remove an index key named 'PRIMARY' from the oc_category table of your database. For whatever reason your database was not able to do it. Could be a corrupt database among other things. I would first check the oc_category table in phpMyAdmin or similar and check the Indexes in the Structure tab.buburuzza wrote: ↑Wed Aug 05, 2020 6:35 pmI receive this error when trying to upgrade. I mention I just tried to access the admin panel when it took me straight to this upgrade page and when I hit upgrade it guves this error. I mention I do not know SQL. This is for a client. I searched on Google and I couldn't find no answer for this issue
Error Code(0): Error: Can't DROP INDEX `PRIMARY`; check that it exists
Error No: 1091
ALTER TABLE `oc_category` DROP PRIMARY KEY, ADD PRIMARY KEY(`category_id`, `parent_id`) in /home3/r80971daic/public_html/system/library/db/mysqli.php on line 40
Try to repair the database from your hosting control panel tooADD Creative wrote: ↑Thu Aug 06, 2020 9:05 pmIt's a database error. The upgrade script is trying to remove an index key named 'PRIMARY' from the oc_category table of your database. For whatever reason your database was not able to do it. Could be a corrupt database among other things. I would first check the oc_category table in phpMyAdmin or similar and check the Indexes in the Structure tab.
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
And you say this is for a client which means your probably getting paidbuburuzza wrote: ↑Thu Aug 06, 2020 3:20 pmAnybody here knows what he's talking about? Can you actually HELP people?
Does anyone know anything about that error? This is unbelivable, is this the opencart support forum, right? You're a bunch of amateurs... I will not use opencart in the future.. there is no support whatsoever
Error NO. 1091 Has anybody ever heard of this?
So I wouldn’t moan at people trying to help you for free!!!!!
Well, it must be a frustrating experience, after expecting, to finally have found a
free software heaven, to then still be confronted with real Earth Reality.
Good to have this function, in order to avoid, beeing confronted with such again ...
download/file.php?mode=view&id=39547
free software heaven, to then still be confronted with real Earth Reality.
Good to have this function, in order to avoid, beeing confronted with such again ...
download/file.php?mode=view&id=39547
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
That's a good news indeed buburuzza!
Kindly add the word [SOLVED] into the beginning of post title.
Thanks
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
