Transfering to new domain, Common Problem

[deathgod]

Hey all,

I am getting the following error message:

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Go to http://www.zashop.co.za/ to view it yourself.

I am no expert when it comes to database stuff, but a calculated guess would be - the error means that it has come across 'select' statements to run on a database but has no database to run it on.

 

The problem is that I have got a database, with user etc..... but still get this problem. I have updated the configure.php to the new domains specs so i dont think it is there, but i am sure i have missed something obvious somewhere else.

 

Anyone have ideas?

 

Nick

 

Edit: I'll be checking in later when i have more time. ciao.

[deathgod]

UPDATE:

1/ I have quadruple chacked my configure.php files and they are correct to me.

2/ So i deleted my old database and created a new one from scratch and that hasn't worked either.

3/ I have searched the forums and the only advice i can find is, edit your configure.php files to reflect your new specs, which i have done. But i may have got it wrong so here it is the catalog one

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 [url=http://www.oscommerce.com]http://www.oscommerce.com[/url]

 Copyright ? 2003 osCommerce

 Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://www.zashop.co.za'); // eg, [url=http://localhost]http://localhost[/url] - should not be empty for productive servers
 define('HTTPS_SERVER', ''); // eg, [url=https://localhost]https://localhost[/url] - should not be empty for productive servers
 define('ENABLE_SSL', 'false'); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'www.zashop.co.za');
 define('HTTPS_COOKIE_DOMAIN', '');
 define('HTTP_COOKIE_PATH', '');
 define('HTTPS_COOKIE_PATH', '');
 define('DIR_WS_HTTP_CATALOG', '');
 define('DIR_WS_HTTPS_CATALOG', '');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/home/httpd/vhosts/zashop.co.za/httpdocs/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'are_you_trying_to_read_my_details?_THATS_CHEEKY');
 define('DB_SERVER_PASSWORD', 'my_password_is_********');
 define('DB_DATABASE', 'zashopdb');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

[deathgod]

Some progress of a sort:

i ran the following code on my webserver:

<?php
if (mysql_connect('localhost', 'user_****', 'pw_****'))
echo 'db connected';
else echo 'not connected';
?>

and the results were 'db connected' which means that my database is working. If you want to check for yourself go to http://www.zashop.co.za/db_checker.php I have checked by entering wrong info and i get an error so the code is correct

 

The details i have used here is the exact details i used in my configure.php files so we know that those are correct......what else could be causing the 1056 error? anyone, please help.

[♥Vger]

Try this. Create a new text file on your desktop and rename it to cwd.php (ignore the warning about changing the file type). Put this code into it:

<?php
$p = getcwd();
echo $p;
?>

 

Upload that file to the folder or level your website is located at and then go to it in your browser e.g. http://www.yourdomain.com/cwd.php and it will print out on the page what the full pathway is to your website. Don't leave it on your website - delete it after use.

 

Vger

[deathgod]

Thx for replying, my hero:).....the output is /home/httpd/vhosts/zashop.co.za/httpdocs which is the exactly what is written in the configure.php file :(

 

Just a question that might help:

Other than the 2 configure.php files, what files get modified upon the defualt installation?

 

Nick

[deathgod]

bump........anyone got an answer to my last question:

Other than the 2 configure.php files, what files get modified upon the defualt installation?

i think i'll try re-upload these files, and if that doesn't work, then i'll re-upload everything, which i hope i wont have to do :(

[♥Monika in Germany]

Nick, have you checked for secondary configure.php files in the includes/local folders?

[deathgod]

Monika, i love you @}->--

i had no local/configure.php file on my old site, but did on my new site so i deleted it and its working :D

The local/configure.php file overrode the settings i put in my other configure.php files, i think. Anyway, its working now so a very big thank you, dont think i would have ever figured that one out by myself.

Nick

[♥Monika in Germany]

wonderful ... I dealt with something like that in my very first osC installation, so I learned it the hard way ;-)