AbanteCart Community

Shopping Cart Operations => Support => Topic started by: Kat8990 on July 20, 2016, 12:20:20 PM

Title: SQL Error with Duplicate Entry Problem
Post by: Kat8990 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?

Title: Re: SQL Error with Duplicate Entry Problem
Post by: Basara on July 21, 2016, 01:32:03 AM

Hello.
What is your AbanteCart version?

Title: Re: SQL Error with Duplicate Entry Problem
Post by: abolabo 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.

Title: Re: SQL Error with Duplicate Entry Problem
Post by: Kat8990 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.

Title: Re: SQL Error with Duplicate Entry Problem
Post by: abolabo on July 26, 2016, 07:22:34 AM

please replace file public_html/storefront/model/checkout/order.php with attached and let us know