Title: Version 1.6.7 broke wordpress database
Last modified: August 31, 2016

---

# Version 1.6.7 broke wordpress database

 *  Resolved [coolest-storm](https://wordpress.org/support/users/coolest-storm/)
 * (@coolest-storm)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/)
 * Hi Franky,
    I recently update the plugin to the latest version 1.6.7. Unfortunately,
   it broke the database with the following comment
 *     ```
       WordPress database error: [The used SELECT statements have a different number of columns]
       SELECT * FROM wp_eme_events e LEFT JOIN wp_eme_locations l ON e.location_id=l.location_id WHERE (recurrence_id>0 AND event_status IN (1,2) AND (event_start_date >= '2016-02-04') AND ( FIND_IN_SET(3,event_category_ids) OR FIND_IN_SET(1,event_category_ids) OR FIND_IN_SET(2,event_category_ids))) group by recurrence_id union all SELECT * FROM wp_eme_events WHERE (recurrence_id=0 AND event_status IN (1,2) AND (event_start_date >= '2016-02-04') AND ( FIND_IN_SET(3,event_category_ids) OR FIND_IN_SET(1,event_category_ids) OR FIND_IN_SET(2,event_category_ids))) ORDER BY event_start_date ASC, event_start_time ASC, event_name ASC LIMIT 6
       ```
   
 * The error is located on the sidebar on this website: [http://catalyst.coolest-storm.net/~catal953/](http://catalyst.coolest-storm.net/~catal953/)
 * Would you mind to fix the issue?
 * [https://wordpress.org/plugins/events-made-easy/](https://wordpress.org/plugins/events-made-easy/)

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

 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025439)
 * Don’t worry, your database didn’t brake. It is just an incomplete sql statement
   added by the newly “performant” sql statement code and when using “show_recurrence_only_once”.
   
   I fixed it and released 1.6.8 for this
 *  Thread Starter [coolest-storm](https://wordpress.org/support/users/coolest-storm/)
 * (@coolest-storm)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025461)
 * Thanks Franky. I will applied the update when it comes.
 *  [fgenau](https://wordpress.org/support/users/fgenau/)
 * (@fgenau)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025485)
 * Hey Franky!
 * I also have got a database error since the update (1.6.8.):
 *     ```
       WordPress-Database-Error: [Unknown column 'wpacdm_eme_events.event_id' in 'where clause']
       SELECT * FROM wpacdm_eme_events e LEFT JOIN wpacdm_eme_locations l ON e.location_id=l.location_id
                 WHERE event_status IN (1,2) AND (event_rsvp=0 OR (event_rsvp=1 AND event_seats > (SELECT COALESCE(SUM(booking_seats),0) AS booked_seats FROM wpacdm_eme_bookings WHERE wpacdm_eme_bookings.event_id = wpacdm_eme_events.event_id))) AND  (event_start_date >= '2016-02-04' OR (event_end_date >= '2016-02-04' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL)) AND  FIND_IN_SET(4,event_category_ids)
                ORDER BY event_start_date ASC, event_start_time ASC, event_name ASC
                LIMIT 11
       ```
   
 * The single event-pages work just fine when I open them via backend. The problem
   comes up when I try to list events. Seems to be a problem with the Event-ID-Column.
   I checked it in the db itself and it looks normal. Any ideas?
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025494)
 * That’ll teach me to use table aliases in sql statements …
    This is due to the
   option to hide rsvp full events (and the sql generated by it). I now corrected
   it completely (I hope). Could you try to download the eme_events.php from here
   and replace it on your end:
 * [https://plugins.svn.wordpress.org/events-made-easy/trunk/eme_events.php](https://plugins.svn.wordpress.org/events-made-easy/trunk/eme_events.php)
 * Or if you want to apply the changeset manually:
    [https://plugins.trac.wordpress.org/changeset/1343221/](https://plugins.trac.wordpress.org/changeset/1343221/)
 *  [fgenau](https://wordpress.org/support/users/fgenau/)
 * (@fgenau)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025495)
 * This works.
 * Thank you so much!!!

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

The topic ‘Version 1.6.7 broke wordpress database’ is closed to new replies.

 * ![](https://ps.w.org/events-made-easy/assets/icon-256x256.png?rev=1856035)
 * [Events Made Easy](https://wordpress.org/plugins/events-made-easy/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-made-easy/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-made-easy/)
 * [Active Topics](https://wordpress.org/support/plugin/events-made-easy/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-made-easy/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-made-easy/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sidebar](https://wordpress.org/support/topic-tag/sidebar/)

 * 5 replies
 * 3 participants
 * Last reply from: [fgenau](https://wordpress.org/support/users/fgenau/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/version-167-broke-wordpress-database/#post-7025495)
 * Status: resolved