Missing DB tables error on upgrade

[xnau]

I attempted to upgrade my 2.0.0 beta installation directly to 2.1.0 beta today, and got a missing tables error. It's not finding some of the tables, so I know it's connecting to the database and finding the tables-- just not all the ones it's expecting to find.

ft2_field_type_setting_options
ft2_field_type_settings
ft2_field_types
ft2_form_email_fields
ft2_hook_calls
ft2_list_groups
ft2_new_view_submission_defaults
ft2_option_lists
ft2_view_columns

Presumably, these are new tables added by one of the upgrades I skipped, but I would expect it to just build the tables for me.

Perhaps I shouldn't have taken this particular upgrade path, but I went through the regular upgrade process and there was no indication it was not a good idea.

Do I need to revert and go through an intermediate upgrade before getting to the latest beta?

[Ben]

Hi xnau,

Did you see any warnings or notifications when you upgraded? Anything at all?

Yes, clearly the upgrade script failed... Hmm. You *could* manually add the tables, but I'd suggest reverting to the old version and trying again. Even though you'd create the tables properly, the upgrade script populates them with the correct data based on your existing database content.

Would you like me to upgrade your installation for you? I can debug the whole thing, find out what went wrong and ensure it's upgraded properly. (This would be doing me a favour as much as me doing you one, since it would help me locate the problem in the upgrade script!). If so, email me at ben.keen@gmail.com or PM me through the forums.

If not, no worries. Definitely revert back to your old version, try a fresh upgrade and watch out for problems.

- Ben

[xnau]

Thanks, Ben...would take you up on that but I was trying to get it done overnight (busy site) and I couldn't wait.

What I did was revert the install from a backup, then upgraded on to 2.0.6. This worked fine, it built the tables when I logged in. Later, I plan to upgrade to the latest beta.

Oh, and to answer your question, there was no indication that something was not right when the upgrade file was being put together. It was only after uploading the files and attempting to log in that I got the "DB tables are missing" message. My PHP log was clean, so MySql didn't complain.

Thanks again, your support here is awesome!