Database Errors!
-
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: https://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: https://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
- The topic ‘Database Errors!’ is closed to new replies.