Changing the Database Table Prefix

Ben

I'd like to run multiple installations of Vanilla on my server, but I only have one mySQL database.

I edited the mysql files to create differently named sets of tables. But I can't find anywhere to tell Vanilla to use a different prefix.

Is there any way to change the table prefix of either 0.9.2 or version 1? From LUM_ to something else?

Well I just found the last time I asked this. Mark said then it would be an option in the next version, but I can't see where this option is.

Mark

$Configuration['DATABASE_TABLE_PREFIX'] = 'whatever';

Krak

dont you need to change

$DatabaseTables['User'] = 'LUM_User';

also?

Mark

No. The user table doesn't rely on the Database prefix. It must always be declared explicitly.

Ben

Isn't there an additional file that contains some user table info, with its own prefix that needs to be defined? Where does the user table need to be defined then?

Mark

What are you talking about?

It *is* defined in appg/database.php *WITH* the LUM_ prefix.

The SqlBuilder object doesn't add any prefix to the user table.

This is done so that you can explicitly define a user table with a name other than "LUM_User".

So, if you were going to integrate Vanilla's user table with your TennisShoeWarehouse database, you could open up your conf/database.php and add this:

$DatabaseTables['User'] = 'TennisShoeWarehouseUsers';

Ben

Ahh.. Ingenious. I was looking in the conf/database.php

Ben

Wahey! I now have a fully working installation of revision 375.

benjwalker

Apologies, I'm a Vanilla n00b. But where do I find "$Configuration['DATABASE_TABLE_PREFIX']"? Is it something that's preconfigured or do I have to add this variable in?

Minisweeper

I'm guessing its in appg/settings.php. Copy the line in there into conf/settings.php and change the prefix as necessary.

benjwalker

Found it, thanks lots ;)

benjwalker

So I've installed Vanilla, renamed all the tables, added "$Configuration['DATABASE_TABLE_PREFIX'] = 'ph_forum_';" to conf/settings.php It should work, right? Think again... when trying to sign in it comes up with... "The error occurred on or near: Table 'db213135163.LUM_User' doesn't exist" Why is it still looking for tables with prefix LUM?

Minisweeper

Because the user table name setting is seperate. You'd need to copy that into your conf/settings.php too and change it to ph_forum_User

benjwalker

Genius! I love you! Thanks for putting up with a n00b :)

marikka

Just a note here: During my current integration of my own app and vanilla, I wanted to integrate both user- and role-tables. Solution: I named the prefix '' (empty) and added the prefixes manually to each table in database.php I understand the point of having the user table named explicitly, but it's inconsistent. Maybe you could use the prefix in defining the tables in appg/database.php? in appg/settings.php: $Configuration['DATABASE_TABLE_PREFIX'] = 'LUM_'; in appg/database.php $DatabaseTables['User'] = $Configuration['DATABASE_TABLE_PREFIX'] . 'User'; $DatabaseTables['Role'] = $Configuration['DATABASE_TABLE_PREFIX'] . 'Role';