No Products

[Lavers69]

I can not access my products from my front page. I keep getting a 'page can not be displayed message'. I had problems when I installed a Shared SSL. I had to reinstall the catalog/includes/ directory. Any ideas where I should start looking for a solution. I also keep getting directed to https rather than http when I first log on to my site. It is only when I edit the browser that I can see my front page in full.

 

Appreciate any suggestions.

 

Iain

[Guest]

The problem may be in your catalog/includes/configure.php file. Post a copy here (but censor sensitive passwords etc)

 

Tom

[Lavers69]

The problem may be in your catalog/includes/configure.php file. Post a copy here (but censor sensitive passwords etc)

 

Tom

Thanks for your help. Here is a copy of my catalog/includes/configure.php file:

 

<?php

/*

$Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

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.gastronomique.biz'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.gastronomique.biz/www/shop');

define('HTTPS_CATALOG_SERVER', 'https://www.gastronomique.biz');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/webroot/g/a/gastr001/www/shop/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/shop/iain1969/'); // absolute path required

define('DIR_FS_ADMIN', '/webroot/g/a/gastr001/www/shop/iain1969/'); // absolute pate required

define('DIR_WS_CATALOG', '/shop/'); // absolute path required

define('DIR_FS_CATALOG', '/webroot/g/a/gastr001/www/shop/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'mysql.omnis.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', '******');

define('DB_SERVER_PASSWORD', '******');

define('DB_DATABASE', '********');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

I have also included a copy of my catalog/admin/includes/configure.php file. I am not sure if both these files should read the same:

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

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.gastronomique.biz'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.gastronomique.biz/www/shop');

define('HTTPS_CATALOG_SERVER', 'https://www.gastronomique.biz');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/webroot/g/a/gastr001/www/shop/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/shop/iain1969/'); // absolute path required

define('DIR_FS_ADMIN', '/webroot/g/a/gastr001/www/shop/iain1969/'); // absolute pate required

define('DIR_WS_CATALOG', '/shop/'); // absolute path required

define('DIR_FS_CATALOG', '/webroot/g/a/gastr001/www/shop/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'mysql.omnis.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', '********');

define('DB_SERVER_PASSWORD', '******');

define('DB_DATABASE', '********');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

Iain

[Guest]

The catalog side configure.php you posted looks like a copy of the admin one - if it is the acutal catalog one I would back it up then replace it with the following:

<?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.gastronomique.biz'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://www.gastronomique.biz'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', true); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'www.gastronomique.biz');
 define('HTTPS_COOKIE_DOMAIN', 'www.gastronomique.biz');
 define('HTTP_COOKIE_PATH', '/');
 define('HTTPS_COOKIE_PATH', '/');
 define('DIR_WS_HTTP_CATALOG', '/shop/');
 define('DIR_WS_HTTPS_CATALOG', '/shop/');
 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', '/webroot/g/a/gastr001/www/shop/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// 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', '********');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

 

Just make sure that the settings are correct for your server.

 

Tom

[Guest]

Hi Tom

 

 

 

Thanks for your help on this. I changed the includes/configure.php file as you suggested. I have now got this warning message coming up:

 

 

 

Warning: mysql_connect(): Unknown MySQL server host '***********' (1) in /webroot/g/a/gastr001/www/shop/includes/functions/database.php on line 19

 

Unable to connect to database server!

 

 

I have pasted the code of the database.php file below. Any ideas how to fix this? I can't see anything wrong in this file.

 

 

 

I have two other issues. 1.) my shop sits in a directory called www on the root of my hosting company. The files are in a folder called shop. Whenever I want to access my website I have to go to www.gastronomique.biz/shop. I really want to be able to go to just www.gastronomique.biz and I am unsure how best to do this (their are conflicting views posted on the forum).

 

2.) I want to install ssl shared certificate provided by my host company (omnis.com). I tried to do this before and that led to all my problems. I still have an ssl directory on my root but I transferred all of the files out of it because I couldn't access my website at all (a warning came up saying that I didn't have permission to access this page). Now all of my files reside in the unsecure /shop/ directory. I am nervous about moving the files again. Any suggestions?

 

 

 

I really will appreciate any help you can provide

 

 

 

Regards

 

 

 

Iain

 

Hi,

I'm happy to help but I prefer to do so via the forum so others can benefit if they have the same problem and so others can offer solutions also - hence me quoting your email above.

 

For the first error the problem is not in database.php - you need to edit the following lines in your configure.php files:

  define('DB_SERVER', '***********'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', '*******');
 define('DB_SERVER_PASSWORD', '********');
 define('DB_DATABASE', '********');

Remove the *** and insert the information provided by your web hosting company for the databse server (note all 4 need completing)

 

 

Regarding your other questions. If you wish to access your site via www.gastronomique.biz/ rather than www.gastronomique.biz/shop you first need to move all your files down a directory. I.e. keeping the same structure but having them starting from the /www directory on your host rather than /www/shop. You then need to edit the configure.php files for the catalogue & admin sides to reflect this - anywhere you see /shop/ replace with /.

 

For the shared SSL it sounds like you are describing the situation where your host requires you to places the files you wish to be secured in a separate directory on the server. I personally have not dealt with this situation - the hosts I have used either use dedicated SSL or shared SSL that can be used without duplicating or moving files. I suggest reading this thread: http://www.oscommerce.com/forums/index.php?showtopic=151162 but others here maybe able to help - I believe it is possible.

 

Tom

[Lavers69]

Thanks for this Tom

 

I have now amended the includes/configure file. I had not changed the server address. However I am now getting this parse error:

 

Parse error: parse error, unexpected T_STRING in /webroot/g/a/gastr001/www/shop/includes/configure.php on line 38.

 

Any ideas? I am really losing confidence on this. I will follow your advice on moving the files to the root directory in the meantime. I really apopreciate all the help you're providing and i acknowledge your comments about posting correspondence on the forum.

 

Iain

 

includes/configure:

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

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.gastronomique.biz'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.gastronomique.biz'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.gastronomique.biz');

define('HTTPS_COOKIE_DOMAIN', 'www.gastronomique.biz');

define('HTTP_COOKIE_PATH', '/');

define('HTTPS_COOKIE_PATH', '/');

define('DIR_WS_HTTP_CATALOG', '/shop/');

define('DIR_WS_HTTPS_CATALOG', '/shop/');

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', '/webroot/g/a/gastr001/www/shop/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

define('DB_SERVER', ''mysql.omnis.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', '*****');

define('DB_SERVER_PASSWORD', '****');

define('DB_DATABASE', '*****');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[Guest]

define('DB_SERVER', ''mysql.omnis.com'); // eg, localhost - should not be empty for productive servers

 

there are too many ' in the line above remove one of the quote before mysql.omnis.com

 

Tom

[Lavers69]

Tom

 

You are a true star. It is now working like a dream.

 

Best regards

 

Iain