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 paceit,

If you haven't done too much with the software already I'd suggest reinstalling everything, and choosing a different table prefix when you complete the installation. That's the easiest road to take.

If you have a lot of work that you need to keep, you could modify some of the CMS Builder data files as well as make changes to your database directly to convert everything over to a new table prefix. This is more advanced, but if you'd like some more specific direction on this let us know and we can outline some steps to take. [:)]

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 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!