Ok, I have backuped up, imported, exported, used a full ftp back, phpadmin, etc.
Went back to months ago before I even saw this error before.
This is what I get when adding a new product.
Fatal error: Uncaught Exception: Error: Duplicate entry '776-1' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO oc_product_description SET product_id = '776', language_id = '1', name = 'Egyptian Musk Incense Sticks - 13 Sticks ', description = '<h3 align="center"><span style="font-weight: bold;">Egyptian Musk Incense Sticks - 13 Sticks</span></h3><h3 align="center"><span style="font-weight: bold;">Bring the romance and the exotic into your life with these Egyptian&nbsp;Musk incense cones.</span><span style="font-weight: bold;"><br></span></h3><h3 align="center"><span style="font-weight: bold;">This unique incense is perfect during meditation, yoga or enlightenment exercises. Or, simply enjoy this&nbsp;aromatherapy&nbsp;fragrance in your&nbsp;home or office - allowing the art of incense burning to fragrance the air as well as lift &amp; cleanse energy in /home/ardragifts/public_html/system/library/db/mysqli.php on line 40
Any ideas on what I am doing wrong? This is a new error I never had over the years.
Thanks so much
Nancy
ardragifts.com
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
So maybe you are not dropping/creating the database or you should use update instead of insert or insert with on duplicate key.
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.
When adding a new product it should add to the END of my product IDs which is over 1500 … not sure why it tries to add to an existing ID.
I used excelport and exported products... then added a new products and exported products again. It IS adding it as a new product ID... grrrrr
this is frustrating.. how am I getting duplicate errors. This error happened on a working database and I didn't use excelport import months before this.
Sigh
You insert sql specifically states to insert a product description record with product_id X and language_id Y.
If that combination already exists the database will not go "oh shit, I already have that one, let me get you a new one..."
It spits out an error, as it should.
So either excelport does not work properly (which I doubt) or you are editing the sheets wrong.
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.
Users browsing this forum: No registered users and 280 guests