We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Upgrading to EE4, getting this error Unknown column 'MemberField_member_fields

News and General

gylfisteinn's avatar
gylfisteinn
39 posts
7 years ago
gylfisteinn's avatar gylfisteinn

Hi, I am upgrading to EE 4.0.9 from EE 3.5.15 and am getting this error. I have not gotten to run the installer yet, get this after login. Any ideas?

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->query(‘SELECT MemberFi…’)

1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute(‘SELECT MemberFi…’)

2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query(‘SELECT MemberFi…’)

3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query(‘SELECT MemberFi…’)

4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(48): CI_DB_active_record->get()

5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()

6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Select’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))

7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))

8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(62): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()

9 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(283): EllisLab\ExpressionEngine\Service\Model\Query\Builder->all()

10 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(65): EllisLab\ExpressionEngine\Service\Model\Query\Select->getExtraData(‘Member’, Array)

11 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()

12 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(227): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Select’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))

13 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(143): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))

14 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(54): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()

15 ee/legacy/libraries/Session.php(340): EllisLab\ExpressionEngine\Service\Model\Query\Builder->first()

16 ee/legacy/libraries/Auth.php(722): EE_Session->create_new_session(‘1’, true)

17 ee/legacy/controllers/cp/login.php(187): Auth_result->start_session(true)

18 [internal function]: Login->authenticate()

19 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)

20 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)

21 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))

22 index.php(148): require_once(‘…’)

22 index.php(148): require_once(‘…’)

       
gylfisteinn's avatar
gylfisteinn
39 posts
7 years ago
gylfisteinn's avatar gylfisteinn

Fixed, deleted the installer directory.

       
Derek Jones's avatar
Derek Jones
7,561 posts
7 years ago
Derek Jones's avatar Derek Jones

Did you successfully run the update? That error looks like you tried to log in with the v4 files without running the update, which is in the installer directory.

       
travisb's avatar
travisb
171 posts
7 years ago
travisb's avatar travisb

In case it helps anyone else: On a local install accidently had config pointing to another local db (older ee version), where of course that column wouldn’t be expected.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.