Multiple tables listed in Section Editor

Hi paceit,

The way CMS Builder identifies it's tables is to look for tables that start with it's table prefix.

What is your current table prefix set to? And is there other programs using the same prefix?

cms_ ... I guess that was the default. Any way I can change this if this is the issue?

Hi Jake,

I've done a fair bit of work, so would rather modify the data files. Please advise on what I need to change, thanks.

So the upshot is to always specify a different prefix on installation, right?

Cheers, David

Hi David,

If you're using the same database for multiple CMS Builder installations, then you'll definitely want to use a different table prefix each time. If it's a completely separate database it won't matter unless there are existing tables there that use your chosen prefix.

The first thing you need to do to resolve this is use a tool like MySQL Administrator to access your database and change the table prefixes for the tables that CMS Builder uses:

http://dev.mysql.com/downloads/gui-tools/5.0.html

Secondly, you need to download the "settings.dat.php" file in the software's /data directory. Open that up in a text editor and look for this line:

tablePrefix = "cms_"

Now change the prefix there to the one you used in the first step, and re-upload this file to your server.

Once those changes have been made you should be good to go. [:)]

Hi Jake,

Thanks for the update. Just to clarify, are you saying I change the prefix for MY tables OR for the System default tables which are part of CMS Builder?

I am assuming the former, but please clarify, Regards, Dave

Hi paceit,

If you change the table prefix for tables which are not part of CMS Builder, you'll probably break any other application on your site that's using that data. You'll want to adjust the table prefixes for the tables that are used by CMS Builder. [:)]

Or, another option is just to ignore the extra tables. I may actually change that in the next few releases to not show them anyway (for completely unrelated reasons).

But the fix for now, if it's an issue, would be to use phpMyAdmin or Mysql Query Browser or some MySQL tool to rename the CMS Builder tables to have a different prefix and update the prefix in /data/settings.dat.php

Hope that helps!