I’ve tried to upgrade from EE 3.5.17 to EE 4.3.8 but as soon as I hit admin.php the attached errors are thrown.
Have you seen that before? What should I do?
Thanks!
=== SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘MemberGroup_member_groups.can_manage_consents’ in ‘field list’: SELECT MemberGroup_member_groups.group_id as MemberGroup__group_id, MemberGroup_member_groups.site_id as MemberGroup__site_id, MemberGroup_member_groups.group_title as MemberGroup__group_title, MemberGroup_member_groups.group_description as MemberGroup__group_description, MemberGroup_member_groups.is_locked as MemberGroup__is_locked, MemberGroup_member_groups.menu_set_id as MemberGroup__menu_set_id, MemberGroup_member_groups.can_view_offline_system as MemberGroup__can_view_offline_system, MemberGroup_member_groups.can_view_online_system as MemberGroup__can_view_online_system, MemberGroup_member_groups.can_access_cp as MemberGroup__can_access_cp, MemberGroup_member_groups.can_access_footer_report_bug as MemberGroup__can_access_footer_report_bug, MemberGroup_member_groups.can_access_footer_new_ticket as MemberGroup__can_access_footer_new_ticket, MemberGroup_member_groups.can_access_footer_user_guide as MemberGroup__can_access_footer_user_guide, MemberGroup_member_groups.can_view_homepage_news as MemberGroup__can_view_homepage_news, MemberGroup_member_groups.can_access_files as MemberGroup__can_access_files, MemberGroup_member_groups.can_access_design as MemberGroup__can_access_design,
…
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error
0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query(‘SELECT MemberGr…’) 1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute(‘SELECT MemberGr…’) 2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query(‘SELECT MemberGr…’) 3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query(‘SELECT MemberGr…’) 4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(48): CI_DB_active_record->get() 5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select->run() 6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Select’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder)) 7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder)) 8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(54): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch() 9 ee/EllisLab/ExpressionEngine/Model/Member/Member.php(557): EllisLab\ExpressionEngine\Service\Model\Query\Builder->first() 10 ee/legacy/libraries/Cp.php(103): EllisLab\ExpressionEngine\Model\Member\Member->getCPHomepageURL() 11 ee/legacy/libraries/Core.php(484): Cp->set_default_view_variables() 12 ee/legacy/core/Controller.php(111): EE_Core->run_cp() 13 ee/legacy/controllers/cp/login.php(22): CP_Controller->__construct() 14 ee/EllisLab/ExpressionEngine/Core/Core.php(227): Login->__construct() 15 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array) 16 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request)) 17 html/gestione.php(147): require_once(‘…’)#17 html/gestione.php(147): require_once(‘…’)
I’m not sure what happened. It looks like a column wasn’t added to the member table. That should have happened 4.3.0 if not before. So something went wrong at that point and then the missing column caused an error later on.
The correct solution was what you did- roll it back to the start and run the upgrade again. Going from v3-v4 or to v5 directly shouldn’t have mattered and might be a coincidence. But rolling back and rerunning was the right option.
And I always go latest 3-5 just because it saves a step.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.