Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Prefixed database tables not completing install


silent11

Recommended Posts

Posted

I have prefixed all of my db tables with 'shop_'. I edited oscommerce.sql as well as database_tables.php, however when I get to /install/install.php?step=7 I get the following error:

 

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Table 'commerce.configuration' doesn't exist

 

Please click on the Back button below to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

I can go into a terminal window and see the tables are created, all with the proper prefix, even 'shop_configuration'. Where is the install script getting the configuration table name from? Is that hard coded??? Why isn't the script looking for 'shop_configuration'?

 

Any help would be greatly appreciated.

Posted

There is no reason you should have edited either the sql file or especially your database_tables.php file. What ever problem you are having is not going to be fixed by the changes you made and making changes to your database_tables.php you have pretty much assured yourself that your site will not work. You need to replace the files with fresh ones and start again.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

  • 2 months later...
Posted
There is no reason you should have edited either the sql file or especially your database_tables.php file. What ever problem you are having is not going to be fixed by the changes you made and making changes to your database_tables.php you have pretty much assured yourself that your site will not work. You need to replace the files with fresh ones and start again.

 

I have the same problem! On my SQL-Server im running other scripts with the same tablenames so i must add a prefix to use osc. I did exactly the same, edit database_tables.php and oscommerce.sql. All tables are created correctly, but my error is : Table 'marookdb.configuration' doesn't exist

 

marookdb is the name of my database. Could it be, that inside the php-script a wrong enviroment variable is used to set the config ?

 

Any ideas ???

Archived

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

×
×
  • Create New...