- This topic has 6 replies, 4 voices, and was last updated 13 years, 9 months ago by
.
-
Posts
-
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′)Did you deactivate/activate? Also: event_name is a column that *must* be present. Is there something that happened to your database?
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.
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?
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
- The forum ‘Bug fixed or feature request implemented’ is closed to new topics and replies.