WordPress.org

Ready to get started?Download WordPress

Forums

Events Made Easy
[resolved] Unknown column 'use_2co' in 'field list' (7 posts)

  1. jzahlaway
    Member
    Posted 1 year ago #

    When I try to edit any of my events, changes are not saved, and I am getting multiple instances of this type of error message:

    WordPress database error: [Unknown column 'use_2co' in 'field list']

    I'm using the latest iteration of the plugin (1.0.18) and I have deactivated and reactivated the plugin. I also have deleted and reinstalled the plugin, deactivated all other plugins, and activated the default theme. No joy. Please advise. Thanks.

    http://wordpress.org/extend/plugins/events-made-easy/

  2. Franky
    Member
    Plugin Author

    Posted 1 year ago #

    If you reinstalled and you still have this error, then there's a DB problem preventing the creation. The best thing to do here:
    - activate the plugin
    - select the option "Delete all EME data when upgrading or deactivating?"
    - deactivate the plugin
    - activate the plugin again

  3. jzahlaway
    Member
    Posted 1 year ago #

    This isn't a viable option. There's a voluminous amount of data that would be lost. Is there a way to export the existing data and then import after a "Delete all" is executed?

    Or can I just manually create the missing field in the MySQL DB?

  4. Franky
    Member
    Plugin Author

    Posted 1 year ago #

    Yes you can do it manually:

    alter table XXXX add use_2co bool DEFAULT 0;

    XXX is the name of the events table, by default: wp_eme_events

  5. jzahlaway
    Member
    Posted 1 year ago #

    Did that. Edited an event. Now I'm getting this:

    WordPress database error: [Unknown column 'use_webmoney' in 'field list']

    Also: The field(s) that I'm adding: Should they be specified as NULL or NOT NULL?

  6. jzahlaway
    Member
    Posted 1 year ago #

    Disregard; I rolled back to a backup version of the DB, deactivated and reactivated the plugin & it works now.

    Thanks for the assistance.

  7. Franky
    Member
    Plugin Author

    Posted 1 year ago #

    Well yes, after the use_2co field, other database fields have been added. But apparently after the rollback the database fields were successfully added, so maybe some hickup there? Your DB logs might provide a clue.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.