Trying to upgrade from v4.5.4.2 to 4.7.22 using /admin/upgrade

I'm currently getting the following error:

Error: Specified key was too long; max key length is 1000 bytes ALTER TABLE `core_content_meta` ADD KEY `meta_content` (`meta_class`(250),`meta_item_id`,`meta_item_author`)
#0 /home/swsite/public_html/system/Db/Db.php(2154): IPS\_Db->query('ALTER TABLE `co...')
#1 /home/swsite/public_html/system/Db/Db.php(2187): IPS\_Db->addIndex('core_content_me...', Array)
#2 /home/swsite/public_html/system/Application/Application.php(1531): IPS\_Db->changeIndex('core_content_me...', 'meta_content', Array)
#3 /home/swsite/public_html/applications/core/sources/Setup/Upgrade.php(511): IPS\_Application->installDatabaseUpdates(106100, 26, 10, true)
#4 /home/swsite/public_html/applications/core/sources/Setup/Upgrade.php(326): IPS\core\Setup\_Upgrade->step1(Array)
#5 /home/swsite/public_html/applications/core/modules/setup/upgrade/upgrade.php(47): IPS\core\Setup\_Upgrade->process(Array)
#6 /home/swsite/public_html/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\core\modules\setup\upgrade\_upgrade->IPS\core\modules\setup\upgrade\{closure}(Array)
#7 /home/swsite/public_html/applications/core/modules/setup/upgrade/upgrade.php(77): IPS\Helpers\_MultipleRedirect->__construct(Object(IPS\Http\Url), Object(Closure), Object(Closure))
#8 /home/swsite/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\setup\upgrade\_upgrade->manage()
#9 /home/swsite/public_html/system/Dispatcher/Setup.php(220): IPS\Dispatcher\_Controller->execute()
#10 /home/swsite/public_html/admin/upgrade/index.php(34): IPS\Dispatcher\_Setup->run()
#11 {main}

----
#0 /home/swsite/public_html/applications/core/sources/Setup/Upgrade.php(535): IPS\_Log::log('Error: Specifie...', 'upgrade_error')
#1 /home/swsite/public_html/applications/core/sources/Setup/Upgrade.php(326): IPS\core\Setup\_Upgrade->step1(Array)
#2 /home/swsite/public_html/applications/core/modules/setup/upgrade/upgrade.php(47): IPS\core\Setup\_Upgrade->process(Array)
#3 /home/swsite/public_html/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\core\modules\setup\upgrade\_upgrade->IPS\core\modules\setup\upgrade\{closure}(Array)
#4 /home/swsite/public_html/applications/core/modules/setup/upgrade/upgrade.php(77): IPS\Helpers\_MultipleRedirect->__construct(Object(IPS\Http\Url), Object(Closure), Object(Closure))
#5 /home/swsite/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\setup\upgrade\_upgrade->manage()
#6 /home/swsite/public_html/system/Dispatcher/Setup.php(220): IPS\Dispatcher\_Controller->execute()
#7 /home/swsite/public_html/admin/upgrade/index.php(34): IPS\Dispatcher\_Setup->run()

I'm unable to raise a support case via ACP as I'm getting:

UnderflowException: lang_not_exists__health_system_log_title (0)
#0 /home/swsite/public_html/applications/core/modules/admin/support/support.php(1595): IPS\_Lang->get('health_system_l...')
#1 /home/swsite/public_html/applications/core/modules/admin/support/support.php(67): IPS\core\modules\admin\support\_support->getLogChart()
#2 /home/swsite/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\support\_support->manage()
#3 /home/swsite/public_html/applications/core/modules/admin/support/support.php(48): IPS\Dispatcher\_Controller->execute()
#4 /home/swsite/public_html/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\support\_support->execute()
#5 /home/swsite/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#6 {main}

Edited July 5Jul 5 by FlameboardSW

You need to ensure that

• Your tables are all INNODB

• Your table are not set to use compact row type