oseymour Posted October 23, 2007 Share Posted October 23, 2007 Ia m getting that error when a customer clicks on the confirm order button. The store has been active for months and has done thousands in sales, A customer informed me this morning of the error 2013 - Lost connection to MySQL server during query nsert 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_cvv, cc_expires, date_purchased, orders_status, currency, currency_value) values (then it gives the values here) I am getting the emails from authorize.net and the site but the customer is seeing that error... Please help. My site is hosted with Godaddy... Link to comment Share on other sites More sharing options...
vlad_bel Posted October 24, 2007 Share Posted October 24, 2007 i have exactly same error for last days or even few weeks, hard to say because customers do not complain. they just get out and only some of them blame computer and try many times. then i get many payments and no order in data base. i use paypal wpp for cc payments with the code fix in pear\Services\PayPal\SOAP\Transport\HTTP.php for godaddy's proxy. checkout worked fine last night and it works this night. It consistently failed on day time yesterday and today - none successful out of a dozen attempts. godaddy servers are pretty fast. i recently moved from 1and1 just for the speed. i got speed but lost sales. :lol: what i see is that right after having success with payment, program looses connection with sql server when makes order record in db (the one mentioned in the above message). i tried to increase timeouts, id had no effect. somewhere 30sec is the time when connection gets lost. i even shorted out that query but did not see any difference. then i called godaddy support. i said, it does not work during the day only. the answer was that everything is ok with sql server and the problem is in my script, should be related to AM and PM time confusion. Please, i am looking for right question to ask godaddy. any advise is truly appreciated. Thanks. Link to comment Share on other sites More sharing options...
thatsmywebguy Posted October 24, 2007 Share Posted October 24, 2007 Greetings, I have a customer who is hosted on GoDaddy, using OSCommerce, with PayPal as his payment processor. He just recently started receiving this error. I will contact GoDaddy as well, so they have another record of someone having this problem. Does anyone have any idea why it's happening? Jamie Carter Link to comment Share on other sites More sharing options...
kams912 Posted October 24, 2007 Share Posted October 24, 2007 Same problem here it is no doubt a godaddy problem so don't go changing all of your curl settings, I'm on the phone with them right now. Link to comment Share on other sites More sharing options...
camfam Posted October 24, 2007 Share Posted October 24, 2007 We also have customers reporting this error ove the last couple of days. We are using GoDaddy as our host as well. Link to comment Share on other sites More sharing options...
kams912 Posted October 24, 2007 Share Posted October 24, 2007 Can everyone please tell me what Payment Module you are using, I am using authorize.net AIM Link to comment Share on other sites More sharing options...
oseymour Posted October 24, 2007 Author Share Posted October 24, 2007 so the determining factor is godaddy? I am going to switch hosts and see what happens Link to comment Share on other sites More sharing options...
oseymour Posted October 24, 2007 Author Share Posted October 24, 2007 after spending about an hours on the phone with them...all they could tell me is to reindex my database and try optimizing it....WTF? Link to comment Share on other sites More sharing options...
viper2626 Posted October 24, 2007 Share Posted October 24, 2007 osey, i just went through exactly what you did, i mean do they really believe this is not their problem? i haven't touched my site in 6 months all of a sudden it stops processing orders to give the error listed in this topic and somehow thats my scripts fault. If anyone has a solution for this please post it :) Thank you Link to comment Share on other sites More sharing options...
kams912 Posted October 24, 2007 Share Posted October 24, 2007 I got one lady at godaddy to admit that this is probably a DDOS Attack, I told her if thy don't fix their security soon I would pull all of my domains and hosting accounts. She said it will be fixed within 24 hours. Link to comment Share on other sites More sharing options...
rkowal Posted October 24, 2007 Share Posted October 24, 2007 ahhhh! having the same problem too. has anyone resolved this yet or are we all waiting for godaddy or to move to a new host? thanks! Link to comment Share on other sites More sharing options...
vlad_bel Posted October 25, 2007 Share Posted October 25, 2007 my checkout works now so i cannot call godaddy for help but tomorrow i will. they get overloaded on day time. i can see first fail of this nature on 10/18/07 when i got payments but no record in db and no confirmation email received. it just was not clear what is going on because i switched to godaddy just recently. unlucky place. besides the topic problem i don't see the reason why sales dropped four times since the move. Link to comment Share on other sites More sharing options...
liberty1 Posted October 25, 2007 Share Posted October 25, 2007 Seeing the same thing with the site of one of my clients. The error message is exactly the same and is more noticable during the day. No changes made to the cart recently. Site hosted on Godaddy (shared hosting plan) as well. And like the original poster pointed out started noticing this on 10/18 as well. Godaddy suggested the same BS optimizime your sql tables solution. Perhaps we should call them together, might be more effective. Link to comment Share on other sites More sharing options...
leakwayk Posted October 25, 2007 Share Posted October 25, 2007 Any news on this? I am receiving the same error and I can't keep my live site up like this much longer if it's going to run like this. Link to comment Share on other sites More sharing options...
thatsmywebguy Posted October 25, 2007 Share Posted October 25, 2007 This is what I received from the GoDaddy people: "Thank you for contacting Online Support. The SQL server has infinite timeout, however this problem may be due to too many concurrent connections. You can only have 50 Connections to the MySQL Databases on all Shared Hosting Plans. I apologize for any inconvenience this may cause. " Sounds like a different excuse to me than the previous ones. I don't believe it, frankly. My client's site doesn't get enough traffic to max out the MySQL connections. There's no way. Link to comment Share on other sites More sharing options...
viper2626 Posted October 25, 2007 Share Posted October 25, 2007 It is for sure BS im not on a shared plan i have a Dedicated and Deluxe package with them, no reason for problems, worked fine since i set it up 8 months ago and probably about on the 18th seems like a good guess problems started with this losing connection, I think I am going to move all of my sites and clients sites over to SiteGround, they offer amazing customer support they fix things and are very bright and capable of helping out when needed. GoDaddy has been real crappy all they are good for is being cheap but i think its time to move away from them however a fix for this must exist... they just like to blame us (the customers) ... i'm calling them now... will post what gets done... Link to comment Share on other sites More sharing options...
kams912 Posted October 25, 2007 Share Posted October 25, 2007 I'm on the phone again with them, worked for a bit today, now its down again. I got a cool guy on the phone actually got him into my site and had him re create the error witch it did error. Will keep you informed. Link to comment Share on other sites More sharing options...
viper2626 Posted October 25, 2007 Share Posted October 25, 2007 they "escalated" my problem ... they naturally just blame MY script which is a load of crap times out after 15 seconds cause of their crappy servers very frustrating... Link to comment Share on other sites More sharing options...
vlad_bel Posted October 25, 2007 Share Posted October 25, 2007 is there the way to increase timeout in the code where checkout does write to db? Link to comment Share on other sites More sharing options...
thatsmywebguy Posted October 26, 2007 Share Posted October 26, 2007 You won't believe what GoDaddy has been trying to say. Check this out: "Thank you for contacting Online Support. The SQL server has infinite timeout, however this problem may be due to too many concurrent connections. You can only have 50 Connections to the MySQL Databases on all Shared Hosting Plans. I apologize for any inconvenience this may cause. Please let us know if we can assist you in any other way." I sent this back: "I don't believe that my client has that much traffic that there would be 50 concurrent MySQL connections. Are you telling me that is why the site is going down? Can you see that data on your end?" To which they replied: "Thank you for contacting Online Support. The error you are seeing is usually related to the customer queries taking to long and timing out. You will need to check your coding when putting in queries to your database, You may also want to add an index to each table and optimize your database. " Which, mind you, is different from the immediately previous email. I replied thusly: "This isn't a problem with my Client's site. It's been running just fine for the last year with no problems. Just one week ago, it started going wrong. Other users on GoDaddy's servers running OSCommerce have reported the same thing. Can someone please give me a straight answer? You're telling a community of users five different things." And their brilliant response: "We have tested the conection to your data base and are not seeing any problems with the connection. Please note that over time a data base can grow larger when adding more users and threads to the data base can cause problems with the connection. We recommend that you check the coding you are using and optimize the data base. " And this is my clever response: "It's like I'm talking to a wall here. Can someone please stop giving me boilerplate responses? The site worked fine until eight days ago. There are multiple other OSCommerce users with GoDaddy hosted accounts experiencing the exact same problem that started occurring eight days ago. My client's database has about 30,000 records. I could reindex it by hand if I had to, that is not the problem. The problem server side, and not due to database issues or scripting. PLEASE let us know what is going on. My client has told me that he's going to switch hosting companies if it isn't resolved soon." Let's see what happens now... Link to comment Share on other sites More sharing options...
leakwayk Posted October 26, 2007 Share Posted October 26, 2007 I ran it again today .. and it is functional however I am still not receiving the orders on the admin side. We'll see how long it stays back up. However, when I look into my customer history I still get a SQL error. Is this related or is this an error on my behalf? 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1 select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '238' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10 [TEP STOP] Link to comment Share on other sites More sharing options...
kams912 Posted November 19, 2007 Share Posted November 19, 2007 This F****G problem is back for me again..... Link to comment Share on other sites More sharing options...
janetgot Posted November 19, 2007 Share Posted November 19, 2007 Has anybody found a decent response/resolution to this problem? I just started seeing this problem on one of my accounts that is still in development (so the database is very small and no customers are in the shop, just me). We aren't even set up with authorize.net yet and the issue occurs going to checkout_shipping.php. I called GoDaddy and they said that the problem is because we are on a shared server and another database on the server is using too many resources, so my site is affected. When I said this would not work for a production store, he basically said 'sorry, nothing we can do, it's the nature of shared resources'... not good customer support at all! He suggested recreating the database so it was in a different place, which I will try, however, if this could happen at any time (and we are heading into the holiday rush season) this could be a huge problem. Link to comment Share on other sites More sharing options...
trabi Posted November 19, 2007 Share Posted November 19, 2007 I also hosted my site in Godaddy and it is in development phase now. I start seeing this problem today as well, when updating currency. By the way, I have a Premium Hosting plan with them. Link to comment Share on other sites More sharing options...
kams912 Posted November 20, 2007 Share Posted November 20, 2007 the fact is godaddy can't handle all the SQL resources needed by shared and dedicated hosting, this is the second time I have had this problem. I just turn off the authorize.net module and use the basic cc module, then I process the cards manually. Until enough people pull their accounts off godaddy server they will not get this fixed. You need to call and threaten to pull your domains unless they fix this quick. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.