Post by Kayram » Thu Mar 19, 2015 11:20 pm

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

Attachments

siparisler.jpg

Admin Orders Table for Duplicated Orders Records - siparisler.jpg (288.7 KiB) Viewed 1120 times


Newbie

Posts

Joined
Mon Jul 18, 2011 4:12 pm

Post by Cue4cheap » Fri Mar 20, 2015 5:36 am

"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

cue4cheap not cheap quality


Active Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by Kayram » Tue Mar 24, 2015 3:32 pm

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.

Newbie

Posts

Joined
Mon Jul 18, 2011 4:12 pm

Post by Kayram » Fri Mar 27, 2015 3:19 pm

thanks for your answers, any other advice?

Newbie

Posts

Joined
Mon Jul 18, 2011 4:12 pm

Post by allexdaemon » Mon Jun 08, 2015 12:32 am

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. ?

Newbie

Posts

Joined
Sat Mar 21, 2015 6:30 pm
Who is online

Users browsing this forum: No registered users and 50 guests