osCommerce Community Support Forums > Oscommerce Install Not Working

Help - Search - Members - Calendar

Full Version: Oscommerce Install Not Working

osCommerce Community Support Forums > osCommerce Online Merchant v2.x > Installation and Configuration

rjckicks1

Jun 7 2007, 04:41 PM

Hi,

I am trying to install oscommerce.

First I had to replace -

CODE

$script_filename = getenv('PATH_TRANSLATED');

with

CODE

$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 -

CODE

The following error has occurred:

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

I would appreciate help..

Thanks

spax

Jun 7 2007, 06:06 PM

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:

CODE

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

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

CODE

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

rjckicks1

Jun 7 2007, 06:27 PM

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

Jun 7 2007, 06:31 PM

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

rjckicks1

Jun 7 2007, 06:43 PM

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 -

CODE

// 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

Jun 7 2007, 06:50 PM

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

Jun 7 2007, 07:05 PM

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:

CODE

<?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.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.

OSCOMMERCE SUPPORT CALL 702-453-3332