Unknown column event_author
-
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 NULLWordPress database error: [Unknown column ‘event_author’ in ‘field list’]
INSERT INTOwp_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]
- The topic ‘Unknown column event_author’ is closed to new replies.