Re-Uploaded Program Files - Lost a Section Editor...

Hi,

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.

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

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.

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