Using Max for multiple stores - database problems

[oblongpeg]

Hi all.

I am trying to utilise osCmax for a multi shop site, on a single database, but individual admin sections for each shop.

I have admin up and running ok but cannot get catalog to run.

I keep getting the error

1146 - Table 'udstore.products' doesn't exist.

I am keeping some tables untouched as they will be common for the 2 shops, such as customers, currencies, etc. Others, I am going to rename the tables for the specific shops, such as products.

I have renamed the pertinent table to shop1_products, and altered the table names in both database_tables.php files to read

define('TABLE_PRODUCTS', 'shop1_products');

Still, the index.php file is looking for the table 'products' instead of 'shop1_products'.

Is there somewhere else that needs to be modified to reflect the changed database table name other than the database_tables.php files.

Sorry for the long winded post.

[oblongpeg]

Bump