Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

no database selected


pauldiddy

Recommended Posts

i have set up my configure.php file to reflect my server settings, and am still getting this message, don't know what it means. can anyone help? thanks quite.

 

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Link to comment
Share on other sites

yes, i do have a database. and i've been wading around the posts for the last couple of hours to figure it out, but still to no avail. i even tried adding the direct 188.28.579 host server (although i made that one up) as someone had suggested, and that at least returned a response that was not the 1046 response, but still didn't work. i checked my database, and lots of new tables seemed to have been added, so there is access to the database. i tried changing the permissions a bunch, no avail. i realized that i was looking in one of the wrong config files, and found the other to change, no avail. i checked out the 'local' folder to see if there was a config file there, none.... thanks for responding.

paul

Link to comment
Share on other sites

i realized that sometime earlier in the day when i was trying to change permissions, i must have edited this file....so i changed the info in that from my server info to 'username', 'password' etc. but it still didn't work.

 

and this is from entering the direct database address from before to get this. if i use dbxxx.xxx.com then i get the 1046.

 

i had also changed the application_top file to reflect another post in the forum, but i don't think that that resulted in editing server info.

 

oh, and after i changed it back to 'username' and 'password'(in the database.php file) it still returned the code below. i don't know if that should be my server name or not.....

 

Warning: mysql_connect(): Can't connect to MySQL server on 'xxx.xx.x.xx' (61) in /usr/www/users/xxxxxxx/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites

Check out a few things. Make sure that in your configure.php files that use_pconnect is not set to true. Some servers will now allow persistent connections to run.

 

Check in the two includes/local/ folders to see if there are any alternative configure.php files in those folders. If you find any - rename them.

 

Vger

Link to comment
Share on other sites

thanks. but i fixed the problem through flushing the tables, deleting the file and reinstalling, which took like 15 minutes. i think it may have been having a table already in the database that i installed oscommerce into....

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...