Home Forums Community Forum Problem setting up a new event

Problem setting up a new event

Posted: August 9, 2012 at 8:40 am

Ed Evans

August 9, 2012 at 8:40 am

Hi! I managed to setup a test event and it worked before. So I was trying to setup a real event to test the plugin when I get this error. Any idea what I\’m doing wrong? (Still running the free version.) WordPress database error:

[Unknown column \'ticket_id\' in \'field list\'] INSERT INTO `wp_events_detail` (`event_code`,`event_name`,`event_desc`,`display_desc`,`display_reg_form`,`event_identifier`,`address`,`address2`,`city`,`state`,`zip`,`country`,`phone`,`virtual_url`,`virtual_phone`,`venue_title`,`venue_url`,`venue_phone`,`venue_image`,`registration_start`,`registration_end`,`start_date`,`end_date`,`allow_multiple`,`send_mail`,`is_active`,`event_status`,`conf_mail`,`use_coupon_code`,`member_only`,`externalURL`,`early_disc`,`early_disc_date`,`early_disc_percentage`,`alt_email`,`question_groups`,`registration_startT`,`registration_endT`,`reg_limit`,`additional_limit`,`recurrence_id`,`email_id`,`wp_user`,`event_meta`,`require_pre_approval`,`timezone_string`,`submitted`,`ticket_id`) VALUES (\'1-5023c916eb41d\',\'Mid-Atlantic Team Tournament Single Player Pre-Registration\',\'Reserve your space for the Mid-Atlantic Team Tournament to be held on Saturday, October 6 at All Things Fun!\',\'Y\',\'Y\',\'mid-atlantic-team-tournament-single-player-pre-registration-1-5023c916eb41d\',\'185 Route 73 N\',\'Suite C\',\'West Berlin\',\'NJ\',\'08091\',\'USA\',\'\',\'\',\'\',\'All Things Fun!\',\'\',\'(856)719-1414\',\'\',\'2012-08-09\',\'2012-10-05\',\'2012-10-06\',\'2012-10-06\',\'N\',\'N\',\'Y\',\'A\',\'\',\'N\',\'N\',\'\',\'\',\'\',\'\',\'\',\'a:1:{i:1;s:1:\"1\";}\',\'10:00\',\'10:00\',999999,5,0,0,1,\'a:5:{s:8:\"venue\_id\";i:0;s:28:\"additional\_attendee\_reg\_info\";s:1:\"2\";s:28:\"add\_attendee\_question\_groups\";s:14:\"a:1:{i:0;i:1;}\";s:14:\"date\_submitted\";s:19:\"2012-08-09 10:28:38\";s:22:\"default\_payment\_status\";s:0:\"\";}\',\'0\',\'\',\'2012-08-09 10:28:38\',0) There was an error in your submission. The event was not saved! Please try again. WordPress database error: [] INSERT INTO wp\_events\_prices (event\_id, event\_cost, surcharge, surcharge\_type, price\_type, member\_price, member\_price\_type) VALUES (\'0\', \'15.00\', \'0.00\', \'flat\_rate\', \'General Admission\', \'15.00\', \'Members Admission\') 

Thanks in advance! -Ed

Leah Johnson

August 14, 2012 at 8:53 am

I have also had this same problem…is there any resolution?

Sidney Harrell

August 14, 2012 at 4:56 pm

The database_install.php script has the ticket_id field in the events_details table definition, so it should be there in your db. If it’s not, you can either add it manually, or deactivate EE, change the version number in espresso.php, and reactivate. That should run the database install script again, and it should add the field to the db. The version number is around line 36 of espresso.php:

function espresso_version() {
do_action('action_hook_espresso_log', __FILE__, __FUNCTION__, '');
return '3.1.25.L';


change the return line to

return '';

just to force the db install to run again.

Graeme Forrest

August 29, 2012 at 5:57 am

getting the same error. If I do this will is erase all the events that I all ready have?

Chris Reynolds

  • Support Staff

August 29, 2012 at 11:08 am

getting the same error. If I do this will is erase all the events that I all ready have?

No. You are not making any changes to the events in the database. You are just triggering the install script to run again so that column in the database is created.

Graeme Forrest

August 30, 2012 at 6:05 am

Legend… thank so much…

The support post ‘Problem setting up a new event’ 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