Version 1.6.7 broke wordpress database

Resolved

(@coolest-storm)

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/

Would you mind to fix the issue?

https://wordpress.org/plugins/events-made-easy/

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

Plugin Author Franky
(@liedekef)

10 years, 3 months ago

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
(@coolest-storm)

10 years, 3 months ago

Thanks Franky. I will applied the update when it comes.
fgenau
(@fgenau)

10 years, 3 months ago
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
(@liedekef)

10 years, 3 months ago

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

Or if you want to apply the changeset manually:
https://plugins.trac.wordpress.org/changeset/1343221/

fgenau
(@fgenau)

10 years, 3 months ago

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.

Tags