Getting errors when attempting to upgrade to EE6
How Do I?
I’m trying to go from 3.5 to 6. The first time I tried, it was running through the update fine except when it made it to 6 it broke because I had all my third party add-ons installed and it was looking for Detour Pro. People suggested I uninstall or upgrade 3rd party add ons before upgrading to ee6, so I did that but now I’m getting this error when accessing http://mysite.com/admin
Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Channel_channels.sticky_enabled' in 'field list':
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url FROM (`exp_channels` as Channel_channels) LIMIT 18446744073709551615
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT Channel_...')
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('SELECT Channel_...')
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('SELECT Channel_...')
#3 ee/legacy/database/DB_active_rec.php(1138): CI_DB_driver->query('SELECT Channel_...')
#4 ee/ExpressionEngine/Service/Model/Query/Select.php(50): CI_DB_active_record->get()
#5 ee/ExpressionEngine/Service/Model/DataStore.php(282): ExpressionEngine\Service\Model\Query\Select->run()
#6 ee/ExpressionEngine/Service/Model/DataStore.php(228): ExpressionEngine\Service\Model\DataStore->runQuery('Select', Object(ExpressionEngine\Service\Model\Query\Builder))
#7 ee/ExpressionEngine/Service/Model/Query/Builder.php(144): ExpressionEngine\Service\Model\DataStore->selectQuery(Object(ExpressionEngine\Service\Model\Query\Builder))
#8 ee/ExpressionEngine/Service/Model/Query/Builder.php(63): ExpressionEngine\Service\Model\Query\Builder->fetch()
#9 ee/installer/controllers/wizard.php(473): ExpressionEngine\Service\Model\Query\Builder->all()
#10 ee/installer/controllers/wizard.php(428): Wizard->postflight()
#11 ee/installer/controllers/wizard.php(242): Wizard->preflight()
#12 [internal function]: Wizard->_remap('index', Array)
#13 ee/ExpressionEngine/Core/Core.php(268): call_user_func_array(Array, Array)
#14 ee/ExpressionEngine/Core/Core.php(118): ExpressionEngine\Core\Core->runController(Array)
#15 ee/ExpressionEngine/Boot/boot.php(162): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#16 admin/index.php(154): require_once('...')
#16 admin/index.php(154): require_once('...')Sorry this is legacy code I’m trying to bring up to date for a client so I’m not very familiar with old EE stuff. Does anyone see any obvious way forward from here? Thanks.
Just to be clear, it’s not even initiating the upgrade. I’m getting this error before any upgrade code runs, as far as I can tell.
I don’t see how to delete this post, so I’ll just add here that I don’t have the same problem anymore and that I’m stuck at another place now.
The upgrade successfully ran, and I got to the screen that tells me how many template errors I need to clean up. But when I clicked the “log in” link I got an error telling me that it can’t connect to my db. But prior to the upgrade running my site was running fine and I didn’t do anything to the config.php file, so I don’t see why it can no longer reach the db. Here is the error:
Could not connect to the database using the credentials provided.
ee/installer/updater/ExpressionEngine/Updater/Service/Updater/RequirementsChecker.php:71
Stack Trace: Please include when reporting this error
#0 ee/installer/updater/ExpressionEngine/Updater/Service/Updater/RequirementsChecker.php(209): RequirementsChecker->{closure}(Object(Requirement))
#1 ee/installer/updater/ExpressionEngine/Updater/Service/Updater/RequirementsChecker.php(75): Requirement->__construct('Your MySQL vers...', Object(Closure))
#2 ee/installer/updater/ExpressionEngine/Updater/Service/Updater/RequirementsChecker.php(30): RequirementsChecker->setupRequirements()
#3 ee/installer/controllers/wizard.php(350): RequirementsChecker->__construct(Array)
#4 ee/installer/controllers/wizard.php(242): Wizard->preflight()
#5 [internal function]: Wizard->_remap('index', Array)
#6 ee/ExpressionEngine/Core/Core.php(268): call_user_func_array(Array, Array)
#7 ee/ExpressionEngine/Core/Core.php(118): ExpressionEngine\Core\Core->runController(Array)
#8 ee/ExpressionEngine/Boot/boot.php(162): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#9 admin/index.php(154): require_once('...')
#9 admin/index.php(154): require_once('...')Ha. Never mind I see the problem again. I don’t have the minimum requirement for mysql. Darn it.
Hi Brimby,
Was just reading the thread. Ah, gotcha. Yeah, I’d recommend getting in touch with your host about upgrading your MySQL version.
Also, just to throw it out there. A lot of the people who used to frequent for forums are now in Slack (theres almost 7,000 of us in there). Theres often quicker responses in there as a whole.
https://expressionengine.com/blog/join-us-in-slack
Thanks, -Tom