Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem with Database


trisha33

Recommended Posts

Hi,

I recentlymoved to a new host and uploaded a copy of my database. When i try to go to my site, I get the following error:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

What do i need to do to fix this?

 

Thanks,

 

Trisha

Link to comment
Share on other sites

You need to make the changes in your configure.php files;

 

catalog/includes/configure.php and;

catalog/admin/includes/configure.php

 

The name of the DB is the part that has most likely changed from something like "oldhost_osc" to "newhost_osc".

Link to comment
Share on other sites

You need to make the changes in your configure.php files;

 

catalog/includes/configure.php and;

catalog/admin/includes/configure.php

 

The name of the DB is the part that has most likely changed from something like "oldhost_osc" to "newhost_osc".

 

 

Thanks, just did it, since i moved to a new host, do you think it takes a bit before the changes happen?

Link to comment
Share on other sites

Thanks, just did it, since i moved to a new host, do you think it takes a bit before the changes happen?

 

 

Now I am getting this error:

Warning: mysql_connect(): Access denied for user: 'trish33@localhost' (Using password: YES) in /home/mylixcom/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

I have tried every password I know..Need HELP now please! Thanks..

Link to comment
Share on other sites

Make sure in your news hosts Control Panel that in PHPMyadmin that you set up a new user and gave that user full privliges to the DB.

 

 

Okay where in phpadmin do you set up new user,etc.. I did that in mysql and gave user full privileges.

Link to comment
Share on other sites

Okay where in phpadmin do you set up new user,etc.. I did that in mysql and gave user full privileges.

 

 

Well i finally figured it out..Had to use my hosting account login information. now I got this message..I am sure i can find it in the forum..

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...