Error message: Something went wrong saving your event to the index table

Resolved Paal Joachim Romdahl
(@paaljoachim)

10 years, 6 months ago

Hi

I renewed the plugin license and updated to the newest pro lisence.

Clicking Publish causes this error:

“Your event details are incorrect and cannot be published, please correct these errors first:

Something went wrong saving your event to the index table. Please inform a site administrator about this.”

——-

I noticed through searching that the above error has happened for others but I am a bit unclear as to how to fix it.

I turned on wp_debug and noticed that there were some theme related errors and a wpdb error. Nothing about Events Manager.

I also reset Events Manager to see if that worked but no change.

How do I get it working?

http://wordpress.org/plugins/events-manager/

Viewing 5 replies - 1 through 5 (of 5 total)

caimin_nwl

(@caimin_nwl)

10 years, 6 months ago

Hi,

Can you save other, non Events Manager settings in WordPress?

Plugin Author

Marcus (aka @msykes)

(@netweblogic)

10 years, 5 months ago

One thing you can try is checking your PHP error logs (even though you enabled WP_DEBUG), chances are you’ll see a database error there.

If you have a pro license, please use the pro forums for faster support – http://eventsmanagerpro.com/support/ – you could also mention if this was working before you upgraded of if this was happening before.

If you are willing to uninstall the plugin and delete events too, try that in Events > Settings > Admin Tools

Thread Starter

Paal Joachim Romdahl

(@paaljoachim)

10 years, 5 months ago

I noticed this debug error:
Notice: wpdb::escape is deprecated since version 3.6! Use wpdb::prepare() or esc_sql() instead. in /home/baldron/public_html/wp-includes/functions.php on line 2905

I have asked the client if it is alright to uninstall with the result of having all events inside the Events Manager removed. Since they are using this in a multisite install. There are a lot of subsites that use Events Manager.

Next step is then use your pro support.

Btw
I opened an error log we have active for the site. Among various errors that I noticed I also saw this (it seems to repeat it self):

[30-Oct-2013 17:47:12 UTC] WordPress database error Unknown column 'wp_em_events.event_rsvp_spaces' in 'field list' for query
			SELECT wp_em_events.event_id,wp_em_events.post_id,wp_em_events.event_slug,wp_em_events.event_owner,wp_em_events.event_name,wp_em_events.event_start_time,wp_em_events.event_end_time,wp_em_events.event_all_day,wp_em_events.event_start_date,wp_em_events.event_end_date,wp_em_events.post_content,wp_em_events.event_rsvp,wp_em_events.event_rsvp_date,wp_em_events.event_rsvp_time,wp_em_events.event_rsvp_spaces,wp_em_events.event_spaces,wp_em_events.location_id,wp_em_events.recurrence_id,wp_em_events.event_status,wp_em_events.event_private,wp_em_events.event_date_created,wp_em_events.event_date_modified,wp_em_events.event_attributes,wp_em_events.blog_id,wp_em_events.group_id,wp_em_events.recurrence,wp_em_events.recurrence_interval,wp_em_events.recurrence_freq,wp_em_events.recurrence_days,wp_em_events.recurrence_byday,wp_em_events.recurrence_byweekno FROM wp_em_events
			LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id
			 WHERE (<code>recurrence</code>!=1 OR <code>recurrence</code> IS NULL) AND ( event_start_date <= CAST('2013-11-07' AS DATE) AND event_end_date >= CAST('2013-09-24' AS DATE) ) AND (<code>event_status</code>=1)
			ORDER BY event_name ASC, event_start_time ASC

		 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/dandelion/404.php'), print_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, EM_Widget_Calendar->widget, EM_Calendar->output, EM_Calendar->get, EM_Events->get
[30-Oct-2013 17:47:12 UTC] WordPress database error Unknown column 'wp_em_events.event_rsvp_spaces' in 'field list' for query
			SELECT wp_em_events.event_id,wp_em_events.post_id,wp_em_events.event_slug,wp_em_events.event_owner,wp_em_events.event_name,wp_em_events.event_start_time,wp_em_events.event_end_time,wp_em_events.event_all_day,wp_em_events.event_start_date,wp_em_events.event_end_date,wp_em_events.post_content,wp_em_events.event_rsvp,wp_em_events.event_rsvp_date,wp_em_events.event_rsvp_time,wp_em_events.event_rsvp_spaces,wp_em_events.event_spaces,wp_em_events.location_id,wp_em_events.recurrence_id,wp_em_events.event_status,wp_em_events.event_private,wp_em_events.event_date_created,wp_em_events.event_date_modified,wp_em_events.event_attributes,wp_em_events.blog_id,wp_em_events.group_id,wp_em_events.recurrence,wp_em_events.recurrence_interval,wp_em_events.recurrence_freq,wp_em_events.recurrence_days,wp_em_events.recurrence_byday,wp_em_events.recurrence_byweekno FROM wp_em_events
			LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id
			 WHERE (<code>recurrence</code>!=1 OR <code>recurrence</code> IS NULL) AND ( event_start_date <= CAST('2013-11-07' AS DATE) AND event_end_date >= CAST('2013-09-24' AS DATE) ) AND (<code>event_status</code>=1)
			ORDER BY event_name ASC, event_start_time ASC

Philip John

(@philipjohn)

10 years, 5 months ago

Hiya,

That does look like you have an issue with the database, which deleting all data and re-installing should fix.

Thanks

Thread Starter

Paal Joachim Romdahl

(@paaljoachim)

10 years, 5 months ago

I uninstalled and deleted the regular and Pro plugin.
Reinstalled and then went to create a new location. With the result saying:
Your location details are incorrect and cannot be published, please correct these errors first:

Something went wrong saving your location to the index table. Please inform a site administrator about this.

—-

I see no reason why I am getting the above error. I will also post at the Pro support area….

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Error message: Something went wrong saving your event to the index table’ is closed to new replies.