• From: Egypt, Cairo
  • Registered: 02/15/2021
  • Posts: 9

Topic: Multi companies

I have open multi company on front accounting I got some error because i Have one database and and only tables in database give No 0 before table name as below details:

Company    Database Host    Database Port    Database User    Database Name    Table Pref    Charset    Default       
Eurotel    localhost        eurotel_fausr    eurotel_fadb    0_    Unicode (multilanguage)    Yes       
EuroTel EE    localhost        eurotel_fausr    eurotel_fadb    1_    Unicode (multilanguage)    No       
EuroTel HUlocalhost        eurotel_fausr    eurotel_fadb    2_    Unicode (multilanguage)    No       
Gate Istanbul    localhost        tthubadmin_gate    tthubadmin_Gate-istanbul    4_    Unicode (multilanguage)    No       

What means table Pref ?

only i got in my database table pref as 0 only no other tables
can help on this issue with thanks in advance

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Multi companies

Table prefix is quite useful when you are using same database for multiple companies.  When You are using different database for each company. No need to keep the table prefix
But you need to maintain the config_db.php clearly to use it.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website