Problem after reinstall.

Hi Bassman!

We spoke on the phone, but if you haven't already, fill out a support request and we can take a look at that a little closer:

https://www.interactivetools.com/support/email_support_form.php

I've done that. Donna. Hope to have a suggestion soon :)

No I don't unfortunately, Dave. What now?

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!

Thanks Dave,
Yes, I understand the process. I have already restored one section of our site, thank you! The rest is going to be a hard slog but I know what to do and most of the rest will be pretty easy because most of the other schemas will almost identical.

Dave, I do have another problem: When re-uploading photos that got deleted with the rest of the site (through the Admin section) I get this error:
Temp Upload dir '/var/virtual/webupload/' does't exist! Ask server admin to check 'upload_tmp_dir' setting in php.ini.

What have I missed?

Any idea?

Hi Bassman,

It sounds like the temporary upload directory that PHP uses to receive uploads doesn't exist. Try creating it if possible or ask your server admin or web host to check the 'upload_tmp_dir' setting in php.ini and let them know you can't upload files through PHP.

Let me know how it goes.