• Resolved hassimkhan

    (@hassimkhan)


    Hello,

    The plugin is giving a database error, please fix as soon as possible:

    SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17

    The 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 '-1' at line 11 for query SELECT SQL_CALC_FOUND_ROWS  posts.ID FROM posts  LEFT JOIN term_relationships ON (posts.ID = term_relationships.object_id)  LEFT JOIN term_relationships AS tt1 ON (posts.ID = tt1.object_id) WHERE 1=1  AND ( 
      posts.ID NOT IN (
    				SELECT object_id
    				FROM term_relationships
    				WHERE term_taxonomy_id IN (XXX)
    			) 
      AND 
      term_relationships.term_taxonomy_id IN (XXX) 
      AND 
      tt1.term_taxonomy_id IN (XXX)
    ) AND posts.post_type = 'product' AND (posts.post_status = 'publish' OR posts.post_status = 'private') GROUP BY posts.ID ORDER BY posts.ID ASC LIMIT 0
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error’ is closed to new replies.