Events Made Easy › Forums › Generic › WordPress database error: [Unknown column 'use_paypal' in 'field list']

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • Wed 12 Oct 2011 at 10:41 #43558
    Anonymous
    Inactive

    HI

    Updated to 4.0.1 and is getting this when trying to add new events: WordPress database error: [Unknown column ‘use_paypal’ in ‘field list’]

    Anybody know how to fix this, tried deactivating/activating without any luck

    /hace

    Wed 12 Oct 2011 at 10:55 #48877
    Franky
    Keymaster

    maybe the user you have entered for mysql access in wordpress has no rights to add columns? Because the code is there in event-manager.php:

    maybe_add_column($table_name, 'use_paypal', "alter table $table_name add use_paypal bool DEFAULT 0;");

    Wed 12 Oct 2011 at 13:11 #48878
    Anonymous
    Inactive

    ok, ive have used this plugin for about 6 months without any problems, but i will check phpmyadmin.

    Wed 12 Oct 2011 at 14:22 #48879
    Franky
    Keymaster

    Well, for the moment it’s the only thing I can come up with … which version did you upgrade from?

    Mon 17 Oct 2011 at 18:14 #48880
    Anonymous
    Inactive

    the user has all rights, i dont now what version i upgraded from, but it was the first upgrade since i installed it.

    is it possible to create the column manually in phpmyadmin?

    Mon 17 Oct 2011 at 18:34 #48881
    Franky
    Keymaster

    Sure, you can add it to the wp_dbem_events table.

    Or, if you can live with the re-adding of current events (and EME settings): there’s an option to clear all EME related data and settings upon deactivation. So when reactivating then, you should have a fresh install.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • The forum ‘Generic’ is closed to new topics and replies.
Scroll to Top