[Plugin: Yet Another Related Posts Plugin] WP DB Error on upgrading from 3.02 -> 3.03

  • Hello All,

    I’m receiving the following error on YARPP after upgrading from 3.02 -> 3.03

    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 '<li> and date > date_sub(now(),interval 600 minute)' at line 1]
select count(*) as count from wp_yarpp_related_cache where reference_ID = <li> and date > date_sub(now(),interval 600 minute)
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 '<li>' at line 1]
select post_content from wp_posts where ID = <li>
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 '<li>' at line 1]
select post_title from wp_posts where ID = <li>
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 '<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
insert into wp_yarpp_keyword_cache (ID,body,title) values (<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
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 '<li> and ID != 0' at line 1]
select ID from wp_yarpp_related_cache where reference_ID = <li> and ID != 0
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 '<li>' at line 1]
delete from wp_yarpp_related_cache where reference_ID = <li>
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 '<li>' at line 1]
select body from wp_yarpp_keyword_cache where ID = <li>
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 '<li>' at line 1]
select post_content from wp_posts where ID = <li>
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 '<li>' at line 1]
select post_title from wp_posts where ID = <li>
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 '<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
insert into wp_yarpp_keyword_cache (ID,body,title) values (<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
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 '<li>' at line 1]
select body from wp_yarpp_keyword_cache where ID = <li>
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 '<li>' at line 1]
select title from wp_yarpp_keyword_cache where ID = <li>
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 '<li>' at line 1]
select post_content from wp_posts where ID = <li>
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 '<li>' at line 1]
select post_title from wp_posts where ID = <li>
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 '<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
insert into wp_yarpp_keyword_cache (ID,body,title) values (<li>,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
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 '<li>' at line 1]
select title from wp_yarpp_keyword_cache where ID = <li>
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 '<li>, ID, (0+ (MATCH (post_content) AGAINST ('')) * 1+ (MATCH (post_title) AGAIN' at line 1]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT <li>, ID, (0+ (MATCH (post_content) AGAINST ('')) * 1+ (MATCH (post_title) AGAINST ('')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left JOIN wp_term_relationships AS thistag ON (thistag.object_id = <li> ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = <li> ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = 'category') where (post_status IN ( 'publish', 'static' ) and ID != '<li>') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()
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 '<li> and ID not in (0)' at line 1]
select ID from wp_yarpp_related_cache where reference_ID = <li> and ID not in (0)

    You can view an example at:

    https://www.hairenik.com/weekly/2009/04/24/obama-will-not-acknowledge-armenian-genocide/

    I tried going in and updating the options, rebuilding my cache, uninstalling and re-installing the plugin – all to no avail. Any help would be appreciated. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hey webteamarm,

    Have you got any response else where yet for this problem?

    It did not show any here.

    I just search the total who has got plugin problem after upgrading to WP 2.7 or 2.71.

    For my case, I was just fine after upgrading to WP 2.7 but problems start to surface when I upgraded to WP 2.71.

    Plugins like wp-autoblog, autoblogged, YARPP, simple forum, the problem is I have around 20 wordpress sites that was upgraded to 2.71.

    Hope to find the solution for this, soon! If not I will need to downgrade all my wp sites.

    and I do not know how to do that???

    May be it an good idea just show some error message I received with my sites. I did not know which plugin caused these problems:-

    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 'AND post_type = 'post' ORDER BY score DESC' at line 1]
SELECT DISTINCT ID,post_title,post_date,MATCH(post_title,post_content) AGAINST (' ') AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST (' ') AND post_date <= '2009-05-09 14:02:12' AND post_status = 'publish' AND id != AND post_type = 'post' ORDER BY score DESC
<code></code>
    Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at ezblog.co.cc Port 80

    FUNNY enough, as I was trying to show some error message, some plugins seem to start working now. I did not change anything!

    Anyhow, I just show the error message so that the plugin creator might have some clue over the matters.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] WP DB Error on upgrading from 3.02 -> 3.03’ is closed to new replies.