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

Hi all, couple errors I am getting and any help would be greatly appreciated. First, when I go to upload an image in the Section Editor, I get a 401 error. I verified my directory permissions are correct and verified that my image paths are correct as well. I re-uploaded my program files, and the error was fixed.

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: [Jason] Re-Uploaded Program Files - Lost a Section Editor...

By lsare10 - June 7, 2010

Thanks Jason - nope, I did not save a copy of the Schema folder. It is called too little sleep, too little coffee. All the data is there though in the databases still...

Re: [lsare10] Re-Uploaded Program Files - Lost a Section Editor...

By Jason - June 8, 2010

Hi,

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

That makes sense - I'll give it a try!