Comments 1Kevin started the conversation3 days ago on Monday at 2:40pmUpdated version this morning and main "next rehearsal" query stopped working.Very simple query:SELECT * FROM 74c_wpdatatable_30where year(starttime) = YEAR (CURDATE())AND WEEK(CURDATE()+1) = WEEK(starttime)Complete schedule is working:https://orchestrasociety.org/schedule/ 1Kevin replied2 days ago on Monday at 6:41pmI removed the +1 from the CURDATE and it works again.This had been working fine for months and months until I updated the plugin this morning. Sign in to reply ...
Updated version this morning and main "next rehearsal" query stopped working.
Very simple query:
SELECT * FROM 74c_wpdatatable_30
where year(starttime) = YEAR (CURDATE())
AND WEEK(CURDATE()+1) = WEEK(starttime)
Complete schedule is working:
https://orchestrasociety.org/schedule/
I removed the +1 from the CURDATE and it works again.
This had been working fine for months and months until I updated the plugin this morning.