The following warnings occurred:

Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 783 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 783 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux) File Line Function /global.php(841) : eval()'d code 40 errorHandler->error /global.php 841 eval /printthread.php 16 require_once Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 909 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 5024 errorHandler->error /global.php 909 build_theme_select /printthread.php 16 require_once Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 7162 errorHandler->error /inc/functions.php 5044 is_member /global.php 909 build_theme_select /printthread.php 16 require_once Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 1415 errorHandler->error /inc/functions.php 1370 fetch_forum_permissions /printthread.php 76 forum_permissions Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error

Missing DB tables error on upgrade - Printable Version +- Form Tools (https://forums.formtools.org) +-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1) +--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5) +--- Thread: Missing DB tables error on upgrade (/showthread.php?tid=1448)

Missing DB tables error on upgrade - xnau - Jul 10th, 2011 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? RE: Missing DB tables error on upgrade - Ben - Jul 11th, 2011 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 RE: Missing DB tables error on upgrade - xnau - Jul 11th, 2011 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!