error create recurring event

Hi,
same error when trying to create a non-recurring event

when I installed the plugin, in a first activation attempt a fatal error occurred, then I tried again and it was activated.

thanks,
José Carlos.

Error en la base de datos de WordPress: [Unknown column ‘event_author’ in ‘field list’]
INSERT INTO ****_eme_events (event_name, event_status, event_start_date, event_start_time, event_end_date, event_end_time, event_notes, event_rsvp, use_paypal, use_2co, use_webmoney, use_fdgg, use_mollie, use_sagepay, price, currency, rsvp_number_days, rsvp_number_hours, registration_requires_approval, registration_wp_users_only, event_seats, location_id, event_author, event_contactperson_id, event_category_ids, event_attributes, event_properties, event_page_title_format, event_single_event_format, event_contactperson_email_body, event_respondent_email_body, event_registration_pending_email_body, event_registration_updated_email_body, event_registration_cancelled_email_body, event_registration_paid_email_body, event_registration_denied_email_body, event_registration_form_format, event_cancel_form_format, event_registration_recorded_ok_html, event_slug, event_image_url, event_image_id, event_external_ref, event_url, recurrence_id, modif_date, modif_date_gmt, creation_date, creation_date_gmt) VALUES (‘Secretaría – Puertas de Castilla’, ‘5’, ‘2017-12-12′, ’18:00:00’, ‘2017-12-12′, ’20:30:00’, ‘Atención a personas asociadas y nuevas altas.’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘EUR’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘4’, ‘1’, ‘1’, ‘1’, ‘a:0:{}’, ‘a:27:{s:12:\”auto_approve\”;i:0;s:14:\”ignore_pending\”;i:0;s:7:\”all_day\”;i:0;s:15:\”take_attendance\”;i:0;s:11:\”min_allowed\”;s:1:\”1\”;s:11:\”max_allowed\”;s:2:\”10\”;s:15:\”rsvp_end_target\”;s:5:\”start\”;s:13:\”rsvp_discount\”;s:0:\”\”;s:17:\”waitinglist_seats\”;i:0;s:18:\”rsvp_discountgroup\”;s:0:\”\”;s:12:\”use_worldpay\”;i:0;s:10:\”use_stripe\”;i:0;s:13:\”use_braintree\”;i:0;s:11:\”use_offline\”;i:0;s:16:\”cancel_rsvp_days\”;s:1:\”0\”;s:27:\”event_page_title_format_tpl\”;s:1:\”0\”;s:29:\”event_single_event_format_tpl\”;s:1:\”0\”;s:34:\”event_contactperson_email_body_tpl\”;s:1:\”0\”;s:39:\”event_registration_recorded_ok_html_tpl\”;s:1:\”0\”;s:31:\”event_respondent_email_body_tpl\”;s:1:\”0\”;s:41:\”event_registration_pending_email_body_tpl\”;s:1:\”0\”;s:41:\”event_registration_updated_email_body_tpl\”;s:1:\”0\”;s:43:\”event_registration_cancelled_email_body_tpl\”;s:1:\”0\”;s:40:\”event_registration_denied_email_body_tpl\”;s:1:\”0\”;s:34:\”event_registration_form_format_tpl\”;s:1:\”0\”;s:28:\”event_cancel_form_format_tpl\”;s:1:\”0\”;s:38:\”event_registration_paid_email_body_tpl\”;s:1:\”0\”;}’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘secretaria-puertas-de-castilla/’, ”, ‘0’, ”, ”, ‘0’, ‘2017-12-08 01:37:10’, ‘2017-12-08 00:37:10’, ‘2017-12-08 01:37:10’, ‘2017-12-08 00:37:10’)

• This reply was modified 7 years, 3 months ago by bdtmurcia.

This means not all database columns were created when installing the plugin, probably because your configured db user doesn’t have the right to do so.
So completely remove the plugin (remove the files and db too, when being asked for it). And then reinstall and reactivate, if the same error occurs: talk to your DB admin.

hi,

there is no other way,
I worked in the configuration

regards,
José Carlos

Sorry, but if the db was not correctly created, this is the only way.

Or if you’re confident with mysql : deactivate, remove all tables called something like wp_eme_* and remove the entry eme_version from the wordpress options table.

hi,
I have reinstalled and activated it, and I can add events, I will check it, there are many configurations, it is a very complete plugin, great work.
thanks.
José Carlos.