Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 - Table 'gourmetbiz.configuration' doesn't exist


shane.kelly55

Recommended Posts

Posted

Ok guys, i must be a total dope.

 

I have Apache, PHP and MYSQL installed ok on a Vista SP1 machine. Everything is local here, this is just a development machine.

 

I have the catalog folder in my htdocs folder. I can run the install without any problem.

 

However i am pretty sure i am not downloading/installing the oscommerce tables and other objects into my MYSQL schema. I am using MYSQLAdmin and it shows the database GourmetBix empty.

 

When i run through the install, my screens do not look like the screens in the documentation PDF. No where does it ask me to import anything although the documentation shows i should get that screen. I run through the install process and it tells me everything worked ok. i get to the 4th screen with the Catalog and Administrative Tools buttons but when i click either of them i get:

 

1146 - Table 'gourmetbiz.configuration' doesn't exist

 

I know the table isnt there i just dont know how to actually get the Gourmet Biz schema loaded.

 

Any ideas?

 

I love this community by the way.

Posted

Addendum:

 

Could it be the settings for WWW Address or Webserver Root Directory? I wasnt sure what to put here. I dont know if we only use the Catalog folder during install or if i have to go back to the originally zipped oscommerce2.x folder for some reason. Here is what i have:

 

WWW Address

http://localhost/catalog/

 

Webserver Root Directory

C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/catalog//

Posted

Try these settings

 

<?php

define('HTTP_SERVER', 'http://localhost');

define('HTTPS_SERVER', 'http://localhost');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'localhost');

define('HTTPS_COOKIE_DOMAIN', 'localhost');

define('HTTP_COOKIE_PATH', '/rc2a/');

define('HTTPS_COOKIE_PATH', '/rc2a/');

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

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

define('DIR_WS_IMAGES', 'images/product_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/');

// BEGIN newdesk

define('DIR_WS_RSS', DIR_WS_INCLUDES . 'modules/newsdesk/rss/');

// END newsdesk

//USAGE - call the url /rss.php?box=categories or /rss.php?box=whats_new or /rss.php?box=newsdesk_latest.php

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', 'C:/Program Files/xampp/htdocs/rc2a/');

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

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

 

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'xxxxxxxxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxxxxxxxxxxxx');

define('DB_DATABASE', 'xxxxxxxxxxxxxxxxxxxxx');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Admin

 

define('HTTP_SERVER', 'http://localhost');

define('HTTP_CATALOG_SERVER', 'http://localhost');

define('HTTPS_CATALOG_SERVER', 'http://localhost');

define('ENABLE_SSL_CATALOG', 'false');

define('DIR_FS_DOCUMENT_ROOT', 'C:/Program Files/xampp/htdocs/rc2a/');

define('DIR_WS_ADMIN', '/rc2a/admin/');

define('DIR_FS_ADMIN', 'C:/Program Files/xampp/htdocs/rc2a/admin/');

define('DIR_WS_CATALOG', '/rc2a/');

define('DIR_FS_CATALOG', 'C:/Program Files/xampp/htdocs/rc2a/');

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

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

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/product_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('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'xxxxxxxxxxxxxxxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxxxxxxxxxxxxxxxxx');

define('DB_DATABASE', 'xxxxxxxxxxxxxxxxxxx');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Then read this

 

A guide to the configure.php files, Or how to move your site without breaking anything.

 

http://www.oscommerce.com/forums/index.php?showtopic=193738

 

How to move a site then go live

 

http://www.oscommerce.com/forums/index.php?showtopic=287726

 

Enjoy

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...