Latest version query fails

I have been running queries since always but updating to 5.5.41 started giving me problems.

SELECT COUNT(*)
FROM table
WHERE status = 'complete'
AND date < '2025-03-30 00:00:00';

Gives me ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”2025-03-30 00:00:00&#039′ at line 7

This is just one example of many queries I suddenly get errors from. I reverted back to 5.5.40 and its now working again.

Other errors in new version:

SELECT COUNT(*) FROM table
WHERE status = 'complete'
AND date < DATE_SUB(NOW(), INTERVAL 30 DAY);

gives

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DATE_SUB(NOW(), INTERVAL 30 DAY)’ at line 3

I used validators and its very strange..

• This topic was modified 8 months, 3 weeks ago by lisaxplore.
• This topic was modified 8 months, 3 weeks ago by lisaxplore.