Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL socket error?


Xpajun

Recommended Posts

I'm getting the following error (on and off I think but in batches - multiple attempts at a time) in my error log - anyone come across it and has a cure?

 


PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /******/*******/public_html/includes/functions/database.php on line 19

 

Line 19 is 2nd $$link:

   if (USE_PCONNECT == 'true') {
     $$link = mysql_pconnect($server, $username, $password);
   } else {
     $$link = mysql_connect($server, $username, $password);
   }

My store is currently running Phoenix 1.0.3.0

I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 )

I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary

Link to comment
Share on other sites

I'm getting the following error (on and off I think but in batches - multiple attempts at a time) in my error log - anyone come across it and has a cure?

 


PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /******/*******/public_html/includes/functions/database.php on line 19

 

Line 19 is 2nd $$link:

   if (USE_PCONNECT == 'true') {
     $$link = mysql_pconnect($server, $username, $password);
   } else {
     $$link = mysql_connect($server, $username, $password);
   }

 

Is your includes/configure.php et admin/includes/configure.php correct ?

Check this line: define('DB_SERVER', 'localhost');

Link to comment
Share on other sites

Is your includes/configure.php et admin/includes/configure.php correct ?

Check this line: define('DB_SERVER', 'localhost');

 

 

Yes it's a live active site - been live without the problem for 5 or 6 years

 

 

Thanks for your suggestion though

My store is currently running Phoenix 1.0.3.0

I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 )

I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary

Link to comment
Share on other sites

Usually means the SQL server is intermittent (ie, a hosting problem).

I've not come across the error in any other context.

 

 

Thanks Gary - actually the hosts have just done a SQL update (without telling me of course) wonder if that might cure it in that case - the errors have been coming in for the last 2 months at least (so not the update that has caused it)

My store is currently running Phoenix 1.0.3.0

I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 )

I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...