annedi Posted January 26, 2023 Author Posted January 26, 2023 WOO-HOO!! The upgrade was successful. Backed up everything. Re-checked that all DB tables were InnoDB. Reverted all customizations to original files in Theme editor. Switched to PHP 8.0 It was there I encountered a Database warning on ACP Support page. The DB box had a suggested fix to run, so I -- with some trepidation -- ran that fix. Then I continued with the upgrade and all ran smoothly. My website is running OK. [hr] There is one error message in the system log attached below. Please let me know if I need to do anything about this? Thanks!! Error (1051) Unknown table 'ultravio_ipb.ultraviocore_members_features_seen': dropTable ["core_members_features_seen"] Backtrace #0 /home3/ultravio/public_html/content/system/Application/Application.php(1672): IPS\_Log::log('Error (1051) Un...', 'upgrade_error') #1 /home3/ultravio/public_html/content/applications/core/sources/Setup/Upgrade.php(511): IPS\_Application->installDatabaseUpdates(107028, 0, 10, true) #2 /home3/ultravio/public_html/content/applications/core/sources/Setup/Upgrade.php(326): IPS\core\Setup\_Upgrade->step1(Array) #3 /home3/ultravio/public_html/content/applications/core/modules/setup/upgrade/upgrade.php(47): IPS\core\Setup\_Upgrade->process(Array) #4 /home3/ultravio/public_html/content/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\core\modules\setup\upgrade\_upgrade->IPS\core\modules\setup\upgrade\{closure}(Array) #5 /home3/ultravio/public_html/content/applications/core/modules/setup/upgrade/upgrade.php(77): IPS\Helpers\_MultipleRedirect->__construct(Object(IPS\Http\Url), Object(Closure), Object(Closure)) #6 /home3/ultravio/public_html/content/system/Dispatcher/Controller.php(118): IPS\core\modules\setup\upgrade\_upgrade->manage() #7 /home3/ultravio/public_html/content/system/Dispatcher/Setup.php(220): IPS\Dispatcher\_Controller->execute() #8 /home3/ultravio/public_html/content/admin/upgrade/index.php(34): IPS\Dispatcher\_Setup->run() #9 {main}
Randy Calvert Posted January 26, 2023 Posted January 26, 2023 (edited) The message says it was attempting to drop a table that does not exist. It's not needed, but apparently did not exist in your install, so there is nothing to worry about. Edited January 26, 2023 by Randy Calvert
annedi Posted January 26, 2023 Author Posted January 26, 2023 (edited) I have the table ultraviocore_members_feature_seen. The error message references ultraviocore_members_features_seen. Has an additional s character. Edited January 26, 2023 by annedi
Marc Posted January 27, 2023 Posted January 27, 2023 First of all, Im very glad to see you managed to get upgraded 🙂 Is this showing repeatedly, or just the once just the upgrade? If just the once, I would say just to let us know if you see that happen again on any future upgrades.
Solution annedi Posted January 28, 2023 Author Solution Posted January 28, 2023 (edited) I only had this "Upgrade Error" (involving a misspelling of the table name) just the one time during the Upgrade. Could there be spelling error in your SQL upgrade script? It's on me that not all the tables in my DB were of type InnoDB. For whatever reason in the past, that didn't seem to cause a problem. This time it did! So we can reasonably say that the solution here was to change all the table types to InnoDB. Again thank you for the help!! Andrea B. P.S. I clicked the solution button to reference this post. It produced "solved by annedi". Please note that the solution was first provided above by Marc Stridgen. 😉 Edited January 28, 2023 by annedi added P.S.
Recommended Posts