 |
paceit
User
Aug 8, 2008, 4:32 AM
Post #1 of 9
(7803 views)
Shortcut
|
|
Multiple tables listed in Section Editor
|
Can't Post
|
|
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
(92.0 KB)
|
|
| |
|
Dave
Staff
/ Moderator
Aug 8, 2008, 7:34 AM
Post #2 of 9
(7780 views)
Shortcut
|
|
Re: [paceit] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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
|
|
| |
|
paceit
User
Aug 8, 2008, 8:12 AM
Post #3 of 9
(7764 views)
Shortcut
|
|
Re: [Dave] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
cms_ ... I guess that was the default. Any way I can change this if this is the issue?
|
|
| |
|
Jake
Staff
/ Moderator
Aug 8, 2008, 12:54 PM
Post #4 of 9
(7668 views)
Shortcut
|
|
Re: [paceit] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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 Swanson - 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.
|
|
| |
|
paceit
User
Aug 9, 2008, 12:58 AM
Post #5 of 9
(7580 views)
Shortcut
|
|
Re: [Jake] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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
|
|
| |
|
Jake
Staff
/ Moderator
Aug 10, 2008, 2:37 PM
Post #6 of 9
(6576 views)
Shortcut
|
|
Re: [paceit] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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 Swanson - 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.
|
|
| |
|
paceit
User
Aug 12, 2008, 7:01 AM
Post #7 of 9
(5165 views)
Shortcut
|
|
Re: [Jake] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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
|
|
| |
|
Jake
Staff
/ Moderator
Aug 13, 2008, 11:25 AM
Post #8 of 9
(3169 views)
Shortcut
|
|
Re: [paceit] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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 Swanson - 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.
|
|
| |
|
Dave
Staff
/ Moderator
Aug 13, 2008, 7:30 PM
Post #9 of 9
(2874 views)
Shortcut
|
|
Re: [paceit] Multiple tables listed in Section Editor
[In reply to]
|
Can't Post
|
|
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
|
|
| |
|
