Problems installing shop on new server

[holotech]

After searching here and in Google for a couple of days and finding nothing worthwhile I have decided to ask for help here. I intend to move an existing Shop (osCommerce 2.2-MS2) to a new server. I have copied all files and database to the new server, obviously with changed parameters in config.php using the attributes of the new server. I am now facing the following Problems:

 

1.) Categorie and Product Links are not working. All other links do work. Under the all product link I also can see all products. I have checked the database and everything is there. I have checked the generated source file and all links appear to be correct. However clicking on a categorie the URL in the Browser changes to the correct path but it only shows the index page. Clicking on a product link or entering the link into the browser gives me an error saying the product does not exist any more.

 

2.) Trying to register as a new customer does not work. Entering the required data and clicking the link at the bottom of the page, does just nothing. If I want to register as an existing customer, the same happens. It returns me to the login page without showing any error.

 

3.) I can not login to admin.

 

My guess is, that all these are related. Having checked the config files over and over again, checked the database, checked the htaccess file for rewrite mods and compared files like application_top, I got nowhere.

Please if anyone has experienced this kind of behaviour before or can point me in the right direction, I would be grateful. All comments are welcome.

[♥mdtaylorlrim]

obviously with changed parameters in config.php using the attributes of the new server.

Just exactly what changes have you made to the configure.php files?

 

And, maybe you should consider taking this opportunity to update to the latest version?

[holotech]

Just exactly what changes have you made to the configure.php files?

 

And, maybe you should consider taking this opportunity to update to the latest version?

 

Thanks for replying - sorry for only answering now - was off-line to adverse weather conditions.

 

Yes we are considering updating - however we would like to transfer the shop as is before to get away from an unreliable host.

 

I am copying my configure.php of the catalog side:

 

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// Define the webserver and path parameters
 define('HTTP_SERVER', 'http://200.106.147.151'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://200.106.147.151'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', false); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', '200.106.147.151');
 define('HTTPS_COOKIE_DOMAIN', '200.106.147.151');
 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_FREE_DOWNLOAD', DIR_WS_HTTP_CATALOG . 'free_download/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/var/www/vhosts/marketlettercorp.com/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', 'marketle_webuser');
 define('DB_SERVER_PASSWORD', '********');
 define('DB_DATABASE', 'admin_marketletter');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

[♥mdtaylorlrim]

Look in your database and verify that your categories and products match your links. Specifically check your products-to-categories table for valid references.

[holotech]

Look in your database and verify that your categories and products match your links. Specifically check your products-to-categories table for valid references.

 

I had of course checked the database for problems before and couldn't find any but for problems with special characters which will be sorted out. I just checked again, compared the products-, categories- and products-to-categories- tables specifically. Everything there is correct - the error does not come from the database.

Would there be a problem with different software versions and or configurations on the new server? But really I do not think so.

 

Old server: Apache 2.0.63 - PHP 5.2.9 - MySQL 5.1.48-log

 

New server: Apache 2.2.3 - PHP 5.1.6 - MySQL 5.0.77

 

I really have no idea where else to look.

 

Thanks for trying to help. Got any other idea?

[♥mdtaylorlrim]

Yeah, check the error logs for mysql scripts that fail.

 

Write some short php scripts that do some database retrievals.

[holotech]

ok thanks - I just used a script I have in admin - didn't open the database.

 

It's late need to grab some sleep - I carry on tomorrow with the error logs etc. - will post then what I do find.

 

Thanks again for the moment.

[holotech]

After eliminating an error I was able to retrieve data from the database, which did not solve the original problem.

 

Looking into the error-logs there were problems with safe-mode and open_basedir. After sorting these out errors like "supplied argument is not a valid MySQL resource in database.php" appeared. After checking everything again and not finding a solution we have decided to update the osc, since this was on the cards for afterwards anyway.

 

Thanks again for your suggestions.