Author Topic: SQL Error with Duplicate Entry Problem  (Read 6749 times)

Offline Kat8990

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
SQL Error with Duplicate Entry Problem
« on: July 20, 2016, 12:20:20 PM »
Every time I do a test order and create a customer with a fake email I get some kind of duplicate error message like the following:

SQL Error: Duplicate entry '205106-1' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO abwk_order_data (`order_id`, `type_id`, `data`, `date_added`) VALUES (205106, 1, 'a:2:{s:3:\"uri\";s:16:\"glogan@email address\";s:6:\"status\";s:1:\"1\";}', NOW() ) in home/smallbu4/public_html/WEBSITE NAME/core-database-amysqli.php on line 106   

The error message is telling me about a problem in the amysqli.php file. How do I fix this problem?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 6144
  • Karma: +284/-2
    • View Profile
Re: SQL Error with Duplicate Entry Problem
« Reply #1 on: July 21, 2016, 01:32:03 AM »
Hello.
What is your AbanteCart version?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2174
  • Karma: +345/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error with Duplicate Entry Problem
« Reply #2 on: July 21, 2016, 04:38:16 AM »
1. what order type do you tried to insert? i mean data of "order_data_types" table.
2. What shipping and payment methods do you use?
3. please describe step-by-step your actions to replicate this error.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Kat8990

  • Newbie
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Re: SQL Error with Duplicate Entry Problem
« Reply #3 on: July 24, 2016, 11:26:27 AM »
Here are the answers to the questions:
What is your AbanteCart version? 1.2.7

1. what order type do you tried to insert? i mean data of "order_data_types" table.
I was simply trying to create an order - inserted the name, address, email address

2. What shipping and payment methods do you use?
I use paypal standard and bank transfer. Shipping is Free Shipping on all products.

3. please describe step-by-step your actions to replicate this error.
I go to website and click on product item. Then put it in cart. Go to checkout and click on guest account. I insert the information such as name, address, email address. Click on continue  and then see error message.


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2174
  • Karma: +345/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error with Duplicate Entry Problem
« Reply #4 on: July 26, 2016, 07:22:34 AM »
please replace file public_html/storefront/model/checkout/order.php with attached and let us know

“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod