• Resolved patbell101

    (@patbell101)


    I don’t seem to be able to create an event at all. My site is public but I have a “hidden” page chriskernmusic.com/submit-new-event/ that by use of the guest login redirect, forces login in order to add an event. I get the [Unknown column ‘event_author’ in ‘field list’] and looking at the database the eme_events table indeed does not have this field. Have I missed a configuration somewhere?

    This from my database
    event_id mediumint(9) Auto Increment
    event_status mediumint(9) NULL [1]
    event_name text NULL
    event_slug text NULL
    event_url text NULL
    event_start_time time
    event_end_time time
    event_start_date date
    event_end_date date NULL
    creation_date datetime NULL [CURRENT_TIMESTAMP]
    modif_date datetime NULL [CURRENT_TIMESTAMP]
    event_notes longtext NULL
    event_rsvp tinyint(1) NULL [0]
    use_paypal tinyint(1) NULL [0]
    use_2co tinyint(1) NULL [0]
    use_webmoney tinyint(1) NULL [0]
    use_fdgg tinyint(1) NULL [0]
    use_mollie tinyint(1) NULL [0]
    use_sagepay tinyint(1) NULL [0]
    price text NULL
    currency text NULL
    rsvp_number_days tinyint(4) NULL [0]
    rsvp_number_hours tinyint(4) NULL [0]
    event_seats text NULL
    event_contactperson_id mediumint(9) NULL [0]
    location_id mediumint(9) NULL [0]
    recurrence_id mediumint(9) NULL [0]
    event_category_ids text NULL
    event_attributes text NULL
    event_properties text NULL
    event_page_title_format text NULL
    event_single_event_format text NULL
    event_contactperson_email_body text NULL
    event_respondent_email_body text NULL
    event_registration_recorded_ok_html text NULL
    event_registration_pending_email_body text NULL
    event_registration_updated_email_body text NULL
    event_registration_cancelled_email_body text NULL
    event_registration_paid_email_body text NULL
    event_registration_denied_email_body text NULL
    event_registration_form_format text NULL
    event_cancel_form_format text NULL
    registration_requires_approval tinyint(1) NULL [0]
    registration_wp_users_only tinyint(1) NULL [0]
    event_image_url text NULL
    event_image_id mediumint(9) [0]
    event_external_ref text NULL

    WordPress database error: [Unknown column ‘event_author’ in ‘field list’]
    INSERT INTO wp_592a1d0aed_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) VALUES (‘Farmers Market at Lac St Estephe’, ‘1’, ‘2018-08-20′, ’20:00:00’, ‘2018-08-20′, ’23:59:00’, ‘\r\n\r\nCome and join us at La grande etang at St Estephe. For an evening to please all musical tastes’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘EUR’, ‘0’, ‘0’, ‘0’, ‘0’, ’10’, ‘4’, ‘1’, ‘-1’, ‘1’, ‘a:0:{}’, ‘a:48:{s:12:\”auto_approve\”;i:0;s:14:\”ignore_pending\”;i:0;s:15:\”email_only_once\”;i:0;s:16:\”person_only_once\”;i:0;s:7:\”all_day\”;i:0;s:15:\”take_attendance\”;i:0;s:9:\”rsvp_link\”;s: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:21:\”rsvp_addpersontogroup\”;i:0;s:12:\”use_worldpay\”;i:0;s:10:\”use_stripe\”;i:0;s:13:\”use_braintree\”;i:0;s:11:\”use_paymill\”;i:0;s:11:\”use_offline\”;i:0;s:16:\”cancel_rsvp_days\”;s:1:\”0\”;s:16:\”attendance_begin\”;i:5;s:14:\”attendance_end\”;i:0;s:27:\”event_page_title_format_tpl\”;i:0;s:29:\”event_single_event_format_tpl\”;i:0;s:34:\”event_contactperson_email_body_tpl\”;i:0;s:39:\”event_registration_recorded_ok_html_tpl\”;i:0;s:31:\”event_respondent_email_body_tpl\”;i:0;s:41:\”event_registration_pending_email_body_tpl\”;i:0;s:41:\”event_registration_updated_email_body_tpl\”;i:0;s:43:\”event_registration_cancelled_email_body_tpl\”;i:0;s:40:\”event_registration_denied_email_body_tpl\”;i:0;s:34:\”event_registration_form_format_tpl\”;i:0;s:28:\”event_cancel_form_format_tpl\”;i:0;s:38:\”event_registration_paid_email_body_tpl\”;i:0;s:37:\”event_contactperson_email_subject_tpl\”;i:0;s:34:\”event_respondent_email_subject_tpl\”;i:0;s:44:\”event_registration_pending_email_subject_tpl\”;i:0;s:44:\”event_registration_updated_email_subject_tpl\”;i:0;s:46:\”event_registration_cancelled_email_subject_tpl\”;i:0;s:43:\”event_registration_denied_email_subject_tpl\”;i:0;s:41:\”event_registration_paid_email_subject_tpl\”;i:0;s:33:\”event_contactperson_email_subject\”;s:0:\”\”;s:30:\”event_respondent_email_subject\”;s:0:\”\”;s:40:\”event_registration_pending_email_subject\”;s:0:\”\”;s:40:\”event_registration_updated_email_subject\”;s:0:\”\”;s:42:\”event_registration_cancelled_email_subject\”;s:0:\”\”;s:37:\”event_registration_paid_email_subject\”;s:0:\”\”;s:39:\”event_registration_denied_email_subject\”;s:0:\”\”;}’, ”, ”, ‘chriskernù[email protected]’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘farmers-market-at-lac-st-estephe/’, ”, ‘0’, ”, ”, ‘0’)

    The page I need help with: [log in to see the link]

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

    (@liedekef)

    It seems you’re missing that column. If that’s the case, something is wrong for some time with that installation, since that column gets created upon installation of the plugin and also if missing on every update of the plugin too.
    So either something wrong with that setup, old, or the WP user configured to access the DB has no right to create columns.
    Easiest is to “downgrade” the DB version of EME in the mysql db and go to the EME admin interface (that will update it again). To “downgrade” the DB version of EME: go in the table wp_options, search for the key eme_version and downgrade the value with 1.
    If the column is still missing after that, check your mysql user rights.

    Thread Starter patbell101

    (@patbell101)

    Well I did all that but in the end uninstalling, deleting and reinstalling worked.

    Plugin Author Franky

    (@liedekef)

    Glad it worked, but if it worked by reinstalling, it means something was wrong with the initial install … was that a new setup before or an older being upgraded?

    Thread Starter patbell101

    (@patbell101)

    A brand new setup, scarcely worked on. I got the plugin straight from the repository v2.0.37.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Unknown column event_author’ is closed to new replies.