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

1054 Unknown column error when upgrading from 3.5.15 to 4.3.6

Development and Programming

Happy Content's avatar
Happy Content
54 posts
6 years ago
Happy Content's avatar Happy Content

Getting this error when upgrading from 3.5.15 to 4.3.6.

Any ideas?

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ee_m_MemberGroup_member_groups.can_manage_consents' in 'field list':
SELECT ee_m_MemberGroup_member_groups.group_id as ee_m_MemberGroup__group_id, ee_m_MemberGroup_member_groups.site_id as ee_m_MemberGroup__site_id, ee_m_MemberGroup_member_groups.group_title as ee_m_MemberGroup__group_title, ee_m_MemberGroup_member_groups.group_description as ee_m_MemberGroup__group_description, ee_m_MemberGroup_member_groups.is_locked as ee_m_MemberGroup__is_locked, ee_m_MemberGroup_member_groups.menu_set_id as ee_m_MemberGroup__menu_set_id, ee_m_MemberGroup_member_groups.can_view_offline_system as ee_m_MemberGroup__can_view_offline_system, ee_m_MemberGroup_member_groups.can_view_online_system as ee_m_MemberGroup__can_view_online_system, ee_m_MemberGroup_member_groups.can_access_cp as ee_m_MemberGroup__can_access_cp, ee_m_MemberGroup_member_groups.can_access_footer_report_bug as ee_m_MemberGroup__can_access_footer_report_bug, ee_m_MemberGroup_member_groups.can_access_footer_new_ticket as ee_m_MemberGroup__can_access_footer_new_ticket, ee_m_MemberGroup_member_groups.can_access_footer_user_guide as ee_m_MemberGroup__can_access_footer_user_guide, ee_m_MemberGroup_member_groups.can_view_homepage_news as ee_m_MemberGroup__can_view_homepage_news, ee_m_MemberGroup_member_groups.can_access_files as ee_m_MemberGroup__can_access_files, ee_m_MemberGroup_member_groups.can_access_design as ee_m_MemberGroup__can_access_design, ee_m_MemberGroup_member_groups.can_access_addons as ee_m_MemberGroup__can_access_addons, ee_m_MemberGroup_member_groups.can_access_members as ee_m_MemberGroup__can_access_members, ee_m_MemberGroup_member_groups.can_access_sys_prefs as ee_m_MemberGroup__can_access_sys_prefs, ee_m_MemberGroup_member_groups.can_access_comm as ee_m_MemberGroup__can_access_comm, ee_m_MemberGroup_member_groups.can_access_utilities as ee_m_MemberGroup__can_access_utilities, ee_m_MemberGroup_member_groups.can_access_data as ee_m_MemberGroup__can_access_data, ee_m_MemberGroup_member_groups.can_access_logs as ee_m_MemberGroup__can_access_logs, ee_m_MemberGroup_member_groups.can_admin_design as ee_m_MemberGroup__can_admin_design, ee_m_MemberGroup_member_groups.can_delete_members as ee_m_MemberGroup__can_delete_members, ee_m_MemberGroup_member_groups.can_admin_mbr_groups as ee_m_MemberGroup__can_admin_mbr_groups, ee_m_MemberGroup_member_groups.can_admin_mbr_templates as ee_m_MemberGroup__can_admin_mbr_templates, ee_m_MemberGroup_member_groups.can_ban_users as ee_m_MemberGroup__can_ban_users, ee_m_MemberGroup_member_groups.can_admin_addons as ee_m_MemberGroup__can_admin_addons, ee_m_MemberGroup_member_groups.can_edit_categories as ee_m_MemberGroup__can_edit_categories, ee_m_MemberGroup_member_groups.can_delete_categories as ee_m_MemberGroup__can_delete_categories, ee_m_MemberGroup_member_groups.can_view_other_entries as ee_m_MemberGroup__can_view_other_entries, ee_m_MemberGroup_member_groups.can_edit_other_entries as ee_m_MemberGroup__can_edit_other_entries, ee_m_MemberGroup_member_groups.can_assign_post_authors as ee_m_MemberGroup__can_assign_post_authors, ee_m_MemberGroup_member_groups.can_create_entries as ee_m_MemberGroup__can_create_entries, ee_m_MemberGroup_member_groups.can_edit_self_entries as ee_m_MemberGroup__can_edit_self_entries, ee_m_MemberGroup_member_groups.can_delete_self_entries as ee_m_MemberGroup__can_delete_self_entries, ee_m_MemberGroup_member_groups.can_delete_all_entries as ee_m_MemberGroup__can_delete_all_entries, ee_m_MemberGroup_member_groups.can_view_other_comments as ee_m_MemberGroup__can_view_other_comments, ee_m_MemberGroup_member_groups.can_edit_own_comments as ee_m_MemberGroup__can_edit_own_comments, ee_m_MemberGroup_member_groups.can_delete_own_comments as ee_m_MemberGroup__can_delete_own_comments, ee_m_MemberGroup_member_groups.can_edit_all_comments as ee_m_MemberGroup__can_edit_all_comments, ee_m_MemberGroup_member_groups.can_delete_all_comments as ee_m_MemberGroup__can_delete_all_comments, ee_m_MemberGroup_member_groups.can_moderate_comments as ee_m_MemberGroup__can_moderate_comments, ee_m_MemberGroup_member_groups.can_send_cached_email as ee_m_MemberGroup__can_send_cached_email, ee_m_MemberGroup_member_groups.can_email_member_groups as ee_m_MemberGroup__can_email_member_groups, ee_m_MemberGroup_member_groups.can_email_from_profile as ee_m_MemberGroup__can_email_from_profile, ee_m_MemberGroup_member_groups.can_view_profiles as ee_m_MemberGroup__can_view_profiles, ee_m_MemberGroup_member_groups.can_edit_html_buttons as ee_m_MemberGroup__can_edit_html_buttons, ee_m_MemberGroup_member_groups.can_delete_self as ee_m_MemberGroup__can_delete_self, ee_m_MemberGroup_member_groups.mbr_delete_notify_emails as ee_m_MemberGroup__mbr_delete_notify_emails, ee_m_MemberGroup_member_groups.can_post_comments as ee_m_MemberGroup__can_post_comments, ee_m_MemberGroup_member_groups.exclude_from_moderation as ee_m_MemberGroup__exclude_from_moderation, ee_m_MemberGroup_member_groups.can_search as ee_m_MemberGroup__can_search, ee_m_MemberGroup_member_groups.search_flood_control as ee_m_MemberGroup__search_flood_control, ee_m_MemberGroup_member_groups.can_send_private_messages as ee_m_MemberGroup__can_send_private_messages, ee_m_MemberGroup_member_groups.prv_msg_send_limit as ee_m_MemberGroup__prv_msg_send_limit, ee_m_MemberGroup_member_groups.prv_msg_storage_limit as ee_m_MemberGroup__prv_msg_storage_limit, ee_m_MemberGroup_member_groups.can_attach_in_private_messages as ee_m_MemberGroup__can_attach_i....
       
Derek Jones's avatar
Derek Jones
7,561 posts
6 years ago
Derek Jones's avatar Derek Jones

Did you update to 3.5.17 before upgrading to v4?

       
Happy Content's avatar
Happy Content
54 posts
6 years ago
Happy Content's avatar Happy Content

Thanks Derek. Robin got this sorted for me via a support request. All good now.

       
chris thacker's avatar
chris thacker
112 posts
4 years ago
chris thacker's avatar chris thacker

and what was the solution?

       
Happy Content's avatar
Happy Content
54 posts
4 years ago
Happy Content's avatar Happy Content

Can’t remember sorry. Had a look for the old ticket but it isn’t in the system.

       
chris thacker's avatar
chris thacker
112 posts
4 years ago
chris thacker's avatar chris thacker

bummer, thanks for replying.

       
chris thacker's avatar
chris thacker
112 posts
4 years ago
chris thacker's avatar chris thacker

I tried going straight from v3 to v5, per Robin’s comment here, and it worked.

https://expressionengine.com/forums/topic/252826/several-exception-errors-when-trying-to-upgrade-ee3-to-ee4

       

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.