WordPress database 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 Rows >= 0 at line 1 for query SHOW TABLE STATUS WHERE Rows >= 0

Home Forums BulletProof Security Pro WordPress database 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 Rows >= 0 at line 1 for query SHOW TABLE STATUS WHERE Rows >= 0

This topic contains 2 replies, has 2 voices, and was last updated by  Jaiji 1 week, 2 days ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #35661

    Jaiji
    Participant

    Hi, one of my sites has just been migrated to a new server by the new hosting company. Sadly I wasn’t informed beforehand so I had to go in and sort out BPS Pro before anything would work. Took a while but all is now good except this error:

    WordPress database 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 'Rows >= 0' at line 1 for query SHOW TABLE STATUS WHERE Rows >= 0 made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, bpsPro_DB_Monitor_check

    I’ve no idea, is it something I need to take up with the host?

    #35663

    AITpro Admin
    Keymaster

    We are aware of this issue with MariaDB version 10.2+ and are looking for the cause of this issue.  For now just turn off the DB Monitor until we can figure out what is causing this error.  The problem is there is not a problem.  The code that is generating this php error is used in several places throughout BPS Pro, but for some strange reason this php error only occurs with the one instance of the exact same code used on the main DB Monitor page.

    1. Go to the BPS Pro > DB Monitor page.
    2. Change the Turn On|Off DB Monitor option setting to DB Monitor Off.

    Reference link: https://wordpress.org/support/topic/wordpress-database-error-you-have-an-error-in-your-sql-syntax-right-syntax-to-u/

    #35669

    Jaiji
    Participant

    Thanks for this.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.