[Plugin: Events Manager] SQL error on event-save

Like what you said, it could be a plugin conflict or a theme issue; You can try to deactivate other plugins or revert to default theme. Also, can you provide more details such as installed plugin, theme or if its in multisite mode.

is this when you create a new event?

Hi Marcus,

Yes, it only happens when I try to create a new event. Both the ‘save draft’ and the ‘Publish’ buttons will cause it.

Site details:
Theme: Suffusion with child theme
multisite: NO
WP version: 3.3.1

Cheers,
Jen

Not sure what’d cause this. I’d try disabling your plugins and use the 2011 theme to see if any of these are causing it.

I disabled all plugins except Event Manager and tried the 2011 theme. The problem still occurs.

One thing I did notice, is that all the test events I’ve been creating actually do end up in the Events list (both admin and on the calendar). So the SQL error is more alarming than harmful.

could be, but would be nice to avoid it….

Is WP_DEBUG on for you in wp-config.php (you should turn it off if you’re on a production site)? I tried creating an event with it enabled and didn’t duplicate this.

I’d forgotten I had WP_DEBUG==true. Turning it off does fix the immediate issue in an ‘out of sight, out of mind’ sort of way.

I usually develop with WP_DEBUG on, so usually this doesn’t happen… If we can find the pattern as to why it happens it would probably be an easy fix.

Try patching events-manager/classes/em-event.php with the folling:

583c583,587
< 			$event_truly_exists = $wpdb->get_var('SELECT event_id FROM '.EM_EVENTS_TABLE." WHERE event_id={$this->event_id}") == $this->event_id;
---
>       if (empty($this->event_id)) {
>         $event_truly_exists = false;
>       } else {
>         $event_truly_exists = $wpdb->get_var('SELECT event_id FROM '.EM_EVENTS_TABLE." WHERE event_id={$this->event_id}") == $this->event_id;
>       }

The error is raising when the event_id property of the EM_Event object is empty, and so the query fails.

agreed, thx for fix