Oscommerce Install Not Working

[rjckicks1]

Hi,

 

I am trying to install oscommerce.

 

First I had to replace -

 

$script_filename = getenv('PATH_TRANSLATED');

 

with

 

$script_filename = $_SERVER["ORIG_PATH_TRANSLATED"];

 

to get the database to install correctly, so maybe this has to do with my install not working. When I click next for the db install it takes a long time and then it says it installed successfully.

 

So after install it says it completed successfully and it says Catalog and Admin. If I click Catalog it takes me straight back to the installer page, and if I click Admin it says it can not connect to the database.

 

So maybe the database isn't being written correctly? If this is the case, before editing the install3.php file with the above live, I get the following error -

 

The following error has occurred:

SQL file does not exist: /install/oscommerce.sql

 

I would appreciate help..

 

Thanks

[spax]

If you have access to phpmyadmin or similar, you can populate the database manually.

 

Or you can try giving the full path to oscommerce.sql. In catalog/install/templates/pages/install_3.php, find this code:

 

$sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

 

and change it so it has a full path to oscommerce.sql.

 

$sql_file = '/full/server/path/to/install/oscommerce.sql';

[rjckicks1]

Hi spax,

 

thanks for the reply,

 

I am using a mysql client to see the database, and it does seem like the import worked correctly. There are tables in the database.

 

But when the installation finishes if I click "Catalog" it just goes right back to the install page. What could be making it do this? Did something not write correctly? Even though the install said everything was successful?

 

Thanks

[spax]

Try re-naming the install directory and see what that does.

[rjckicks1]

If I do that then it will say unable to connect to database.

 

If I look in the includes/config.php file it is blank for the database info like below -

 

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

 

But if I fill this in, it does connect because the page displays, but all the graphics are missing on the page and a couple errors come up at the top. You can see this here - http://www.nutralove.us/catalog/index.php

 

The 2 errors seem they shouldn't be making the graphics not appear anyway.

 

I just tried adding in the database info into the config.php file for admin, and the admin section functions but not really.

 

You can see at - http://www.nutralove.us/catalog/admin/index.php

 

You can only see the frontpage but if you click a link it dosen't work.

[rjckicks1]

update-

 

i entered the http catalog directory and now it's showing images, going to test a bit and will get back to you.

[spax]

The configure files are incorrect. They aren't referencing the catalog directory. The includes/configure.php will look something like this, assuming no SSL cert:

 

<?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
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://www.nutralove.us'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', false); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'www.nutralove.us');
 define('HTTPS_COOKIE_DOMAIN', '');
 define('HTTP_COOKIE_PATH', '/catalog/');
 define('HTTPS_COOKIE_PATH', '');
 define('DIR_WS_HTTP_CATALOG', '/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', 'full/path/to/public_html/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

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

 

EDIT: Cross post - seems you found that out.