Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database connection errors - FAQ


241

Recommended Posts

Warning: mysql_connect(): Host '******' is not allowed to connect to this MySQL server in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong server DB_SERVER information in the configure.php files

 

Warning: mysql_connect(): Access denied for user: '****@*****' (Using password: *****) in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong username DB_SERVER_USERNAME or password DB_SERVER_PASSWORD information in the configure.php files

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

This indicates that either no database has been created or the wrong database name DB_DATABASE exists in the configure.php files

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

  • 7 months later...

Hi,

 

Good FAQ on db connection errors. Would be good to expand this to "database errors". We had one I hadn't seen before:

 

"1030 - Got error 127 from table handler"

 

This indicates the table mentioned is corrupt, try running a repair and optimize on the table.

 

Peter

Link to comment
Share on other sites

  • 2 months later...

What about this one?

Warning: mysql_connect(): Too many connections in /www/www/wwwwww/htdocs/wwwww/www/wwwwww/functions/database.php on line 19
Unable to connect to database server!

Is 1 connection too many?

 

:angry: wazu

Link to comment
Share on other sites

  • 4 months later...
  • 5 weeks later...
  • 1 month later...

I have tired to install the db for oscommerece and each time I try to install it I get an

error saying

 

The connection was lost! I must note that I'm new to PHP, so I need to know where exactly I have to configure the files so that the database will work!

 

Please help! :blink:

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...