Upgrade 3 > 5 sql error (Column not found: 1054 Unknown column ‘Channel_channels.status_group’)
Development and Programming
I’m getting the following error when trying to upgrade from 3.5.16 to the latest version 5.3:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘Channel_channels.status_group’ in ‘field list’:
I found another post with the same error but the solution did not work, I am copying the new version files over the existing files (index, admin, system/ee, themes/ee):
https://expressionengine.com/forums/topic/251064/ee3-to-ee4-upgrade-doesnt-work
The issue is happening when the upgrade process is moving from v4 > v4.1, I tried commenting out line 1046 (‘ee()->smartforge->drop_column(‘channels’, ‘status_group’);’) in ‘system/ee/installer/updates/ud_4_00_00.php’, but this didn’t help.
It looks like it’s happening in the 4.1 update- the resyncLayouts. If it were me, I’d be tempted to comment out that bit and see if it all completes and if there’s an issue with layouts.
Thank you.
I commented out ‘resyncLayouts’ in the ‘do_update’ function in ud_4_00_01, but now I get this (4.0.4 to 5.3.0):
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ChannelField_channel_fields.group_id’ in ‘field list’:
Hrm- I hate to say it, but this may be one to take to support. That or try rolling back and starting over. It looks like something is wrong with the data structure and just skipping probably isn’t going to help.
It’s failing in 4.0.5 on fixGridModifierParsing - but more importantly, I’m pretty sure the issue is with the model call.