Unknown column 'use_2co' in 'field list'

  • Resolved jzahlaway

    (@jzahlaway)


    11 years, 1 month 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/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Franky

    (@liedekef)

    11 years, 1 month 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

    Thread Starter jzahlaway

    (@jzahlaway)

    11 years, 1 month 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?

    Plugin Author Franky

    (@liedekef)

    11 years, 1 month 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

    Thread Starter jzahlaway

    (@jzahlaway)

    11 years, 1 month 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?

    Thread Starter jzahlaway

    (@jzahlaway)

    11 years, 1 month ago

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

    Thanks for the assistance.

    Plugin Author Franky

    (@liedekef)

    11 years, 1 month 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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Unknown column 'use_2co' in 'field list'’ is closed to new replies.