Re-Uploaded Program Files - Lost a Section Editor...
5 posts by 2 authors in: Forums > CMS Builder
Last Post: June 8, 2010 (RSS)
By lsare10 - June 7, 2010 - edited: June 7, 2010
However, when I re-uploaded the program files, the Listings section editor which I created was erased. The information is still in tact in the database and I don't know how to re-connect them both without having to re-do all the clients work. I even tried to create a new Section Editor with the same name Listings, but got an error that that name already exists, which it does in my database.
So in summary 1 problem:
1) Need to add again my Section Editor "Listings" to the admin side of things.
CMS Builder info below, please let me know if you need any other info.
Re: [lsare10] Re-Uploaded Program Files - Lost a Section Editor...
By Jason - June 7, 2010
Did you make a backup copy of any of the program files (specifically cmsAdmin/data/Schema) before you reuploaded the CMS Builder files? If you did, replace the Schema folder with the one you backed up. After you do this, go into your section editor, you should get a message telling you that it has loaded the fields for the Listings table.
If not, let me know, and we can try a different route.
NOTE: It's very important not to post any secure information (ie, CMS Login details, or FTP information) to the forum. Anyone can access this post.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Re-Uploaded Program Files - Lost a Section Editor...
By lsare10 - June 7, 2010
Re: [lsare10] Re-Uploaded Program Files - Lost a Section Editor...
By Jason - June 8, 2010
Okay. So the issue is that because it's missing it's Schema file, CMS Builder won't load your Listings section. But since the listing table already exists in the database (presumably with data), it won't let you create another.
This is what I would suggest:
1) Take a look at the database and note the name of each field in the listing table. It will be important that you give everything the same name that you did before.
2) Make a backup of the database. This is very important, otherwise you'll lose all of the data the client has already entered into the database. Use the backup command found in "General Settings"
3) Delete the listings table from the database. You need to be able to get rid of it before CMS Builder will let you create another section.
4) Create a new Listings section in CMS Builder. It's important that you name all of the fields the exact same as the names were in the database. If a name is wrong, you'll get an error in the next step
5) Restore your backup. If everything was named correctly, it should repopulate your section with all of the records that were previously there.
Give that a try and let me know how that goes for you.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Re-Uploaded Program Files - Lost a Section Editor...
By lsare10 - June 8, 2010