|
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!\',\'www.allthingsfun.net\',\'(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
|
|
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 '3.1.25.1.L';
just to force the db install to run again.
|
|
Chris Reynolds
|
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.
|
