Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ACK! Switched servers and now I get weird error (configs fine)


Guest

Recommended Posts

Posted

I get this after I login into my admin page:

 

Warning: mysql_connect(): Lost connection to MySQL server during query in /hsphere/local/home/mechbun/mechanicalbunny.com/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

I have searched the fourm and tips section and found various similar MySQL problems, but nothing that says "lost connection" I triple checked all my config settings and they are definitly setup for the new host. (password, server, username, and db name) Here is that info just i case you need to look at it:

 

 define('DB_SERVER', '127.0.0.1'); 
 define('DB_SERVER_USERNAME', 'mechbun_niki');
 define('DB_SERVER_PASSWORD', 'xxxxxxxx');
 define('DB_DATABASE', 'mechbun_osc');
 define('USE_PCONNECT', 'false'); 
 define('STORE_SESSIONS', ''); '

 

Any ideas??

Posted

You know what.. it is happening all over my site too, not just the admin section. Anywhere that I have code plled from the database it says:

Warning: mysql_connect(): Lost connection to MySQL server during query in /hsphere/local/home/mechbun/mechanicalbunny.com/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

But both my config files are setup properly.. here is the catalog config:

define('DB_SERVER', '127.0.0.1'); 
 define('DB_SERVER_USERNAME', 'mechbun_niki');
 define('DB_SERVER_PASSWORD', 'xxxxxx');
 define('DB_DATABASE', 'mechbun_osc');
 define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

 

I remember having this problem before and i HOPE it is a host issue, something in my memory says that it is.

(I have already contacted my host)

Posted
yuppers.. it was my host.. all better now =)

That error had "host" written all over it.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Archived

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

×
×
  • Create New...