Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ArtsBeauty.com - 1046 - No Database Selected


Guest

Recommended Posts

Posted

Dear Members,

I am shifting from Interchange to this shopping cart on recommendation of my friend Mr. Michael G.

 

- The installtion would have been easier but not happening to me.

- firstly auto configuration didnot work.

- I manually run SQL script for importing structure and data.

- Editing configure.php but unable to eliminate the above message.

i.e. <

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

>

Please help me

the config file is as below :

 

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'usr');

define('DB_SERVER_PASSWORD', 'pwd');

define('DB_DATABASE', 'database');

define('USE_PCONNECT', 'false'); // use persistent connections?

 

with thanks and regards

Aditya

www.ParkInternet.com

[email protected]

New Delhi , India

Posted

I ran into this porblem also and I fixed it by setting configure.php to 777 and the admin directory to 777.. Once I ran thru the install process I changed the admin directory back and set configure.php to read only and everything worked fine.

Posted

Dear Kevin,

 

I changed permissions for configure.php to 777 and the admin directory to 777 but of no use the same error msg.

< 1046 - No Database Selected

----

[TEP STOP]

>

 

I have specified the databse and still it says the same.

more light on this!

 

regards

Aditya

Posted

Hello Aditya,

 

I had this problem a couple of days ago and found it to be caused by mis-spelling the database name in the configure.php

 

you might try checking that.

 

 

James

Posted

define('DB_DATABASE', 'database');

 

The word "database" is a reserved keyword in mysql. You cannot use it as the name of your database.

Archived

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

×
×
  • Create New...