Support

January 16, 2013 at 8:43 pm

We have a web app built around EE that manages calendars of events for our stores. We have a number of “Espresso Regional Manager” accounts. Each one creates EE events and manages her own store’s event calendar. Each store is a “region” and “locale” in EE terms. So each manager sets up only events for her own locale.

The issue is that when a store manager creates a new event, clicking to create generates a “Database error” from MySQL right after clicking to create the event. The event appears on the calendar for the locale, but does not appear in the manager’s list of events so she can’t manage it. (Obviously because of the MySQL error, which I will paste below.)

We very recently upgraded to WP 3.5 and most recent versions of EE and calendar. We left slightly older versions of some components in place. As follows:
“Current”
EE version 3.1.29.1.P
EE Calendar 2.0.4
“Not current”
EE Members addon 1.9.3
EE Permissions 1.5.1
EE Recurring Events 1.1.7
EE Roles and Permissions Pro 2.0.3-beta

I have a staging site as well, but when I upgrade all of the components to most recent versions, things pretty much fall apart and I get lots of errors. I’m going to try to debug that.

Any rough ideas would be appreciated.

Here’s the error ( you can see it’s related to “locale”):

(SELECT e.id event_id, e.event_name, e.event_identifier, e.reg_limit, e.registration_start, e.start_date, e.is_active, e.recurrence_id, e.registration_startT, e.wp_user , v.name AS venue_title, v.address AS venue_address, v.address2 AS venue_address2, v.city AS venue_city, v.state AS venue_state, v.zip AS venue_zip, v.country AS venue_country , lc.name AS locale_name, e.wp_user FROM wp_events_detail e LEFT JOIN wp_events_venue_rel vr ON vr.event_id = e.id LEFT JOIN wp_events_venue v ON v.id = vr.venue_id LEFT JOIN wp_events_locale_rel l ON l.venue_id = vr.venue_id LEFT JOIN wp_events_locale lc ON lc.id = l.locale_id WHERE e.event_status = ‘A’ AND l.locale_id IN () ) UNION (SELECT e.id event_id, e.event_name, e.event_identifier, e.reg_limit, e.registration_start, e.start_date, e.is_active, e.recurrence_id, e.registration_startT, e.wp_user , v.name AS venue_title, v.address AS venue_address, v.address2 AS venue_address2, v.city AS venue_city, v.state AS venue_state, v.zip AS venue_zip, v.country AS venue_country , lc.name AS locale_name, e.wp_user FROM wp_events_detail e LEFT JOIN wp_events_venue_rel vr ON vr.event_id = e.id LEFT JOIN wp_events_venue v ON v.id = vr.venue_id LEFT JOIN wp_events_locale_rel l ON l.venue_id = vr.venue_id LEFT JOIN wp_events_locale lc ON lc.id = l.locale_id WHERE e.event_status = ‘A’ AND e.wp_user = ’22’ ) ORDER BY start_date DESC LIMIT 50 OFFSET 0 /* From [stores.athleta.net/wp-admin/admin.php?page=events&action=add_new_event] in [/nas/wp/www/cluster-1063/stores/wp-content/plugins/event-espresso/includes/event-management/event_list.php:222] */