Hello,

I try to run a simple query with a date condition and it fails. 

SELECT first_name, last_name, id FROM wp_participants_database WHERE DATE(date_adhesion_converted) < '2018-01-01'

I have other queries using this condition without any problem but this one is causing this Error :

wpDataTables backend error: No data fetched! 
Rendered query: SELECT first_name, last_name, id FROM wp_participants_database WHERE DATE(date_adhesion_converted) < '2018-01-01' LIMIT 10
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2018-01-01' LIMIT 10' at line 1
This usually happens when the MySQL query returns an empty result or is broken. Please check the results of the query in some DB manager (e.g. PHPMyAdmin)

Could you tell me what is wrong ?

Thanks

Severin

Hello Bogdan,

This query works in phpMyadmin and also with "SQL executioner" plugin directly on the website.
I use it as input with "Add from data source" / MySQL table but it fails.

I don't want to use Views as it reminds me previous versions of wpDataTables plugin where it was oring to do so.

Do  you have any other idea to use this query (which is working in another "old/previous" table) ?

Severin

Very funny bug ;-)

Indeed when changing the < by a > the query works well. But that's not what I wanted to do... so I changed my query to 
SELECT first_name, last_name, id FROM wp_participants_database WHERE  '2018-01-01' > DATE(date_adhesion_converted)
and it worked !!!

So this trick is OK, but if you have a better solution, I ready to test it.

It works thanks Milos !

I guess it will be integrated in next release. You can close this ticket. Thanks

Severin