Duplicate Order (Twice Order)

Hello!
Firstly so sorry for my bad English.

I'm getting some duplicate order error in the last few days. I'm using Opencart 1.5.1.3.1 (extra addons, Payu Payment Gateway and Sukerfish Category Menu).

Not always, but some times, a customer when submit an order, it is duplicated (twice record for this order but it's have different Order ID).

When I check error log txt, below records exist (also please look screenshot for Admin Orders Table):

Errors.txt Content
Maybe related for HUSEYIN BALCI ( Orders 2718 & 2720)
2015-02-26 14:15:17 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM customer WHERE LOWER(email) = 'balci324@xxx.com' AND password = '850c3eb4515862444f83e3e2a6836b13' AND status = '1' in /home/xxx/public_html/system/database/mysql.php on line 49


Maybe related for ALI OSMAN AVCI ( Orders 2722 & 2723)
2015-03-01 13:31:07 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT os.name FROM `order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `order` o WHERE o.order_id = '2722' in /home/xxx/public_html/system/database/mysql.php on line 49

2015-03-01 13:36:23 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT os.name FROM `order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `order` o WHERE o.order_id = '2723' in /home/xxx/public_html/system/database/mysql.php on line 49


Maybe related for HUSEYIN YILMAZ ( Orders 2725 & 2725)

2015-03-04 13:49:53 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT os.name FROM `order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `order` o WHERE o.order_id = '2725' in /home/xxx/public_html/system/database/mysql.php on line 49


Maybe related for DERYA MURATLI ( Orders 2734 & 2735)
2015-03-16 5:14:18 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT os.name FROM `order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `order` o WHERE o.order_id = '2734' in /home/xxx/public_html/system/database/mysql.php on line 49

2015-03-16 5:29:55 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT os.name FROM `order_status` os WHERE os.order_status_id = o.order_status_id AND os.language_id = o.language_id) AS order_status FROM `order` o WHERE o.order_id = '2735' in /home/xxx/public_html/system/database/mysql.php on line 49

"PHP Notice: Error: MySQL server has gone away"

Means just that.... the server has gone away. It is normally a web host problem from an overused or unreliable server. Check with your webhost.

The duplicate order might be because the customer sees the page goes blank and re-submits it. (maybe).

Mike

I asked my hosting provider (siteground) and ansver is:

I would also like to notice that the MySQL server has gone away error usually appears when a website is producing too long queries.

This can happen with either an application that is not optimized or a large database.

I have checked and noticed the following slow queries from your application:

Code: Select all

19920 # Time: 150317 16:38:11
19921 # User@Host: xxx[xxx] @ localhost []
19922 # Thread_id: 39451817 Schema: Last_errno: 0 Killed: 0
19923 # Query_time: 1.554526 Lock_time: 0.000125 Rows_sent: 2730 Rows_examined: 2730 Rows_affected: 0 Rows_read: 2730
19924 # Bytes_sent: 1542075
19925 SET timestamp=1426624691;
19926 SELECT * FROM `xxxx_xxx`.`order`;


19927 # Time: 150317 16:38:13
19928 # User@Host: xxx[xxx] @ localhost []
19929 # Thread_id: 39451817 Schema: Last_errno: 0 Killed: 0
19930 # Query_time: 1.686114 Lock_time: 0.000071 Rows_sent: 23610 Rows_examined: 23610 Rows_affected: 0 Rows_read: 23610
19931 # Bytes_sent: 2777296
19932 SET timestamp=1426624693;
19933 SELECT * FROM `xxxx_xxx`.`order_option`;
19934 # Time: 150317 16:38:15
19935 # User@Host: xxx[xxx] @ localhost []
19936 # Thread_id: 39451817 Schema: Last_errno: 0 Killed: 0
19937 # Query_time: 2.557006 Lock_time: 0.000139 Rows_sent: 26848 Rows_examined: 26848 Rows_affected: 0 Rows_read: 26848
19938 # Bytes_sent: 2364159
19939 SET timestamp=1426624695;
19940 SELECT * FROM `xxxx_xxx`.`order_product`;
19941 # Time: 150317 16:38:20
19942 # User@Host: xxx[xxx] @ localhost []
19943 # Thread_id: 39451817 Schema: Last_errno: 0 Killed: 0
19944 # Query_time: 1.329520 Lock_time: 0.000087 Rows_sent: 12902 Rows_examined: 12902 Rows_affected: 0 Rows_read: 12902
19945 # Bytes_sent: 769999
19946 SET timestamp=1426624700;
19947 SELECT * FROM `xxxx_xxx`.`product_option_value`;

I would suggest that you contact your developer or the Open Cart community for further assistance on what you can do to optimize the queries produced by the application.

thanks for your answers, any other advice?

i have the same problem with O.C. 2.0.1.1
But in my case it does`nt shows the duplicate orders in the admin/order i have to search it in the database.
But not with all the orders. only with some of them .. and i can`t find a solution for this ..
someone else have the same problem. ?