Error log everyday, how to solve

  • Dear eveyone,

    Someday ago, the error log file showed an error and repeated everyday. Content as below:

    [11-Oct-2016 01:22:38 UTC] C? s? d? li?u c?a WordPress g?p l?i You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'buddypress'|option&gt|thành|viên') 
             then 8 else 0 end)) as releva' at line 13 v?i truy v?n 
    		SELECT 
          wp2_posts.post_title as title,
          wp2_posts.ID as id,
          wp2_posts.post_date as date,
          wp2_posts.post_content as content,
          wp2_posts.post_excerpt as excerpt,
          wp2_users.user_nicename as author, 
          wp2_posts.post_type as post_type,
          GROUP_CONCAT(DISTINCT wp2_terms.term_id) as terms,
          ((case when
            (lower(wp2_posts.post_title) REGEXP 't?|th?|abc') 
             then 10 else 0 end) + (case when
            (lower(wp2_posts.post_content) REGEXP '&lt|php|&gt|theo|buddypress|option|'buddypress'|option&gt|thành|viên') 
             then 8 else 0 end)) as relevance
    		FROM wp2_posts
        LEFT JOIN wp2_postmeta ON wp2_postmeta.post_id = wp2_posts.ID
        LEFT JOIN wp2_users ON wp2_users.ID = wp2_posts.post_author
        LEFT JOIN wp2_term_relationships ON wp2_posts.ID = wp2_term_relationships.object_id
        LEFT JOIN wp2_term_taxonomy ON wp2_term_taxonomy.term_taxonomy_id = wp2_term_relationships.term_taxonomy_id
        LEFT JOIN wp2_terms ON wp2_term_taxonomy.term_id = wp2_terms.term_id
        WHERE 
          
          (wp2_posts.ID <> 1871) AND
          (wp2_posts.post_type REGEXP 'dummy_notting|post') AND
          wp2_posts.ID NOT IN (-99) AND 
          (wp2_posts.post_status = 'publish') AND
          ((lower(wp2_posts.post_title) REGEXP 't?|th?|abc') OR (lower(wp2_posts.post_content) REGEXP 't?|th?|abc') OR (lower(wp2_posts.post_excerpt) REGEXP 't?|th?|abc') OR (lower(wp2_posts.post_content) REGEXP '&lt|php|&gt|theo|buddypress|option|'buddypress'|option&gt|thành|viên') OR (lower(wp2_posts.post_title) REGEXP '&lt|php|&gt|theo|buddypress|option|'buddypress'|option&gt|thành|viên') OR (lower(wp2_posts.post_excerpt) REGEXP '&lt|php|&gt|theo|buddypress|option|'buddypress'|option&gt|thành|viên'))  
        GROUP BY wp2_posts.ID
    		ORDER BY relevance DESC, wp2_posts.post_date DESC
    		LIMIT 10 yêu c?u b?i require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_feed, do_action('do_feed_rss2'), call_user_func_array, do_feed_rss2, load_template, require_once('wp-includes/feed-rss2.php'), the_excerpt_rss, get_the_excerpt, apply_filters('get_the_excerpt'), call_user_func_array, wp_trim_excerpt, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, rplShortcodeContainer->wpdreams_rpl_shortcode, wpdreams_related_content->getRelatedPosts, wpdreams_related_content->simpleRelated

    I’ve installed some plugins on my blog (Ithemes scurity, Buddypress,…) and just removed before happen error. Maybe that is reason. But now i don’t know how to fix.
    Please help me.
    Thank you so much.

    • This topic was modified 8 years, 1 month ago by gakho209.
Viewing 6 replies - 1 through 6 (of 6 total)

  • Hello,

    It looks like the error message is being caused by BuddyPress. If you haven’t already, try disabling the plugin. If the problem persists, try reinstalling WordPress. To do this, go to Updates on the Dashboard and click the Re-Install Now button.

    Hope that helps,

    Rob

    Thread Starter gakho209

    (@gakho209)

    I’ve uninstall Buddypress already, then deleted all table bp_ in database but can’t fix.
    But i remember this error happen after i uninstalled some plugins include Buddypress.
    Each day error_log showed tens of same errors.
    Maybe any plugin (Buddy, Itheme security, Spoiler,..) make change to sourecode of WP? Im using WP 4.5.3.

    Thread Starter gakho209

    (@gakho209)

    This is my blog: https://vntopic.net
    Anyone can help to find the error?

    Have you tried to re-install WordPress? You can do this very easily by clicking the “Re-Install Now” button which you’ll find under Dashboard > Updates.

    If that still doesn’t help, try and install a debugging plugin to help pinpoint the problem.

    Cheers,

    Rob

    Thread Starter gakho209

    (@gakho209)

    Hi Robhob,
    I’m using v4.5.3, so I can’t reinstall as you told. So I upgraded to lastest v4.6.1 but it can’t fix.
    I disabled 2 posts what include some keywords in the errors, then errors disappeared. For 2 days without errors, I think it’s ok but I’ve lost 2 posts and don’t know why :(. Hahaa.
    Thank you.

    Glad you’ve come right.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error log everyday, how to solve’ is closed to new replies.