Trouble upgrading from 3 to 4
How Do I?
I’m trying to run the installer and am stuck with this error.
Exception Caught
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, MemberGroup_member_groups.can_access_addons as MemberGroup__can_access_addons, MemberGroup_member_groups.can_access_members as MemberGroup__can_access_members, MemberGroup_member_groups.can_access_sys_prefs as MemberGroup__can_access_sys_prefs, MemberGroup_member_groups.can_access_comm as MemberGroup__can_access_comm, MemberGroup_member_groups.can_access_utilities as MemberGroup__can_access_utilities, MemberGroup_member_groups.can_access_data as MemberGroup__can_access_data, MemberGroup_member_groups.can_access_logs as MemberGroup__can_access_logs, MemberGroup_member_groups.can_admin_design as MemberGroup__can_admin_design, MemberGroup_member_groups.can_delete_members as MemberGroup__can_delete_members, MemberGroup_member_groups.can_admin_mbr_groups as MemberGroup__can_admin_mbr_groups, MemberGroup_member_groups.can_admin_mbr_templates as MemberGroup__can_admin_mbr_templates, MemberGroup_member_groups.can_ban_users as MemberGroup__can_ban_users, MemberGroup_member_groups.can_admin_addons as MemberGroup__can_admin_addons, MemberGroup_member_groups.can_edit_categories as MemberGroup__can_edit_categories, MemberGroup_member_groups.can_delete_categories as MemberGroup__can_delete_categories, MemberGroup_member_groups.can_view_other_entries as MemberGroup__can_view_other_entries, MemberGroup_member_groups.can_edit_other_entries as MemberGroup__can_edit_other_entries, MemberGroup_member_groups.can_assign_post_authors as MemberGroup__can_assign_post_authors, MemberGroup_member_groups.can_create_entries as MemberGroup__can_create_entries, MemberGroup_member_groups.can_edit_self_entries as MemberGroup__can_edit_self_entries, MemberGroup_member_groups.can_delete_self_entries as MemberGroup__can_delete_self_entries, MemberGroup_member_groups.can_delete_all_entries as MemberGroup__can_delete_all_entries, MemberGroup_member_groups.can_view_other_comments as MemberGroup__can_view_other_comments, MemberGroup_member_groups.can_edit_own_comments as MemberGroup__can_edit_own_comments, MemberGroup_member_groups.can_delete_own_comments as MemberGroup__can_delete_own_comments, MemberGroup_member_groups.can_edit_all_comments as MemberGroup__can_edit_all_comments, MemberGroup_member_groups.can_delete_all_comments as MemberGroup__can_delete_all_comments, MemberGroup_member_groups.can_moderate_comments as MemberGroup__can_moderate_comments, MemberGroup_member_groups.can_send_cached_email as MemberGroup__can_send_cached_email, MemberGroup_member_groups.can_email_member_groups as MemberGroup__can_email_member_groups, MemberGroup_member_groups.can_email_from_profile as MemberGroup__can_email_from_profile, MemberGroup_member_groups.can_view_profiles as MemberGroup__can_view_profiles, MemberGroup_member_groups.can_edit_html_buttons as MemberGroup__can_edit_html_buttons, MemberGroup_member_groups.can_delete_self as MemberGroup__can_delete_self, MemberGroup_member_groups.mbr_delete_notify_emails as MemberGroup__mbr_delete_notify_emails, MemberGroup_member_groups.can_post_comments as MemberGroup__can_post_comments, MemberGroup_member_groups.exclude_from_moderation as MemberGroup__exclude_from_moderation, MemberGroup_member_groups.can_search as MemberGroup__can_search, MemberGroup_member_groups.search_flood_control as MemberGroup__search_flood_control, MemberGroup_member_groups.can_send_private_messages as MemberGroup__can_send_private_messages, MemberGroup_member_groups.prv_msg_send_limit as MemberGroup__prv_msg_send_limit, MemberGroup_member_groups.prv_msg_storage_limit as MemberGroup__prv_msg_storage_limit, MemberGroup_member_groups.can_attach_in_private_messages as MemberGroup__can_attach_in_private_messages, MemberGroup_member_groups.can_send_bulletins as MemberGroup__can_send_bulletins, MemberGroup_member_groups.include_in_authorlist as MemberGroup__include_in_authorlist, MemberGroup_member_groups.include_in_memberlist as MemberGroup__include_in_memberlist, MemberGroup_member_groups.cp_homepage as MemberGroup__cp_homepage, MemberGroup_member_groups.cp_homepage_channel as MemberGroup__cp_homepage_channel, MemberGroup_member_groups.cp_homepage_custom as MemberGroup__cp_homepage_custom, MemberGroup_member_groups.can_upload_new_files as MemberGroup__can_upload_new_files, MemberGroup_member_groups.can_edit_files as MemberGroup__can_edit_files, MemberGroup_member_groups.can_delete_files as MemberGroup__can_delete_files, MemberGroup_member_groups.can_upload_new_toolsets as MemberGroup__can_upload_new_toolsets, MemberGroup_member_groups.can_edit_toolsets as MemberGroup__can_edit_toolsets, MemberGroup_member_groups.can_delete_toolsets as MemberGro
any thoughts? i’m able to roll back to my EE3 install and that works fine.
Hey @liberty79 if you need assistance from our team, please contact support and we are happy to help you out. That error looks like you are upgrading from v3 to v4 without first being on the latest version of v3 perhaps?
I’m running into the same error… can anyone report back on how this was resolved?
I’m upgrading from EE 3.5.17 (the latest EE3 version), so it shouldn’t be a version issue. Also, I see this error right when I hit admin.php. It’s before I even get a chance to start running the upgrade script.
Any help would be valuable!
Is the installer folder in place? Sounds like it’s not. Where are you getting your v4/v5 download?
Thanks for the response Derek. I downloaded v5.1.3 from the https://expressionengine.com homepage. I’m definitely seeing an “installer” folder in system/ee (which I copied over from the download), but it doesn’t show up anywhere in the stack trace:
0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query(‘SELECT MemberGr…’)
1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute(‘SELECT MemberGr…’)
2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query(‘SELECT MemberGr…’)
3 ee/legacy/database/DB_active_rec.php(1138): CI_DB_driver->query(‘SELECT MemberGr…’)
4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(49): CI_DB_active_record->get()
5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(282): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()
6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(228): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Select’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(144): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(55): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()
9 ee/EllisLab/ExpressionEngine/Model/Member/Member.php(558): EllisLab\ExpressionEngine\Service\Model\Query\Builder->first()
10 ee/legacy/libraries/Cp.php(104): EllisLab\ExpressionEngine\Model\Member\Member->getCPHomepageURL()
11 ee/legacy/libraries/Core.php(475): Cp->set_default_view_variables()
12 ee/legacy/core/Controller.php(100): EE_Core->run_cp()
13 ee/legacy/controllers/cp/login.php(23): CP_Controller->__construct()
14 ee/EllisLab/ExpressionEngine/Core/Core.php(228): Login->__construct()
15 ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
16 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
17 admin.php(153): require_once(‘…’)
17 admin.php(153): require_once(‘…’)
Any other thoughts on this?
Yeah your installer isn’t running, it’s just trying to access the app. Can you share your config file’s full contents? Make sure to blank out your URLs, passwords and encryption keys from those settings.
Sure. Here’s the config.php we’ve been using for our v3 site (I’ve shortened the comments for brevity):
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require '.env.php';
$config['session_crypt_key'] = 'XXXXXXXXX';
$config['enable_devlog_alerts'] = 'n';
$config['database'] = array (
'expressionengine' =>
array (
'database' => $env['database']['database'],
'hostname' => $env['database']['hostname'],
'username' => $env['database']['username'],
'password' => $env['database']['password'],
'db_debug' => $env['database']['debug'],
'cache_on' => $env['database']['cache'],
),
);
/*
| ExpressionEngine Config Items
|--------------------------------------------------------------------------
*/
$config['app_version'] = "3.5.17";
$config['install_lock'] = "";
$config['license_number'] = "XXXXXXXXX";
$config['debug'] = $env['debug'] ? '1' : '0';
$config['cp_url'] = "/admin.php";
$config['doc_url'] = "https://docs.expressionengine.com/v3/";
$config['is_system_on'] = "y";
$config['site_label'] = "XXXXXXXXX";
$config['cookie_prefix'] = "";
$config['allow_extensions'] = "y";
$config['enable_db_caching'] = "n";
$config['theme_folder_path'] = $env['doc_root'] . "/themes";
$config['server_offset'] = '';
$config['hidden_template_indicator'] = '.';
$config['cache_driver'] = 'file';
$config['tz_country'] = 'us';
$protocol = $env['database']['hostname'] == "127.0.0.1" ? "http://" : "https://";
$config['site_url'] = $protocol . $_SERVER['SERVER_NAME'];
/*
| Set image path based on environment
|--------------------------------------------------------------------------
*/
$config['upload_preferences'] = array(
2 => array(
'name' => 'Primary Message Images',
'server_path' => $env['doc_root'] . '/uploads/header_images/',
'url' => '/uploads/header_images/'
),
3 => array(
'name' => 'Secondary Message Images',
'server_path' => $env['doc_root'] . '/uploads/secondary_message_images/',
'url' => '/uploads/secondary_message_images/'
),
4 => array(
'name' => 'Employee Images',
'server_path' => $env['doc_root'] . '/uploads/employee_images/',
'url' => '/uploads/employee_images/'
),
5 => array(
'name' => 'Featured Images',
'server_path' => $env['doc_root'] . '/uploads/featured_images/',
'url' => '/uploads/featured_images/'
),
6 => array(
'name' => 'Article Images',
'server_path' => $env['doc_root'] . '/uploads/article_uploads/',
'url' => '/uploads/article_uploads/'
)
);
/*
| Base Site URL
|--------------------------------------------------------------------------
*/
$config['base_url'] = "";
/*
| Index File
|--------------------------------------------------------------------------
*/
$config['index_page'] = "";
/*
| URI PROTOCOL
|--------------------------------------------------------------------------
*/
$config['uri_protocol'] = "AUTO";
/*
| URL suffix
|--------------------------------------------------------------------------
*/
$config['url_suffix'] = "";
/*
| Default Language
|--------------------------------------------------------------------------
*/
$config['language'] = "english";
/*
| Default Character Set
|--------------------------------------------------------------------------
*/
$config['charset'] = "UTF-8";
/*
| Enable/Disable System Hooks
|--------------------------------------------------------------------------
*/
$config['enable_hooks'] = TRUE;
/*
| Class Extension Prefix
|--------------------------------------------------------------------------
*/
$config['subclass_prefix'] = "EE_";
/*
| Allowed URL Characters
|--------------------------------------------------------------------------
*/
$config['permitted_uri_chars'] = "a-z 0-9~%.:_\-";
/*
| Enable Query Strings
|--------------------------------------------------------------------------
*/
$config['enable_query_strings'] = FALSE;
$config['directory_trigger'] = "D";
$config['controller_trigger'] = "C";
$config['function_trigger'] = "M";
/*
| Error Logging Threshold
|--------------------------------------------------------------------------
*/
$config['log_threshold'] = 0;
/*
| Error Logging Directory Path
|--------------------------------------------------------------------------
*/
/*
| Date Format for Logs
|--------------------------------------------------------------------------
*/
$config['log_date_format'] = "Y-m-d H:i:s";
/*
| Encryption Key
|--------------------------------------------------------------------------
*/
$config['encryption_key'] = "XXXXXXXXXX";
/*
| Global XSS Filtering
|--------------------------------------------------------------------------
*/
$config['global_xss_filtering'] = FALSE;
/*
| CSRF Protection
|--------------------------------------------------------------------------
*/
$config['csrf_protection'] = FALSE;
/*
| Output Compression
|--------------------------------------------------------------------------
*/
$config['compress_output'] = FALSE;
/*
| Master Time Reference
|--------------------------------------------------------------------------
*/
$config['time_reference'] = "local";
/*
| Rewrite PHP Short Tags
|--------------------------------------------------------------------------
*/
$config['rewrite_short_tags'] = TRUE;
/*
| Reverse Proxy IPs
|--------------------------------------------------------------------------
*/
$config['proxy_ips'] = "";
//A quick way to detect pagination
$vars['global:is_pagination'] = (preg_match('/P[0-9]+/', $_SERVER['REQUEST_URI'] )) ? TRUE : FALSE;
/* End of file config.php */
/* Location: ./system/expressionengine/config/config.php */
/**
* Pull additional info for SEO Lite
*
* channel_id => array(field_id => tag_name)
**/
$config['seolite_extra'] = array(
'8' => array( // post_article
'og-image' => array(
'field_id' => 63, // p_article_featured_image
'field_type' => 'file',
)
)
);Looks fine, thanks. What if you take the v5 download and put it in a new folder with a new database and try to install? Does the installer show up for you? Debugging this from afar is a little difficult, but all signs point to an unreadable installer folder, or something in your environment that is forcing the requests to the control panel rather than the updater.
Gotcha. I’ll start doing some debugging in that direction. Thanks for the help!