• Resolved Gregor

    (@gregorlandwehr)


    I installed the event manager at a new in a new wordpress installation.

    Whenever I want to create and publish an event, I get the error “Your event details are incorrect and cannot be published. Please correct these errors first:

    Something went wrong while saving event to index table. Please inform the administrator about it.”

    – But the table is existing, but empty.
    – I tried it with WP Safe Mode, same problem
    – I installed the plugin again, the problem still exists
    – I’m using the newest Versions of WP and EM

    Any ideas what to do?

    The page I need help with: [log in to see the link]

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    Hi,

    You can try to check your wp_em_events table and make sure the event_id column is set to auto_increment and primary key.

    Thread Starter Gregor

    (@gregorlandwehr)

    Hey,
    I checked it. Both is set.

    Hi there,

    we’ve got the same problem. Would love to get a fix for this.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    I see, you can also try to check your PHP logs to see if there’s an additional error or details SQL error that might cause this issue.

    Thread Starter Gregor

    (@gregorlandwehr)

    Good point, I will try it.

    Thread Starter Gregor

    (@gregorlandwehr)

    Thats the error I get: [Unknown column ‘event_parent’ in ‘field list’]
    INSERT INTO wj_em_events (post_id, event_parent, event_slug, event_owner, event_name, event_timezone, event_start_time, event_end_time, event_start, event_end, event_all_day, event_start_date, event_end_date, post_content, event_rsvp, event_rsvp_date, event_rsvp_time, event_rsvp_spaces, event_spaces, location_id, event_location_type, recurrence_id, event_status, event_private, blog_id, group_id, event_language, event_translation, recurrence, recurrence_interval, recurrence_freq, recurrence_days, recurrence_byday, recurrence_byweekno, recurrence_rsvp_days, event_date_created) VALUES (136881, NULL, ‘event-2′, ’19’, ‘Event 2’, ‘Europe/Berlin’, ’00:00:00′, ’23:59:59′, ‘2021-05-17 22:00:00’, ‘2021-05-19 21:59:59’, ‘1’, ‘2021-05-18’, ‘2021-05-19’, ‘<!– wp:wjd/hero –>\r\n<div class=\”wp-block-wjd-hero\”>\r\n<div class=\”gallery-grid\” data-total-slides=\”0\”>Golft</div>\r\n</div>\r\n<!– /wp:wjd/hero –>\r\n\r\n<!– wp:wjd/group –>\r\n<div class=\”wp-block-wjd-group\”> </div>\r\n<!– /wp:wjd/group –>’, ‘0’, NULL, NULL, NULL, NULL, ‘1’, NULL, NULL, ‘1’, ‘0’, 0, ‘0’, ‘de_DE’, ‘0’, ‘0’, NULL, NULL, NULL, NULL, NULL, NULL, ‘2021-05-12 01:13:37’)`

    Plugin Support angelo_nwl

    (@angelo_nwl)

    You can add this field to your events table

    event_parent | bigint(20)

    Thread Starter Gregor

    (@gregorlandwehr)

    I added the field, now I get this error:

    : [Unknown column 'event_location_type' in 'field list']
    INSERT INTO <code>wj_em_events</code> (<code>post_id</code>, <code>event_parent</code>, <code>event_slug</code>, <code>event_owner</code>, <code>event_name</code>, <code>event_timezone</code>, <code>event_start_time</code>, <code>event_end_time</code>, <code>event_start</code>, <code>event_end</code>, <code>event_all_day</code>, <code>event_start_date</code>, <code>event_end_date</code>, <code>post_content</code>, <code>event_rsvp</code>, <code>event_rsvp_date</code>, <code>event_rsvp_time</code>, <code>event_rsvp_spaces</code>, <code>event_spaces</code>, <code>location_id</code>, <code>event_location_type</code>, <code>recurrence_id</code>, <code>event_status</code>, <code>event_private</code>, <code>blog_id</code>, <code>group_id</code>, <code>event_language</code>, <code>event_translation</code>, <code>recurrence</code>, <code>recurrence_interval</code>, <code>recurrence_freq</code>, <code>recurrence_days</code>, <code>recurrence_byday</code>, <code>recurrence_byweekno</code>, <code>recurrence_rsvp_days</code>, <code>event_date_created</code>) VALUES (136880, NULL, 'event-1', '19', 'Event 1', 'Europe/Berlin', '00:00:00', '23:59:59', '2021-05-18 22:00:00', '2021-05-20 21:59:59', '1', '2021-05-19', '2021-05-20', '<!-- wp:wjd/hero -->\r\n<div class=\"wp-block-wjd-hero\">\r\n<div class=\"gallery-grid\" data-total-slides=\"0\">Folgt noch</div>\r\n</div>\r\n<!-- /wp:wjd/hero -->\r\n\r\n<!-- wp:wjd/group -->\r\n<div class=\"wp-block-wjd-group\"> </div>\r\n<!-- /wp:wjd/group -->', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, '1', '0', 0, '0', 'de_DE', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, '2021-05-12 12:55:37')
    Plugin Support angelo_nwl

    (@angelo_nwl)

    That’s weird, you can refer to the file events-manager/em-install.php function em_create_events_table() to verify and confirm your events table.

    Thread Starter Gregor

    (@gregorlandwehr)

    It is…

    What exactly do you mean here? how do I have to proceed for this?

    Plugin Support angelo_nwl

    (@angelo_nwl)

    you can see on this function em_create_events_table the database table fields for em_events table.

    Thread Starter Gregor

    (@gregorlandwehr)

    Ah, now I got it. It was true that the table was not created correctly. i have added the missing columns. and now i can create events without errors. Great! Thanks a lot for the help!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Your event details are incorrect and cannot be published. Please correct these e’ is closed to new replies.