Database error.

[Anonymous]

Hi there,

I just downloaded the plug in and when I add an event I get:

WordPress database error: [Unknown column ‘event_name’ in ‘field list’]

INSERT INTO wp_dbem_events (event_name,event_status,event_start_date,event_end_date,event_start_time,event_end_time,event_rsvp,rsvp_number_days,registration_requires_approval,registration_wp_users_only,event_seats,event_contactperson_id,event_notes,event_page_title_format,event_single_event_format,event_contactperson_email_body,event_respondent_email_body,event_category_ids,event_attributes,location_id,event_author,creation_date,modif_date,creation_date_gmt,modif_date_gmt) VALUES (‘test’,’1′,’2011-02-15′,’2011-02-15′,’15:13:00′,’18:13:00′,’0′,’0′,’0′,’0′,’0′,’-1′,”,”,”,”,”,”,’a:0:{}’,’5′,’1′,’2011-02-15 16:13:22′,’2011-02-15 16:13:22′,’2011-02-16 00:13:22′,’2011-02-16 00:13:22′)

WordPress database error: [Unknown column ‘event_name’ in ‘field list’]

INSERT INTO wp_dbem_events (event_name,event_status,event_start_date,event_end_date,event_start_time,event_end_time,event_rsvp,rsvp_number_days,registration_requires_approval,registration_wp_users_only,event_seats,event_contactperson_id,event_notes,event_page_title_format,event_single_event_format,event_contactperson_email_body,event_respondent_email_body,event_category_ids,event_attributes,location_id,event_author,creation_date,modif_date,creation_date_gmt,modif_date_gmt) VALUES (‘test’,’1′,’2011-02-15′,’2011-02-15′,’15:13:00′,’18:13:00′,’0′,’0′,’0′,’0′,’0′,’-1′,”,”,”,”,”,”,’a:0:{}’,’5′,’1′,’2011-02-15 16:13:22′,’2011-02-15 16:13:22′,’2011-02-16 00:13:22′,’2011-02-16 00:13:22′)

I tried re-installing, deactivate and activate, etc.. Any ideas? Thanks!

[Franky]

If you have installed “Events Manager” before this, this might happen. If this is the case:

go into the settings of EME and check the option “Delete all EME data when uninstalling?”.

Then deactivate and reactivate EME.

This setting will delete all old tables and settings concerning EME, so also those corrupted by Events Manager, so you’ll start with a empty events manager then.

[Franky]

no response, closing

[Author]

Posts