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

[Anonymous]

Hi,

I have managed to register categories, locations and change my settings but when I try to add an event, I get a database input failure:

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

INSERT INTO tm_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 (‘Cimeira de Turismo 2011′,’1′,’2011-02-12′,’2011-02-12′,’09:30:00′,’17:30:00′,’0′,’0′,’0′,’0′,’0′,’1’,’A CTP – Confederação do Turismo Português, vai organizar no dia 12 de Janeiro a Cimeira do Turismo Português 2011 – “Portugal, o futuro como destino. Portugal, um destino como futuro”, propondo uma reflexão colectiva em torno do tema das “Cidades, Pólos de Crescimento Económico e do Turismo no Século XXI”.’,”,”,”,”,’1′,’a:0:{}’,’0′,’1′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′)

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

INSERT INTO tm_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 (‘Cimeira de Turismo 2011′,’1′,’2011-02-12′,’2011-02-12′,’09:30:00′,’17:30:00′,’0′,’0′,’0′,’0′,’0′,’1’,’A CTP – Confederação do Turismo Português, vai organizar no dia 12 de Janeiro a Cimeira do Turismo Português 2011 – “Portugal, o futuro como destino. Portugal, um destino como futuro”, propondo uma reflexão colectiva em torno do tema das “Cidades, Pólos de Crescimento Económico e do Turismo no Século XXI”.’,”,”,”,”,’1′,’a:0:{}’,’0′,’1′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′,’2011-02-08 20:10:43′)

[Franky]

Did you deactivate/activate? Also: event_name is a column that *must* be present. Is there something that happened to your database?

[Anonymous]

I’m having the same problem as nlopes. What do you mean by ‘must be present’? I deactivated and actuvated already with no result. I updated my wordpress prior to installing this plugin.

[Franky]

event_name is a column that is present since the first release, well even before I took over the project. So if this column is missing, something else is going on. Can you do a mysql command on the database:

“desc wp_dbem_events;”

(change “wp” by your desired prefix, if you have another).

Also: did you install the other plugin called “events manager”? From which version did you upgrade?

[Anonymous]

I am having this error on a filterform page

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]

SELECT DISTINCT location_id FROM wp_dbem_locations WHERE

[Franky]

@wassim: different error, open a new bug report for this, this will be deleted tomorrow

[Franky]

no response, closing

[Author]

Posts