Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

How to set up multiple tables in one sql database


Recommended Posts

My host only allows one sql database, in which I've already installed two forums and several weblogs. I plan to set up multiple stores for some of my best users. So how can I set prefix to OSC tables to make sure they won't mingle with each other?


I tried to add prefix to all OSC tables manually in phpMyAdmin, then I changed all entries in '/includes/database_tables.php' accordingly. For example, I changed the table 'configuation' to 'shopping_configuation' in both phpMyAdmin and database_tables.php. However, I still get the following error message:


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


select configuration_key as cfgKey, configuration_value as cfgValue from configuration



Did I miss anything? Do I need to modify the two configure.php files as well? If so, how? I've set everything such as DB_SERVER, USERNAME, PASSWORD, DB_DATABASE according to the requirements of my hosting server. However, I don't quite understand the function of the last one: STORE_SESSIONS.


I'm not so good at PHP so your detailed instructions are highly appreciated!

Link to comment
Share on other sites


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

  • Create New...