Support

Home Forums Pre-Sales error – [Unknown column 'ticket_id' in 'field list']

error – [Unknown column 'ticket_id' in 'field list']

Posted: September 2, 2012 at 9:32 pm


bert devries

September 2, 2012 at 9:32 pm

I get this message when I’m modifying the confirmation e-mail when editing an event. Please advise.

Here is the info dump:

UPDATE wp_events_detail SET event_name = ‘E4M Fall Gathering w/ Carpenter\’s Cross!’, event_desc = ”, display_desc = ‘Y’, display_reg_form = ‘Y’, address = ‘2340 Dean Lake Ave NE’, address2 = ”, city = ‘Grand Rapids’, state = ‘MI’, zip = ‘49505’, country = ”, phone = ”, virtual_url = ”, virtual_phone = ”, venue_title = ‘New Community Church’, venue_url = ”, venue_phone = ”, venue_image = ”, registration_start = ‘2012-08-26’, registration_end = ‘2012-09-20’, start_date = ‘2012-09-20’, end_date = ‘2012-09-20’, allow_multiple = ‘Y’, send_mail = ‘Y’, is_active = ‘Y’, event_status = ”, conf_mail = ‘Thank you for registering for our fall Encouragment4Men (E4M) event! Once again we are blessed to have Carpenter\’s Cross play for us! Our speaker for the evening isrnIt would be great if you could make a donation at the door, but it\’s not required for you to attend. rnSee ya there!rnEvent Information:rnNew Community Churchrn2340 Dean Lake Ave NErnGrand Rapids, MI 49505rn7:00 PM – 8:30 PMrn’, use_coupon_code = ”, member_only = ‘N’, externalURL = ”, early_disc = ”, early_disc_date = ”, early_disc_percentage = ”, alt_email = ”, question_groups = ‘a:2:{i:1;s:1:”1″;i:2;s:1:”2″;}’, allow_overflow = ‘N’, overflow_event_id = 0, additional_limit = 0, reg_limit = 999, email_id = 0, registration_startT = ’00:01′, registration_endT = ’12:00′, event_meta = ‘a:5:{s:22:”default_payment_status”;N;s:8:”venue_id”;s:0:””;s:28:”additional_attendee_reg_info”;N;s:28:”add_attendee_question_groups”;s:0:””;s:14:”date_submitted”;s:13:”July 17, 2012″;}’, require_pre_approval = ‘0’, timezone_string = ”, ticket_id = 0 WHERE id = 1


Chris Reynolds

  • Support Staff

September 4, 2012 at 2:27 pm

Deactivate Event Espresso and reactivate it and try again. If that doesn’t work, you may need to add the ticket_id column in the database referenced in the original error message. For some reason, that column did not get created automatically when you updated/activated the plugin.

The support post ‘error – [Unknown column 'ticket_id' in 'field list']’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso