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

[Anonymous]

After the most recent upgrade, I tried to add a new event. When I clicked on save I got the following error message — twice:

WordPress database error: [Unknown column 'event_author' in 'field list']
INSERT INTO <code>345wp_eme_events</code> (<code>event_name</code>, <code>event_status</code>, <code>event_start_date</code>, <code>event_start_time</code>, <code>event_end_date</code>, <code>event_end_time</code>, <code>event_notes</code>, <code>event_rsvp</code>, <code>use_paypal</code>, <code>use_2co</code>, <code>use_webmoney</code>, <code>use_fdgg</code>, <code>use_mollie</code>, <code>use_sagepay</code>, <code>price</code>, <code>currency</code>, <code>rsvp_number_days</code>, <code>rsvp_number_hours</code>, <code>registration_requires_approval</code>, <code>registration_wp_users_only</code>, <code>event_seats</code>, <code>location_id</code>, <code>event_author</code>, <code>event_contactperson_id</code>, <code>event_category_ids</code>, <code>event_attributes</code>, <code>event_properties</code>, <code>event_page_title_format</code>, <code>event_single_event_format</code>, <code>event_contactperson_email_body</code>, <code>event_respondent_email_body</code>, <code>event_registration_pending_email_body</code>, <code>event_registration_updated_email_body</code>, <code>event_registration_cancelled_email_body</code>, <code>event_registration_paid_email_body</code>, <code>event_registration_denied_email_body</code>, <code>event_registration_form_format</code>, <code>event_cancel_form_format</code>, <code>event_registration_recorded_ok_html</code>, <code>event_slug</code>, <code>event_image_url</code>, <code>event_image_id</code>, <code>event_external_ref</code>, <code>event_url</code>, <code>recurrence_id</code>) VALUES ('Game Night in Newark', '5', '2019-01-12', '18:00:00', '2019-01-12', '21:00:00', 'Join other EBN members and friends for a fun night of games and food. Depending on the games people bring, we may revel in an exciting game of UNO, or be challenged by a game of Scrabble, Catch Phrase or Taboo. Those attending are asked to bring their favorite games and a snack to share. Non-alcoholic drinks, cups, plates, napkins, and eating utensils are provided. Feel free to bring your favorite alcoholic beverage for yourself or to share.', '0', '1', '0', '0', '0', '0', '0', '0', 'USD', '0', '0', '0', '0', '10', '11', '13', '15', '', 'a:0:{}', 'a:66:{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:1:\"2\";s:22:\"rsvp_start_number_days\";s:0:\"\";s:23:\"rsvp_start_number_hours\";s:0:\"\";s:17:\"rsvp_start_target\";s:5:\"start\";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\";s:0:\"\";s:13:\"rsvp_password\";s: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\";s:1:\"5\";s:14:\"attendance_end\";s:1:\"0\";s:16:\"wp_page_template\";s:14:\"page-blank.php\";s:11:\"use_captcha\";i:0;s:27:\"event_page_title_format_tpl\";s:1:\"3\";s:29:\"event_single_event_format_tpl\";s:1:\"3\";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\";s:37:\"event_contactperson_email_subject_tpl\";s:1:\"0\";s:34:\"event_respondent_email_subject_tpl\";s:1:\"0\";s:44:\"event_registration_pending_email_subject_tpl\";s:1:\"0\";s:44:\"event_registration_updated_email_subject_tpl\";s:1:\"0\";s:46:\"event_registration_cancelled_email_subject_tpl\";s:1:\"0\";s:43:\"event_registration_denied_email_subject_tpl\";s:1:\"0\";s:41:\"event_registration_paid_email_subject_tpl\";s:1:\"0\";s:52:\"contactperson_registration_pending_email_subject_tpl\";s:1:\"0\";s:49:\"contactperson_registration_pending_email_body_tpl\";s:1:\"0\";s:54:\"contactperson_registration_cancelled_email_subject_tpl\";s:1:\"0\";s:51:\"contactperson_registration_cancelled_email_body_tpl\";s:1:\"0\";s:48:\"contactperson_registration_ipn_email_subject_tpl\";s:1:\"0\";s:45:\"contactperson_registration_ipn_email_body_tpl\";s:1:\"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:\"\";s:45:\"contactperson_registration_pending_email_body\";s:0:\"\";s:47:\"contactperson_registration_cancelled_email_body\";s:0:\"\";s:41:\"contactperson_registration_ipn_email_body\";s:0:\"\";s:48:\"contactperson_registration_pending_email_subject\";s:0:\"\";s:50:\"contactperson_registration_cancelled_email_subject\";s:0:\"\";s:44:\"contactperson_registration_ipn_email_subject\";s:0:\"\";}', '', '', '', '', '', '', '', '', '', '', '', '', 'game-night-in-newark/', 'https://eastbaynetwork.org/wp-content/uploads/2018/10/gameNight.png', '718', '', '', '0')

How can I fix this? I have events that need to be added for a client.

[Franky]

Which version did you update from? This column is always present since version 1.x of the plugin (years ago, in the beginning it got renamed from another column though).
If that’s the only column missing, execute this in your db editor (phpmyadmin or so):
alter table wp_eme_events add event_author mediumint(9) DEFAULT 0;
But really, what version did you update from?

[Anonymous]

I originally installed version 2.0.58. Since then I have updated each time a new version was released. I also tried reinstalling and still got the error. I will make the suggested change to the database and try again. I have NO idea why this happened because none of the previous versions threw this error.

[Franky]

2.0.58? That contains the column by default at first install, and no actions are taken on that column later on. Make sure nothing is wrong with your database in general …

[Anonymous]

That little change to the database table worked. As I said, I knew it was there previously and I hadn’t done anything to alter that table. At least it’s fixed now! Thanks!

[Franky]

I did a little more digging: 2.0.59 (I already deleted the 2.0.58 tag) and newer have no DB changes made to them (only code), so while I assume you were already on something newer than 2.0.58 (by following the updates), this remains a mystery. Nothing in my code can explain a column just disappearing in mysql …
I’m glad it works again for you, but maybe you should check with the db-guys if they can see anything in their logs that might help pinpoint the origin of the problem.

[Author]

Posts