I have started receiving an error message which seems to be linked to Slimstats, when I am in the admin interface for the Events Manager plugin (https://wordpress.org/plugins/events-manager/).
This is the error:
<p class="wpdberror"><strong>Errore sul database di WordPress:</strong> [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 ') AND dt BETWEEN 1581811200 AND 1584387002 GROUP BY resource LIMIT 0, 1000' at line 3]<br><code> SELECT resource, COUNT( DISTINCT id ) as counthits FROM ntzmv__slim_stats WHERE () AND dt BETWEEN 1581811200 AND 1584387002 GROUP BY resource LIMIT 0, 1000</code></p>
The error only appears when my “future events” are empty. If I open the “past events” (which is not empty) I no longer see the error. If I create a new future event and save it as a draft, the list of “future events” is no longer empty and I don’t see the error. But if I delete this future event, and the list is empty again, I again see the error.
I have tried force refreshing the page to make sure there weren’t old scripts in browser cache. I also have “Disable cache (while DevTools is open)” checked in my Chrome Developer Console, so I can’t have an old cached script.
- The topic ‘You have an error in your SQL syntax’ is closed to new replies.