Upgrade from latest 5x to 6x error
How Do I?
3 years ago
We’ve tried to upgrade and it appears to have worked, without error, but for one site getting some nasty SQL errors.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm.group_id' in 'field list':
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, wd.*, exp_channel_data_field_211.field_id_211, exp_channel_data_field_211.field_ft_211, exp_channel_data_field_145.field_id_145, exp_channel_data_field_145.field_ft_145, exp_channel_data_field_148.field_id_148, exp_channel_data_field_148.field_ft_148, exp_channel_data_field_151.field_id_151, exp_channel_data_field_151.field_ft_151, exp_channel_data_field_154.field_id_154, exp_channel_data_field_154.field_ft_154, exp_channel_data_field_157.field_id_157, exp_channel_data_field_157.field_ft_157, exp_channel_data_field_160.field_id_160, exp_channel_data_field_160.field_ft_160, exp_channel_data_field_163.field_id_163, exp_channel_data_field_163.field_ft_163, exp_channel_data_field_166.field_id_166, exp_channel_data_field_166.field_ft_166, exp_channel_data_field_169.field_id_169, exp_channel_data_field_169.field_ft_169, exp_channel_data_field_172.field_id_172, exp_channel_data_field_172.field_ft_172, exp_channel_data_field_205.field_id_205, exp_channel_data_field_205.field_ft_205, exp_channel_data_field_94.field_id_94, exp_channel_data_field_94.field_ft_94, exp_channel_data_field_118.field_id_118, exp_channel_data_field_118.field_ft_118 FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_211 ON t.entry_id = exp_channel_data_field_211.entry_id LEFT JOIN exp_channel_data_field_145 ON t.entry_id = exp_channel_data_field_145.entry_id LEFT JOIN exp_channel_data_field_148 ON t.entry_id = exp_channel_data_field_148.entry_id LEFT JOIN exp_channel_data_field_151 ON t.entry_id = exp_channel_data_field_151.entry_id LEFT JOIN exp_channel_data_field_154 ON t.entry_id = exp_channel_data_field_154.entry_id LEFT JOIN exp_channel_data_field_157 ON t.entry_id = exp_channel_data_field_157.entry_id LEFT JOIN exp_channel_data_field_160 ON t.entry_id = exp_channel_data_field_160.entry_id LEFT JOIN exp_channel_data_field_163 ON t.entry_id = exp_channel_data_field_163.entry_id LEFT JOIN exp_channel_data_field_166 ON t.entry_id = exp_channel_data_field_166.entry_id LEFT JOIN exp_channel_data_field_169 ON t.entry_id = exp_channel_data_field_169.entry_id LEFT JOIN exp_channel_data_field_172 ON t.entry_id = exp_channel_data_field_172.entry_id LEFT JOIN exp_channel_data_field_205 ON t.entry_id = exp_channel_data_field_205.entry_id LEFT JOIN exp_channel_data_field_94 ON t.entry_id = exp_channel_data_field_94.entry_id LEFT JOIN exp_channel_data_field_118 ON t.entry_id = exp_channel_data_field_118.entry_id WHERE t.entry_id IN (556)ORDER BY FIELD(t.entry_id, 556)Is there a way to debug it as it is odd that it reports “Unknown column ‘m.group_id’ in ‘field list” when there were no errors and all data was fine in 5.4.2.
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query()
#1 ee/legacy/database/DB_driver.php(260): CI_DB_mysqli_driver->_execute()
#2 ee/legacy/database/DB_driver.php(175): CI_DB_driver->simple_query()
#3 ee/ExpressionEngine/Addons/channel/mod.channel.php(225): CI_DB_driver->query()
#4 ee/legacy/libraries/Template.php(1702): Channel->entries()
#5 ee/legacy/libraries/Template.php(1386): EE_Template->process_tags()
#6 ee/legacy/libraries/Template.php(560): EE_Template->tags()
#7 ee/legacy/libraries/Template.php(228): EE_Template->parse()
#8 ee/legacy/libraries/Template.php(1070): EE_Template->fetch_and_parse()
#9 ee/legacy/libraries/Template.php(496): EE_Template->process_sub_templates()
#10 ee/legacy/libraries/Template.php(228): EE_Template->parse()
#11 ee/legacy/libraries/Template.php(163): EE_Template->fetch_and_parse()
#12 ee/legacy/libraries/Core.php(647): EE_Template->run_template_engine()
#13 ee/legacy/controllers/ee.php(53): EE_Core->generate_page()
#14 [internal function]: EE->index()
#15 ee/ExpressionEngine/Core/Core.php(251): call_user_func_array()
#16 ee/ExpressionEngine/Core/Core.php(111): ExpressionEngine\Core\Core->runController()
#17 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run()
#18 domain.com/index.php(174): require_once('...')
#18 domain.com/index.php(174): require_once('...')
3 years ago
Just a random test but it appears a cache clear has fixed it.
Not sure If it does already but a cache clear on upgrade might be worthwhile as it would have no doubt not even shown this error. 😊
3 years ago
Glad you got this fixed. I think there might be issues with EE automatically clearing the user cache, but we can look in to if that’s something that would help users out.