soonerash Posted March 18, 2007 Posted March 18, 2007 I'm helping out a guy who is using OSCommerce on a site he has hosted through GoDaddy. Everything was working fine until this past week. Now, every few orders or so, the customer will get the following error: 2013 - Lost connection to MySQL server during query insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values (blah blah blah...all values to fields above) [TEP STOP] 2006 - MySQL server has gone away select count(*) as total from sessions where sesskey = 'ad1ebbd4a72c95f5e8764d55ba35e9d4' [TEP STOP] Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0 I've called GoDaddy about it and they are saying that the OSCommerce code needs to be "optimized." I explained that everything has been fine up until this past week, but since my friend isn't using GoDaddy's shopping cart or merchant account, they refuse to help. They were down BIG TIME on Sunday and I think again Wednesday due to a denial of service attack, so I don't know if this problem is related to any changes they may have made to their servers' communication. They wouldn't admit to the ddos attack over the phone, however the problem is widely reported on the internet at reputable news sites. The customers' also occasionally get the error "unable to find checkout_success.php". BUT the next 5 customers are able to make an order without any problems. Another really strange thing that is happening is that Authorizenet AIM has order id's that are not unique compared to other orders in the orders table. It seems that the orders that can't be inserted into the orders table, according to the insert error above, stay in the Authorize.net system, but the OSCommerce code frees up the order_id for the next sucessful order. Any assistance or suggestions to what the problem is would be greatly appreciated. Much Thanks, Ash
Nullachtfuffzehn Posted March 18, 2007 Posted March 18, 2007 The DOS attack is probably the reason for the issue. DOS attacks usually try to take the servers to their limit until they refuse to answer. Due to that behaviour the database server might answer too late as well as the webserver. The error "unable to find checkout_success.php" points to that direction. Wait till they got it fixed and anything should be fine again.
Guest Posted March 18, 2007 Posted March 18, 2007 I've called GoDaddy about it and they are saying that the OSCommerce code needs to be "optimized." I explained that everything has been fine up until this past week, but since my friend isn't using GoDaddy's shopping cart or merchant account, they refuse to help. They were down BIG TIME on Sunday and I think again Wednesday due to a denial of service attack, so I don't know if this problem is related to any changes they may have made to their servers' communication. They wouldn't admit to the ddos attack over the phone, however the problem is widely reported on the internet at reputable news sites. The host's speed is one thing along with such problems. But if your store has many products/categories you should start considering using some advance cache modules (check the contributions) and if your store has booming sales you could move to a dedicated sever as you should be able to afford it.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.