WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Database Errors! (3 posts)

  1. Elan42.com
    Member
    Posted 6 years ago #

    Hi... while changing a post to a category to another, I had some mysql errors that are still present when I open the post.

    However the task seems to be completed, the post was effectively changed from a category to another.

    That are the errors:

    WordPress database error: [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 ') WHERE 1=1 AND (((post_title LIKE '%wp%') OR (post_content LIKE '%wp%')) AND (' at line 1]
    SELECT SQL_CALC_FOUND_ROWS blog_wp_posts.* , blog_wp_croer_posts.post_rank IS NULL AS isnull FROM blog_wp_posts INNER JOIN blog_wp_term_relationships ON (blog_wp_posts.ID = blog_wp_term_relationships.object_id) INNER JOIN blog_wp_term_taxonomy ON (blog_wp_term_relationships.term_taxonomy_id = blog_wp_term_taxonomy.term_taxonomy_id) LEFT JOIN blog_wp_croer_posts ON (blog_wp_posts.ID = blog_wp_croer_posts.post_id AND blog_wp_term_taxonomy.term_id = blog_wp_croer_posts.cat_id AND blog_wp_croer_posts.cat_id = ) WHERE 1=1 AND (((post_title LIKE '%wp%') OR (post_content LIKE '%wp%')) AND ((post_title LIKE '%admin%') OR (post_content LIKE '%admin%')) AND ((post_title LIKE '%divid=errorpclass=wpdberrorstrongWordPressdatabaseerror:%') OR (post_content LIKE '%divid=errorpclass=wpdberrorstrongWordPressdatabaseerror:%')) AND ((post_title LIKE '%strongYouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenearWHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taatline1br%') OR (post_content LIKE '%strongYouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenearWHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taatline1br%')) AND ((post_title LIKE '%codeSELECTSQL_CALC_FOUND_ROWSblog_wp_posts.%') OR (post_content LIKE '%codeSELECTSQL_CALC_FOUND_ROWSblog_wp_posts.%')) AND ((post_title LIKE '%blog_wp_croer_posts.post_rankISNULLASisnullFROMblog_wp_postsINNERJOINblog_wp_term_relationshipsONblog_wp_posts.ID=blog_wp_term_relationships.object_idINNERJOINblog_wp_term_taxonomyONblog_wp_term_relationships.term_taxonomy_id=blog_wp_term_taxonomy.term_taxonomy_idLEFTJOINblog_wp_croer_postsONblog_wp_posts.ID=blog_wp_croer_posts.post_idANDblog_wp_term_taxonomy.term_id=blog_wp_croer_posts.cat_idANDblog_wp_croer_posts.cat_id=WHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taxonomy.term_idIN0ANDpost_type=postANDpost_status=publishORpost_status=futureORpost_status=draftORpost_status=pendingORpost_status=privateGROUPBYblog_wp_posts.IDORDERBYisnullASC%') OR (post_content LIKE '%blog_wp_croer_posts.post_rankISNULLASisnullFROMblog_wp_postsINNERJOINblog_wp_term_relationshipsONblog_wp_posts.ID=blog_wp_term_relationships.object_idINNERJOINblog_wp_term_taxonomyONblog_wp_term_relationships.term_taxonomy_id=blog_wp_term_taxonomy.term_taxonomy_idLEFTJOINblog_wp_croer_postsONblog_wp_posts.ID=blog_wp_croer_posts.post_idANDblog_wp_term_taxonomy.term_id=blog_wp_croer_posts.cat_idANDblog_wp_croer_posts.cat_id=WHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taxonomy.term_idIN0ANDpost_type=postANDpost_status=publishORpost_status=futureORpost_status=draftORpost_status=pendingORpost_status=privateGROUPBYblog_wp_posts.IDORDERBYisnullASC%')) AND ((post_title LIKE '%blog_wp_croer_posts.post_rankASC%') OR (post_content LIKE '%blog_wp_croer_posts.post_rankASC%')) AND ((post_title LIKE '%post_dateDESCLIMIT0%') OR (post_content LIKE '%post_dateDESCLIMIT0%')) AND ((post_title LIKE '%10%') OR (post_content LIKE '%10%')) AND ((post_title LIKE '%code%') OR (post_content LIKE '%code%')) AND ((post_title LIKE '%p%') OR (post_content LIKE '%p%')) AND ((post_title LIKE '%divhttp:%') OR (post_content LIKE '%divhttp:%')) AND ((post_title LIKE '%www.nokao.com%') OR (post_content LIKE '%www.nokao.com%')) AND ((post_title LIKE '%wp%') OR (post_content LIKE '%wp%')) AND ((post_title LIKE '%admin%') OR (post_content LIKE '%admin%')) AND ((post_title LIKE '%edit.php?s=%') OR (post_content LIKE '%edit.php?s=%')) OR (post_title LIKE '%wp admin divid=errorpclass=wpdberrorstrongWordPressdatabaseerror: strongYouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenearWHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taatline1br codeSELECTSQL_CALC_FOUND_ROWSblog_wp_posts.,blog_wp_croer_posts.post_rankISNULLASisnullFROMblog_wp_postsINNERJOINblog_wp_term_relationshipsONblog_wp_posts.ID=blog_wp_term_relationships.object_idINNERJOINblog_wp_term_taxonomyONblog_wp_term_relationships.term_taxonomy_id=blog_wp_term_taxonomy.term_taxonomy_idLEFTJOINblog_wp_croer_postsONblog_wp_posts.ID=blog_wp_croer_posts.post_idANDblog_wp_term_taxonomy.term_id=blog_wp_croer_posts.cat_idANDblog_wp_croer_posts.cat_id=WHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taxonomy.term_idIN0ANDpost_type=postANDpost_status=publishORpost_status=futureORpost_status=draftORpost_status=pendingORpost_status=privateGROUPBYblog_wp_posts.IDORDERBYisnullASC,blog_wp_croer_posts.post_rankASC,post_dateDESCLIMIT0,10 code p divhttp: http://www.nokao.com wp admin edit.php?s=%') OR (post_content LIKE '%wp admin divid=errorpclass=wpdberrorstrongWordPressdatabaseerror: strongYouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenearWHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taatline1br codeSELECTSQL_CALC_FOUND_ROWSblog_wp_posts.,blog_wp_croer_posts.post_rankISNULLASisnullFROMblog_wp_postsINNERJOINblog_wp_term_relationshipsONblog_wp_posts.ID=blog_wp_term_relationships.object_idINNERJOINblog_wp_term_taxonomyONblog_wp_term_relationships.term_taxonomy_id=blog_wp_term_taxonomy.term_taxonomy_idLEFTJOINblog_wp_croer_postsONblog_wp_posts.ID=blog_wp_croer_posts.post_idANDblog_wp_term_taxonomy.term_id=blog_wp_croer_posts.cat_idANDblog_wp_croer_posts.cat_id=WHERE1=1ANDblog_wp_term_taxonomy.taxonomy=categoryANDblog_wp_term_taxonomy.term_idIN0ANDpost_type=postANDpost_status=publishORpost_status=futureORpost_status=draftORpost_status=pendingORpost_status=privateGROUPBYblog_wp_posts.IDORDERBYisnullASC,blog_wp_croer_posts.post_rankASC,post_dateDESCLIMIT0,10 code p divhttp: http://www.nokao.com wp admin edit.php?s=%')) AND blog_wp_term_taxonomy.taxonomy = 'category' AND blog_wp_term_taxonomy.term_id IN ('22', '25', '34') AND post_type = 'post' AND (post_status = 'publish' OR post_status = 'private') GROUP BY blog_wp_posts.ID ORDER BY isnull ASC, blog_wp_croer_posts.post_rank ASC, post_date DESC LIMIT 0, 10

  2. AndreSC
    Member
    Posted 6 years ago #

    looks like my plugin is at fault, I'm working on a solution

  3. Elan42.com
    Member
    Posted 6 years ago #

    Resolved, thanks to AndreSC.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.