Support » Plugin: EME Sync Events » Error when syncing

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter jenniferdawn

    (@jenniferdawn)

    WordPress database error: [Unknown column ‘event_author’ in ‘field list’]
    is at the beginning of every block. I am presuming each is an event.

    Thread Starter jenniferdawn

    (@jenniferdawn)

    I tried deactivating and reactivating. Still getting the same message. I read another post about something similar. It was closed with a comment that it was a database issue or something else, but it gave no insight as to where to resolve it.

    Plugin Author Franky

    (@liedekef)

    If that column is unknown, your EME database is messed up. event_author is a column that has been in there from version 1.0.0, so you should check EME and your wordpress database. Don’t forget: this plugin needs EME.

    Thread Starter jenniferdawn

    (@jenniferdawn)

    I don’t know, but when I signed in today, EME had an update. After the update it functioned fine!

    Plugin Author Franky

    (@liedekef)

    Well, the column gets added if missing at every upgrade, so it might have helped you (but in fact you should have had problems in EME itself before too)

    Hi Franky,

    i used your EME Plugin for a single event last year and was very satisfied. Today i build a landing page for an other event and have the same problem as described above.
    The WP Version is 4.7.3 (new installation) and i installed EME 1.7.18.

    If i try to enter a new event i got the following error msg:

    WordPress-Datenbank-Fehler: [Unknown column ‘event_author’ in ‘field list’]
    INSERT INTO wp_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_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 (‘Test’, ‘5’, ‘2017-04-29′, ’09:10:00’, ‘2017-04-29′, ’10:10:00’, ”, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘EUR’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘-1’, ”, ‘a:0:{}’, ‘a:24:{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: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: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\”;}’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘test/’, ”, ‘0’, ”, ”, ‘0’, ‘2017-04-04 13:10:32’, ‘2017-04-04 11:10:32’, ‘2017-04-04 13:10:32’, ‘2017-04-04 11:10:32’)

    WordPress-Datenbank-Fehler: [Unknown column ‘event_author’ in ‘field list’]
    INSERT INTO wp_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_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 (‘Test’, ‘5’, ‘2017-04-29′, ’09:10:00’, ‘2017-04-29′, ’10:10:00’, ”, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘EUR’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘-1’, ”, ‘a:0:{}’, ‘a:24:{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: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: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\”;}’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘test/’, ”, ‘0’, ”, ”, ‘0’, ‘2017-04-04 13:10:32’, ‘2017-04-04 11:10:32’, ‘2017-04-04 13:10:32’, ‘2017-04-04 11:10:32’)

    Any idea exept messed database? I have no other plugin installed and a new WP Installation.

    Thank you for your help.

    Plugin Author Franky

    (@liedekef)

    My replies made above are still valid …

    Hi Franky,

    but i have only EME installed on my brand new WP (no FB sync). Installation worked fine but after entering a new event the error msg above appear.
    I reinstalled the plugin but i have the same msg.

    Best regards

    Konstantin

    Plugin Author Franky

    (@liedekef)

    Then (next to the fact that then this is not the correct forum) you have an issue with your database creation. Check that your database user has the right to create tables and such. As said: event_author is a column there from day 1, and on all installations I did, it gets created just fine.

    Dear Franky,

    sorry for posting in the wrong board. I just searched for similar issues.

    All other tables and columns are created without problems. But i´ll try to install it again.

    Tank you for your help.

    Konstantin

    Dear Franky,

    i deinstalled EME and reinstalled it through the WP plugin repository. Now it works fine.

    Sorry, for bugging you.

    Konstantin

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Error when syncing’ is closed to new replies.