Re: [Bassman] Problem after reinstall.
It's going to be a bit of work to restore, but possible. You need to re-create your sections to match what's in MySQL
You can't create a new section with the same name as an existing MySQL table, but there's a trick I'll show you to do it, and it should make your old fields available again.
First up, I recommend backing up MySQL if you can so you don't lose anything else.
Next, do you know your old table names? If not you can use the "MySQL Console" plugin or PHPMyAdmin if you have it and type in: SHOW TABLES
Once you know your tablenames, create a section with the same name as an old table but with a 2 on the end (eg: products2). Then go into /cmsAdmin/data/schema/ through FTP and rename the file to remove the 2.
When you go back to the field editor it should list all the mysql fields with unknown or none for the field type. For each field modify the field, give it a label and set the field type to "textfield" (or whatever it was). Only leave these fields as none: num, createdDate, createdByUserNum, lastUpdated, lastUpdatedByUserNum, dragSortOrder.
So that's the process, and I said, it's a bit of work. Let me know how it goes.
PS: You might want to double check with your host that they don't have any backups. Even older backups would give you a jump start on this process. You just need the files from /data/schema/
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com