Guest Posted June 15, 2004 Share Posted June 15, 2004 I have installed OSC on many servers with no problems at all but I have installed on Netfirms server and when I goto checkout I get this error.. 2013 - Lost connection to MySQL server during query select countries_name, countries_iso_code_2, countries_iso_code_3 from countries where countries_id = '223' order by countries_name [TEP STOP] Any ideas what to do to fix it... Thanks for any help you may give.. Mike Link to comment Share on other sites More sharing options...
Gman22 Posted October 16, 2005 Share Posted October 16, 2005 Sorry to revive a very old thread... but I have the same problem. I'm using GoDaddy, and using PHPMyAdmin, I can execute the select statement, and it works just fine. Thanks, Gman22 Link to comment Share on other sites More sharing options...
♥Vger Posted October 16, 2005 Share Posted October 16, 2005 Make sure that use _pconnect is set to 'false' in both configure.php files. Some servers will not allow Persistent Connections. Also make sure that enable_ssl is set to false unless you have an ssl certificate, either shared or full. Vger Link to comment Share on other sites More sharing options...
Gman22 Posted October 17, 2005 Share Posted October 17, 2005 PCONNECT was set to false, I tried setting it to true, but that didn't work either. I also played around with the SSL...I did purchase an SSL certificate from GoDaddy, but I don't know if its working or not. Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 17, 2005 Share Posted October 17, 2005 Netfirms uses a very old version of the database, unless they have updated recently, so that may be causing you some grief. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Gman22 Posted October 17, 2005 Share Posted October 17, 2005 I host with GoDaddy, and they use PHP Version 4.3.11, and MySQL Version 3.23.49 (I think)... Jack, I guess you might be right on this one, but here is what is confusing. If I execute the quer in PHPMyAdmin, "select countries_name, countries_iso_code_2, countries_iso_code_3 from countries where countries_id = '223' order by countries_name" that osCOmmerce said that it lost the connection during, it works. Gman22 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.