Support » Plugin: Relevanssi - A Better Search » Database error

  • Resolved Jagster_

    (@jagster_)


    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 20

    Caller:
    gbd_rd_date_queries()

    Component:
    Plugin: relevanssi-dashboard

    Error 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 3

    Cheers, Jakke

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Mikko Saari

    (@msaari)

    You’re barking up the wrong plugin. This isn’t from Relevanssi, it’s from Relevanssi Dashboard. Considering that plugin hasn’t been updated in eight years, I’d say the safest solution is to burn it with fire…

    So, not my code, nothing I can do about this, sorry.

    Thread Starter Jagster_

    (@jagster_)

    That’s right. I forgot totally those are two different plugins 😀

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error’ is closed to new replies.