Hi guys, we see a lot of people struggling with the recent TIME ZONE CHANGE in the United States, and with the upcoming time zone change in Europe (March 26th). If you see incorrect times in the appointments booked after Daylight Savings Time starts, the time zone of your WordPress site needs to be adjusted.
Please check out THIS ARTICLE about the time zones in Amelia.
I have a query that i am trying to run (See Below), however the query comes back with an error -
The query i am executing is -
Removing the "INTERVAL 31 DAY" resolves the issue and allows the query to proceed. However when processing this manually on MYSQL, the query works without issue and provides the relevant data.
Is there a way you have to specify an interval or is this not supported in wpDataTables ?
Thank you for your purchase.
Our recommendation when creating mysql tables is not to use functions like SUM, GROUP BY, ORDER BY etc.
If you have some complicated query my suggestion is to make a VIEW in phpmyadmin or any other database management system and see if that query returns the desired result.
If the result is good , use that query as an input when creating the tables with Add from data source option.
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables