Multiple tables listed in Section Editor

9 posts by 3 authors in: Forums > CMS Builder
Last Post: August 13, 2008   (RSS)

By paceit - August 8, 2008

For some odd reason when I enter "Section Editors" I have a whole load of tables listed there already. e.g. htmlblobs, groups, module_news_categories, etc.. It seems all tables are listed. Is this a problem with the installation? I am on V1.20.

also, when I reordered my editors to stay at top of the list, next time I logged in they were bottom again? any ideas on what has happened? psa screenshot.

D
Attachments:

cms_image1.jpg 93K

Re: [paceit] Multiple tables listed in Section Editor

By Dave - August 8, 2008

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?
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Multiple tables listed in Section Editor

By paceit - August 8, 2008

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

Re: [paceit] Multiple tables listed in Section Editor

By Jake - August 8, 2008

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. [:)]
-----------------------------------------------------------
Cheers,
Jake Marvin - Product Specialist
support@interactivetools.com

Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

Re: [Jake] Multiple tables listed in Section Editor

By paceit - August 9, 2008

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

Re: [paceit] Multiple tables listed in Section Editor

By Jake - August 10, 2008

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. [:)]
-----------------------------------------------------------
Cheers,
Jake Marvin - Product Specialist
support@interactivetools.com

Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

Re: [paceit] Multiple tables listed in Section Editor

By Jake - August 13, 2008

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. [:)]
-----------------------------------------------------------
Cheers,
Jake Marvin - Product Specialist
support@interactivetools.com

Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

Re: [paceit] Multiple tables listed in Section Editor

By Dave - August 13, 2008

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!
Dave Edis - Senior Developer
interactivetools.com