tiglancey Posted October 12, 2007 Share Posted October 12, 2007 I'm at the "Database Server" New Installation page. Here's the error: There was a problem connecting to the database server. The following error had occured: Lost connection to MySQL server during query Please verify the connection parameters and try again. What in the world is going on?!!! I have Lunarpages as my host. My web is www.onehappytree.com HELP! Thanita Link to comment Share on other sites More sharing options...
Gauravs Posted October 12, 2007 Share Posted October 12, 2007 There was a problem connecting to the database server. The following error had occured: Lost connection to MySQL server during query I am afraid this error is due to connection between webserver and database server (and nothing wrong in settings with OSC) Please check with your hosting company and verify they have enough "timeout period" to allow query to and from database. during installation, when data is being dumped to database (dummy values) .. it is going to take a while, and thus timeout should not occur. Cheers Best Regards,Gaurav Link to comment Share on other sites More sharing options...
tiglancey Posted October 16, 2007 Author Share Posted October 16, 2007 I am afraid this error is due to connection between webserver and database server (and nothing wrong in settings with OSC) Please check with your hosting company and verify they have enough "timeout period" to allow query to and from database. during installation, when data is being dumped to database (dummy values) .. it is going to take a while, and thus timeout should not occur. Cheers OK so I contacted my host and they corrected it. So they thought. I still saw the same errors. So I told them. They extended the time and still get the errors. Not moving forward here. This is the exact reason why I didn't want to use osCommerce!!! !@#!@$#$#@$#@@# :( Help Link to comment Share on other sites More sharing options...
Iggy Posted October 16, 2007 Share Posted October 16, 2007 OK so I contacted my host and they corrected it. So they thought. I still saw the same errors. So I told them. They extended the time and still get the errors. Not moving forward here. This is the exact reason why I didn't want to use osCommerce!!! !@#!@$#$#@$#@@#:( Help Have you considered using a host that can support you? From my end I haven't had this kind of issue and I suspect it doesn't have much to do with osC. The install is the easiest part. The database is small initially. If you're having this kind of issue now you can expect to see more down the road. Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
tiglancey Posted October 16, 2007 Author Share Posted October 16, 2007 Have you considered using a host that can support you? From my end I haven't had this kind of issue and I suspect it doesn't have much to do with osC. The install is the easiest part. The database is small initially. If you're having this kind of issue now you can expect to see more down the road. Iggy They're responding to but since I'm not to literate in code or anything like that, I don't even know what's the right answer! Thanks for the input. I'll keep that in mind when I have to register again. Thanita Link to comment Share on other sites More sharing options...
moziambic Posted October 16, 2007 Share Posted October 16, 2007 Lunarpages is perfectly alright. I had my own oscommerce store hosted there without any errors. You can always try to install using fantastico (cpanel) to avoid these kinds of errors. Contributions I'm using: Updated Spiders.txt | Country State Selector To add more life to your site. Follow this link: http://addons.oscommerce.com/ Link to comment Share on other sites More sharing options...
Iggy Posted October 16, 2007 Share Posted October 16, 2007 There was a problem connecting to the database server. The following error had occured: Lost connection to MySQL server during query Please verify the connection parameters and try again. If they're having issues connecting to the db it's kind of, just a little, sorta unacceptable. Every host has problems occasionally but this seems to have been going on for days given the post dates. And no, don't install via Fantastico unless it's the latest RC version. Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
tiglancey Posted October 17, 2007 Author Share Posted October 17, 2007 If they're having issues connecting to the db it's kind of, just a little, sorta unacceptable. Every host has problems occasionally but this seems to have been going on for days given the post dates. And no, don't install via Fantastico unless it's the latest RC version. Iggy Fantastico installation did not work. They didn't have the latest version. I do like the support as far as the speediness of replies is concerned. But hearing that the database error shouldn't be this much of a problem is setting up red flags for me. I guess I just don't know any better. Which host do you recomened?(not that I can switch now...it would be too expensive) Thanita Link to comment Share on other sites More sharing options...
Iggy Posted October 17, 2007 Share Posted October 17, 2007 Fantastico installation did not work. They didn't have the latest version. I do like the support as far as the speediness of replies is concerned. But hearing that the database error shouldn't be this much of a problem is setting up red flags for me. I guess I just don't know any better. Which host do you recomened?(not that I can switch now...it would be too expensive)Thanita I believe recommendations are verboten on the board but Google or WebHostingTalk should be great resources for that info. If you can't move you might ask them what the hassle is. It sounds like your db may be on a machine that's a tad, say, overloaded and they may be able to switch you to a less busy box. Hope that helps and good luck! Iggy Everything's funny but nothing's a joke... Link to comment Share on other sites More sharing options...
tiglancey Posted October 17, 2007 Author Share Posted October 17, 2007 I believe recommendations are verboten on the board but Google or WebHostingTalk should be great resources for that info. If you can't move you might ask them what the hassle is. It sounds like your db may be on a machine that's a tad, say, overloaded and they may be able to switch you to a less busy box. Hope that helps and good luck! Iggy I got it! I'm not sure what happened but it worked...now I have a new problem that I'll post! lol! Thanks Iggy, Thanita 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.