Bug #23302 See Comments

3.5.12 > 4.0 error

Version: 4.0.0 Reporter: Paul_B

When upgrading to 4.0 on my server, I get the following error when logging in to admin.php for the first time (ie before any upgrade takes place). I can’t get any further than this. My local build worked fine.

<pre><code>Exception Caught SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘MemberField_member_fields.m_legacy_field_data’ in ‘field list’: SELECT MemberField_member_fields.m_field_id as MemberField__m_field_id, MemberField_member_fields.m_field_name as MemberField__m_field_name, MemberField_member_fields.m_field_label as MemberField__m_field_label, MemberField_member_fields.m_field_description as MemberField__m_field_description, MemberField_member_fields.m_field_type as MemberField__m_field_type, MemberField_member_fields.m_field_list_items as MemberField__m_field_list_items, MemberField_member_fields.m_field_ta_rows as MemberField__m_field_ta_rows, MemberField_member_fields.m_field_maxl as MemberField__m_field_maxl, MemberField_member_fields.m_field_width as MemberField__m_field_width, MemberField_member_fields.m_field_search as MemberField__m_field_search, MemberField_member_fields.m_field_required as MemberField__m_field_required, MemberField_member_fields.m_field_public as MemberField__m_field_public, MemberField_member_fields.m_field_reg as MemberField__m_field_reg, MemberField_member_fields.m_field_cp_reg as MemberField__m_field_cp_reg, MemberField_member_fields.m_field_fmt as MemberField__m_field_fmt, MemberField_member_fields.m_field_show_fmt as MemberField__m_field_show_fmt, MemberField_member_fields.m_field_order as MemberField__m_field_order, MemberField_member_fields.m_field_text_direction as MemberField__m_field_text_direction, MemberField_member_fields.m_field_settings as MemberField__m_field_settings, MemberField_member_fields.m_legacy_field_data as MemberField__m_legacy_field_data FROM (exp_member_fields as MemberField_member_fields) WHERE ( MemberField_member_fields.m_legacy_field_data = ‘n’ ) LIMIT 18446744073709551615

ee/legacy/database/drivers/mysqli/mysqli_connection.php:116 Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection-&gt;query('SELECT MemberFi...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver-&gt;_execute('SELECT MemberFi...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver-&gt;simple_query('SELECT MemberFi...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver-&gt;query('SELECT MemberFi...')
#4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(48): CI_DB_active_record-&gt;get()
#5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select-&gt;run()
#6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore-&gt;runQuery('Select', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore-&gt;selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(62): EllisLab\ExpressionEngine\Service\Model\Query\Builder-&gt;fetch()
#9 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(283): EllisLab\ExpressionEngine\Service\Model\Query\Builder-&gt;all()
#10 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(65): EllisLab\ExpressionEngine\Service\Model\Query\Select-&gt;getExtraData('Member', Array)
#11 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select-&gt;run()
#12 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore-&gt;runQuery('Select', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#13 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore-&gt;selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#14 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(54): EllisLab\ExpressionEngine\Service\Model\Query\Builder-&gt;fetch()
#15 ee/legacy/libraries/Session.php(340): EllisLab\ExpressionEngine\Service\Model\Query\Builder-&gt;first()
#16 ee/legacy/libraries/Auth.php(722): EE_Session-&gt;create_new_session('1', true)
#17 ee/legacy/controllers/cp/login.php(187): Auth_result-&gt;start_session(true)
#18 [internal function]: Login-&gt;authenticate()
#19 ee/EllisLab/ExpressionEngine/Core/Core.php(229): call_user_func_array(Array, Array)
#20 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core-&gt;runController(Array)
#21 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core-&gt;run(Object(EllisLab\ExpressionEngine\Core\Request))
#22 dev/admin.php(143): require_once('...')
#22 dev/admin.php(143): require_once('...') [/code]
  • Hi Paul, sorry for your trouble! That column should have been added in the update process. Could you try running the update again? Just change your the app_version in your config.php to 3.5.12 and put your installer folder back in place inside system/ee.

    Kevin Cupp
    07th December, 2017 at 10:42am
  • OK that totally worked and it was completely my fault - I had updated locally and then committed the changes and pushed them up, which was why the site borked. Sorry, I’ll know this next time!!

    Paul_B
    07th December, 2017 at 12:42pm

You must be signed in to comment on a bug report.

ExpressionEngine News

#eecms, #events, #releases