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

[Anonymous]

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

[Franky]

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;");

[Anonymous]

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

[Franky]

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

[Anonymous]

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?

[Franky]

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