Inserting New Event – Error

  • Resolved 3dperuna

    (@3dperuna)


    10 years, 3 months ago

    User EME v. 1.4.6

    WordPress database error: [Unknown column 'event_cancel_form_format' in 'field list']
INSERT INTO <code>wp_HF_eme_events</code> (<code>event_name</code>,<code>event_status</code>,<code>event_start_date</code>,<code>event_end_date</code>,<code>event_start_time</code>,<code>event_end_time</code>,<code>event_rsvp</code>,<code>rsvp_number_days</code>,<code>rsvp_number_hours</code>,<code>registration_requires_approval</code>,<code>registration_wp_users_only</code>,<code>event_seats</code>,<code>use_paypal</code>,<code>use_2co</code>,<code>use_webmoney</code>,<code>use_google</code>,<code>price</code>,<code>currency</code>,<code>event_contactperson_id</code>,<code>event_notes</code>,<code>event_page_title_format</code>,<code>event_single_event_format</code>,<code>event_contactperson_email_body</code>,<code>event_registration_recorded_ok_html</code>,<code>event_respondent_email_body</code>,<code>event_registration_pending_email_body</code>,<code>event_registration_updated_email_body</code>,<code>event_registration_form_format</code>,<code>event_cancel_form_format</code>,<code>event_url</code>,<code>event_image_url</code>,<code>event_image_id</code>,<code>event_slug</code>,<code>event_category_ids</code>,<code>event_attributes</code>,<code>event_properties</code>,<code>location_id</code>,<code>event_author</code>,<code>creation_date</code>,<code>modif_date</code>,<code>creation_date_gmt</code>,<code>modif_date_gmt</code>) VALUES ('Test Event - Please Delete','5','2014-08-13','2014-08-20','18:00:00','18:00:00','0','0','0','0','0','0','0','0','0','0','0','EUR','-1','Test - DELETE','','','','','','','','','','','','0','test-event-please-delete/','','a:0:{}','a:14:{s:12:\"auto_approve\";i:0;s:14:\"ignore_pending\";i:0;s:7:\"all_day\";i:0;s:11:\"min_allowed\";s:1:\"1\";s:11:\"max_allowed\";s:2:\"10\";s:27:\"event_page_title_format_tpl\";s:1:\"0\";s:29:\"event_single_event_format_tpl\";s:1:\"0\";s:34:\"event_contactperson_email_body_tpl\";s:1:\"0\";s:39:\"event_registration_recorded_ok_html_tpl\";s:1:\"0\";s:31:\"event_respondent_email_body_tpl\";s:1:\"0\";s:41:\"event_registration_pending_email_body_tpl\";s:1:\"0\";s:41:\"event_registration_updated_email_body_tpl\";s:1:\"0\";s:34:\"event_registration_form_format_tpl\";s:1:\"0\";s:28:\"event_cancel_form_format_tpl\";s:1:\"0\";}','0','2','2014-08-11 16:45:59','2014-08-11 16:45:59','2014-08-11 21:45:59','2014-08-11 21:45:59')

WordPress database error: [Unknown column 'event_cancel_form_format' in 'field list']
INSERT INTO <code>wp_HF_eme_events</code> (<code>event_name</code>,<code>event_status</code>,<code>event_start_date</code>,<code>event_end_date</code>,<code>event_start_time</code>,<code>event_end_time</code>,<code>event_rsvp</code>,<code>rsvp_number_days</code>,<code>rsvp_number_hours</code>,<code>registration_requires_approval</code>,<code>registration_wp_users_only</code>,<code>event_seats</code>,<code>use_paypal</code>,<code>use_2co</code>,<code>use_webmoney</code>,<code>use_google</code>,<code>price</code>,<code>currency</code>,<code>event_contactperson_id</code>,<code>event_notes</code>,<code>event_page_title_format</code>,<code>event_single_event_format</code>,<code>event_contactperson_email_body</code>,<code>event_registration_recorded_ok_html</code>,<code>event_respondent_email_body</code>,<code>event_registration_pending_email_body</code>,<code>event_registration_updated_email_body</code>,<code>event_registration_form_format</code>,<code>event_cancel_form_format</code>,<code>event_url</code>,<code>event_image_url</code>,<code>event_image_id</code>,<code>event_slug</code>,<code>event_category_ids</code>,<code>event_attributes</code>,<code>event_properties</code>,<code>location_id</code>,<code>event_author</code>,<code>creation_date</code>,<code>modif_date</code>,<code>creation_date_gmt</code>,<code>modif_date_gmt</code>) VALUES ('Test Event - Please Delete','5','2014-08-13','2014-08-20','18:00:00','18:00:00','0','0','0','0','0','0','0','0','0','0','0','EUR','-1','Test - DELETE','','','','','','','','','','','','0','test-event-please-delete/','','a:0:{}','a:14:{s:12:\"auto_approve\";i:0;s:14:\"ignore_pending\";i:0;s:7:\"all_day\";i:0;s:11:\"min_allowed\";s:1:\"1\";s:11:\"max_allowed\";s:2:\"10\";s:27:\"event_page_title_format_tpl\";s:1:\"0\";s:29:\"event_single_event_format_tpl\";s:1:\"0\";s:34:\"event_contactperson_email_body_tpl\";s:1:\"0\";s:39:\"event_registration_recorded_ok_html_tpl\";s:1:\"0\";s:31:\"event_respondent_email_body_tpl\";s:1:\"0\";s:41:\"event_registration_pending_email_body_tpl\";s:1:\"0\";s:41:\"event_registration_updated_email_body_tpl\";s:1:\"0\";s:34:\"event_registration_form_format_tpl\";s:1:\"0\";s:28:\"event_cancel_form_format_tpl\";s:1:\"0\";}','0','2','2014-08-11 16:45:59','2014-08-11 16:45:59','2014-08-11 21:45:59','2014-08-11 21:45:59')

    https://www.ads-software.com/plugins/events-made-easy/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Franky

    (@liedekef)

    This column is in EME since 1.4.0. If it is not present in your current setup, that means that your wordpress database user probably has no right to add columns to a table in the database. Or something went wrong during your update or you’re using an old database …

    Thread Starter 3dperuna

    (@3dperuna)

    Thanks… that gives me the direction I need. This particular site is hosted on a Windows system that I have no control over. I’ll get with their sys admin.

    Thread Starter 3dperuna

    (@3dperuna)

    Franky,

    The site administrator claims all permissions are correct, but deactivating and reactivating isn’t working. I’m afraid we may need to re-install, but they’ve created a large number of events they don’t want lost.

    Any options? Again, I don’t have access to the DB, or I’d manually add the column.

    Plugin Author Franky

    (@liedekef)

    Deactivating/reactivating won’t change it, since there’s an eme option (in the wp options table) that indicates the current eme version (and if it is the same as the one you’re having, nothing happens).
    Easiest is to figure out from which EME version you upgraded, and change in the table wp_options the variable to that version. Then deactivate/reactivate and the upgrade will run again.
    To check the current version in the db:
    select * from wp_options where option_name=’eme_version’;

    Thread Starter 3dperuna

    (@3dperuna)

    Ok… This will be a challenge (not an EME problem, but a hosting issue). This particular client uses a web host that runs on IIS and doesn’t have PLESK or anything like it. I actually can’t touch the DB (and have to rely on them for DB backups).

    I’ll try to get the host guys to bump the version back a number.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Inserting New Event – Error’ is closed to new replies.

Tags