Migration Problem

[Guest]

I am migrating Oscommerce to a new server and I copied all the files and database to the new server. I changed the config files to point to the new server and now I am getting this error"

Warning: mysql_query(): No database selected in /home/osc/catalog/includes/functions/database.php on line 45
1046 - No database selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

 

I tried to set the $database variable to the osc database but nothing happened, still the same error!

 

Any ideas would be highly appreciated!

Thanks

[ozcsys]

I am migrating Oscommerce to a new server and I copied all the files and database to the new server. I changed the config files to point to the new server and now I am getting this error"

Warning: mysql_query(): No database selected in /home/osc/catalog/includes/functions/database.php on line 45
1046 - No database selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

 

I tried to set the $database variable to the osc database but nothing happened, still the same error!

 

Any ideas would be highly appreciated!

Thanks

<{POST_SNAPBACK}>

 

 

If you have changed the database info in your configure.php files to match your new database info check a couple of things.

 

1. A lot of servers use a username_databasename setup. Look at your database from your hosting control panel and see how the database and user are listed. If they are listed this way then you have to enter them in that way in your configure.php files

 

2. Make sure you have assigned your user to your database. It is a three step process, create database, create user, assign user to database. if you leave out step three you will get that error also.

[Guest]

I can connect to the Db server ok. Would it be caused by a missing file??? I am uploading my files again just to make sure its not a missing file. Any other ideas on what I can check to make this work?

[ozcsys]

I can connect to the Db server ok. Would it be caused by a missing file??? I am uploading my files again just to make sure its not a missing file. Any other ideas on what I can check to make this work?

<{POST_SNAPBACK}>

 

If you are getting the 1046 error then osC is not connecting to the database. This is caused by the database info in your configure.php not being correct or as I mentioned in my above post because the user has not been assigned to the database.

[Guest]

I had misspelled the database name in the configure.php. It working now

 

If you are getting the 1046 error then osC is not connecting to the database.  This is caused by the database info in your configure.php not being correct or as I mentioned in my above post because the user has not been assigned to the database.

<{POST_SNAPBACK}>