table prefix how to

[pppchip]

What did work perfectly well for me:

 

1) In oscommerce.sql, add prefixes to all table names. Yes this requires some search-and-replace...

 

2) In /install/includes/functions/database.php, you have to manually add the chosen prefix in function "osc_db_test_connection" to the table "configuration". This is part of an access test that does not make use of the standard functions.

 

3) In /includes/application_top.php, add the chosen prefix to all tablenames.

 

Proceed with the install procedure, either automatic or custom. I have not seen any problem with this patch yet.

 

Andreas