Error :(

[Tobiel]

Hi, I just installed OsCommerce and everything works fine (admin, I can add/remove stuff and do everything else) but when I go to catalog (to see the "real shop" as customers it will see) I get this error:

 

1146 - Table 'djinny_djinnywebwinkel.TABLE_CONFIGURATION' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from TABLE_CONFIGURATION

 

[TEP STOP]

 

Can anyone please help me?

[OceanRanch]

Check your catalog/configure.php file. Compare some of the values (specifically your INCLUDES) against what you have in your admin/configure.php file.

 

Something is not setup properly.

 

HTH

Tom

[Tobiel]

Well the configs are all setup properly... I have no idea what is causing this. I've tried reinstalling OsCommerce a few times and I keep getting the same error. Everything works, apart from the shop itself.

 

Any other ideas maybe? This is not funny :(

[OceanRanch]

Can you post the catalog/includes/configure.php and the admin/includes/configure.php files without the user/password info?

[Tobiel]

catalog config:

 

<?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.rulethemall.com'); // 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.rulethemall.com');

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', '/home/djinny/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', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'removed');

define('DB_SERVER_PASSWORD', 'removed');

define('DB_DATABASE', 'djinny_winkel');

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

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

?>

 

 

and the admin config:

 

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

define('HTTP_CATALOG_SERVER', 'http://www.rulethemall.com');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/djinny/public_html/catalog/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/djinny/public_html/catalog/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/home/djinny/public_html/catalog/'); // 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', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'removed');

define('DB_SERVER_PASSWORD', 'removed');

define('DB_DATABASE', 'djinny_winkel');

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

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

?>

 

Hope this helps, thanks already.

[Tobiel]

Oh btw, ignore the database name. That changed name since I posted the error as I reinstalled with new databases to test if a reinstall would help.

[ptrau]

The error message says you are missing the table in your database. It has nothing to do with your configure.php. files. Did you install the sql file in your database?

[Tobiel]

The error message says you are missing the table in your database. It has nothing to do with your configure.php. files. Did you install the sql file in your database?

What SQL file in the database? I am sure I did not do that. What file do I install tehre and where can I find it?

 

edit: or is that the file that gets automatically imported when you install Oscommerce for the first time?

[ptrau]

RTFI.....

 

Open the "install" file that came with the program. It will tell you what to do.

[Tobiel]

Well it says nothing about installing a certain file into the database...

[241]

I think you will fins that the file in question is the oscommerce.sql file which is to be created in the database when you run the install

[OceanRanch]

The configuration table is in the database, it's the TABLE_CONFIGURATION define that is not being "defined". Tobiel says the admin side is fine. That's why I think its a configure issue.

 

I can't see what the problem is so maybe some else can see it.

 

Maybe make sure the includes/database_tables.php file is ok?

[241]

the configs are fine as far as the viewable information and if the TABLE_CONFIGURATION did not exist then you would have problems in the admin as this table is used for all your store information

 

The only part of the configs not viewable is this part

 

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

which we are assuming is the exact same in both files

[ptrau]

Do you host the site yourself or do you have a web host? If you have a webhost, "localhost" as your database server won't usually work. Your host can give you the db server name.

[OceanRanch]

Aren't there 2 files - each SHOULD be the same.

 

1 for admin/includes/database_tables.php

 

and

 

2 for catalog/includes/database_tables.php

 

Trying the link

http://www.rulethemall.com/catalog/

 

gives the following

 

1146 - Table 'djinny_winkel.TABLE_CONFIGURATION' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from TABLE_CONFIGURATION

 

[TEP STOP]

 

Somehow the TABLE_CONFIGURATION is not getting defined. (on the catalog side only).

 

:(

[OceanRanch]

got to go for the day.....

[241]

Tom are you suspecting that this is missing in catalog/includes/database_tables.php

define('TABLE_CONFIGURATION', 'configuration');

[OceanRanch]

It think so, that certainly would cause the error.

[Tobiel]

it still doesn't work, very weird.

[241]

in your admin panel do you have the configuration data for your store

 

Does not matter I have just been to your admin and you have a problem there as well check that your database exists

[Guest]

I think you have a number of problems - your database exists but is empty.

 

You have had a bad upload of files to your server - as Oceanranch points out, on your catalog side, TABLE_CONFIGURATION is not being defined - your catalog/includes/database_tables.php is probably zero bytes in size.

 

I would suggest re-uploading (or at least checking!) the files and running the install script.

 

Matti

[Tobiel]

That might be true but it's so weird. When I install it it asks me to import the database (with the example articles and products). The thing is that it tells me it's imported correctly, but you are saying the databse is empty?

 

Anyway, I just reuploaded everything and I will re-install everything fromscratch, hope it works then...If not, are there any other options/ideas?

[AlanR]

Do you have phpMyAdmin installed? If so, just have a look at your db.

 

If you don't have it you can get it at http://www.phpMyAdmin.net

[richaldridge]

Did you get this sorted? I have just tried to install 2.2 MS2 onto a clean database with a clean install, and am getting the same issue as above.

 

The Intstall connects to the DB, then when putting in example products says the databae cannot be found!?!?

 

Cheers,

 

Rich