Support

Home Forums Event Espresso Premium Big Error with Adding an Event

Big Error with Adding an Event

Posted: October 8, 2013 at 9:16 am


Tim

October 8, 2013 at 9:16 am

When I try to create an event it doesn’t save and I get this.

It’s way over my head to understand.
Suggestions?

WordPress database error: [Table ‘medich_help.wp_events_detail’ doesn’t exist]
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-5254211b99f19′,’Texas Holdem’,’November 8 2013\r\nRoyal Canadian Legion Bramalea\r\n1133 Queen Street East, Brampton\r\n$80\r\n\r\nTickets Include\r\nDinner (porchetta/brisket)\r\nTournament Buy-in (large prize pool)\r\nCash bar\r\nCoffee and Sweets\r\nRaffles\r\n\r\nTimes:\r\nDoors Open – 6pm\r\nDinner – 7pm\r\nPoker – 8pm’,’Y’,’Y’,’poker1-5254211b99f19′,”,”,”,”,”,”,”,”,”,”,”,”,”,’2013-10-08′,’2013-11-06′,’2013-11-07′,’2013-11-07′,’N’,’N’,’Y’,’A’,”,’N’,’N’,”,”,”,’Y’,”,’a:1:{i:1;s:1:\”1\”;}’,’00:01′,’23:59′,999999,5,0,0,1,’a:9:{s:8:\”venue_id\”;s:1:\”0\”;s:28:\”additional_attendee_reg_info\”;s:1:\”1\”;s:28:\”add_attendee_question_groups\”;a:1:{i:1;s:1:\”1\”;}s:14:\”date_submitted\”;s:19:\”2013-10-08 15:13:31\”;s:22:\”default_payment_status\”;s:0:\”\”;s:13:\”event_hashtag\”;s:0:\”\”;s:12:\”event_format\”;s:0:\”\”;s:18:\”event_livestreamed\”;s:0:\”\”;s:0:\”\”;s:0:\”\”;}’,’0′,”,’2013-10-08 15:13:31′,0)

WordPress database error: [Table ‘medich_help.wp_events_detail’ doesn’t exist]
UPDATE wp_events_detail SET category_id = ‘1’ WHERE id=’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,’80’,’0.00′,’flat_rate’,’General Admission’,’80’,’Members Admission’)

WordPress database error: [Table ‘medich_help.wp_events_detail’ doesn’t exist]
SELECT e.id event_id, e.event_name, e.event_identifier, e.registration_start, e.registration_startT, e.registration_end, e.registration_endT, e.start_date, e.end_date, e.is_active, e.recurrence_id, e.wp_user, e.event_status, e.reg_limit, v.name AS venue_title, v.address AS venue_address, v.address2 AS venue_address2, v.city AS venue_city, v.state AS venue_state, v.zip AS venue_zip, v.country AS venue_country FROM wp_events_detail e LEFT JOIN wp_events_venue_rel vr ON vr.event_id = e.id LEFT JOIN wp_events_venue v ON v.id = vr.venue_id WHERE e.is_active = “Y” AND ( e.event_status = “A” OR e.event_status = “O” ) AND ( e.end_date >= “2013-10-08” OR e.event_status = “O” ) GROUP BY e.id ORDER BY e.start_date ASC, e.event_name ASC LIMIT 50 OFFSET 0


Tim

October 8, 2013 at 9:37 am

I tried a reinstall of the plugin and recieved the same error.
Old events are gone. Can’t create new events.
=(


Sidney Harrell

October 8, 2013 at 11:41 am

Do you have phpMyAdmin access to look at the database? It’s probably available in your hosting provider’s cpanel menu. Or you may be able to use the WP plugin “Adminer” to look at the database through the WP admin (under Tools). It sounds like your WP table prefix has been changed, or something similar. Have you tried deactivating all non-EE related plugins?


Tim

October 9, 2013 at 9:28 am

I had a look at my phpmyadmin. I don’t have a table ‘medich_help.wp_events_detail’ which is particularly odd. I don’t have any current events is there a way to totally delete all the EE tables and start anew.


Sidney Harrell

October 9, 2013 at 10:14 am

“medich_help” should be the name of the database in phpMyAdmin and “wp_events_detail” should be the name of the table within that database. Assuming that the WP table prefix is still “wp_”. If you’ve changed the prefix, then it may be named (prefix)events_details. All of the EE related tables start with (prefix)events, so if you go through and delete them all, then you should be able to start fresh. You’ll also need to delete some entries from the wp_options table. If you do a search: “SELECT *
FROM wp_options
WHERE option_name LIKE ‘%espresso%'” then you should see all the ones that need to be deleted to give a completely fresh install.


Tim

October 9, 2013 at 12:58 pm

Thanks Sid. I had to search all tables and drop all references to EE. Taking it out of OPTIONS wasn’t enough. Slowly getting reestablished. Very odd. I’ll keep you informed of progress.


Dean

October 10, 2013 at 1:08 am

Please do keep us informed Tim, we like to know the outcome of these things.


Tim

October 11, 2013 at 1:10 pm

You can close the ticket. After removing all references in phpmyadmin, and reinstalling things seems ticketyboo.
Randomness.

The support post ‘Big Error with Adding an 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