As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3848301
Query stopped working after latest release
Closed

Comments

  •  1
    Kevin started the conversation

    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/


  •  1
    Kevin replied

    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.