We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Several exception errors when trying to upgrade EE3 to EE4

How Do I?

maxi's avatar
maxi
220 posts
4 years ago
maxi's avatar maxi

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(‘…’)

       
maxi's avatar
maxi
220 posts
4 years ago
maxi's avatar maxi

Should I just skip EE4 and from straight to EE5?

       
maxi's avatar
maxi
220 posts
4 years ago
maxi's avatar maxi

I’m still on PHP 5.6.21 - should I now upgrade to PHP 7.3.11 safely as I’m on EE 3.5.17? Thanks!

       
maxi's avatar
maxi
220 posts
4 years ago
maxi's avatar maxi

I’ve upgraded to PHP 7.3.11 but I’m still getting the errors above when launching the updater from EE3 to EE4… What could it be?

       
maxi's avatar
maxi
220 posts
4 years ago
maxi's avatar maxi

I upgraded straight from EE3 to EE5 and it seemed to work well.

       
Robin Sowell's avatar
Robin Sowell
13,158 posts
4 years ago
Robin Sowell's avatar Robin Sowell

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.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.