Database error
-
Hi,
Not a biggie but it is bothering Query Monitor. At dashboard:
Query:
SELECT COUNT(DISTINCT(id)) as cnt, query, hits
FROM
WHERE TIMESTAMPDIFF(DAY, time, NOW()) <= 30
GROUP BY query
ORDER BY cnt DESC
LIMIT 20Caller:
gbd_rd_date_queries()Component:
Plugin: relevanssi-dashboardError message:
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 ‘WHERE TIMESTAMPDIFF(DAY, time, NOW()) <= 30 GROUP BY query ORDER BY cn’ at line 3Cheers, Jakke
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Database error’ is closed to new replies.