Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1273819

    Hello,

    We seem to have an issue with a few of the websites we have built with Enfold with WordPress database error “You have an error in your SQL syntax” and MariaDB.

    Below is a copy of the two errors :

    [19-Jan-2021 16:28:57 UTC] 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 ‘))) AND wp_posts.post_type = ‘fake_search_no_results’ AND (wp_posts.post_s…’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_name = ‘custom-presentation-foamcore-displays’ AND ((())) AND wp_posts.post_type = ‘fake_search_no_results’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    [19-Jan-2021 16:32:13 UTC] 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 ‘))) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’)…’ at line 5 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (821)
    AND
    tt1.term_taxonomy_id IN (821)
    ) AND ((())) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/enfold/tag.php’), query_posts, WP_Query->query, WP_Query->get_posts

    WordPress: 5.5 & 5.6
    PHP Version: 7.3.23
    MySQL Version: 10.3.27-MariaDB

    Thank you for your help

    #1274274

    Hey wdwalrus,

    Did you try to activate another theme to see what happens then? Also please try disabling all plugins to see if there is a conflict coming from any of them?

    Best regards,
    Rikard

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.