WordPress.org

Forums

[Plugin: Yet Another Related Posts Plugin] Plugin not working. PHP errors. (3 posts)

  1. soniczen
    Member
    Posted 6 years ago #

    Hi,

    The plugin activates fine, and I can open up the options and make changes, but I'm getting PHP errors and the plugin just doesn't work.

    WP: 2.6.1
    MyQSL: 5.0.41
    PHP: 5.2.5

    Upon activation, here are the PHP errors:
    [26-Aug-2008 10:11:13] PHP Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /Users/preynolds/Documents/_SVN/sandbox/pl/wp/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 41
    [26-Aug-2008 10:11:13] PHP Warning: array_keys() [function.array-keys]: The first argument should be an array in /Users/preynolds/Documents/_SVN/sandbox/pl/wp/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 42
    [26-Aug-2008 10:11:13] PHP Warning: Invalid argument supplied for foreach() in /Users/preynolds/Documents/_SVN/sandbox/pl/wp/wp-content/plugins/yet-another-related-posts-plugin/includes.php on line 4

    Upon refreshing a post, I'm getting an SQL syntax error:
    [26-Aug-2008 10:15:16] 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 'order by score desc limit' at line 17 for query SELECT *, (bodyscore * 0 + titlescore * 0 + tagscore * 1 + catscore * 1) AS score
    from (
    select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('')) as bodyscore, (MATCH (post_title) AGAINST ('app iphone beatmaker')) as titlescore, ifnull(catscore,0) as catscore, ifnull(tagscore,0) as tagscore
    from wp_posts left join (
    select count(*) as tagscore, object_id from wp_term_relationships natural join wp_term_taxonomy
    where wp_term_taxonomy.taxonomy = 'post_tag'
    and wp_term_taxonomy.term_taxonomy_id in (select term_taxonomy_id from wp_term_relationships where object_id = '10')
    group by object_id
    ) as matchtags on (wp_posts.ID = matchtags.object_id)
    left join (
    select count(*) as catscore, object_id from wp_term_relationships natural join wp_term_taxonomy
    where wp_term_taxonomy.taxonomy = 'category'
    and wp_term_taxonomy.term_taxonomy_id in (select term_taxonomy_id from wp_term_relationships where object_id = '10')
    group by object_id
    ) as matchcats on (wp_posts.ID = matchcats.object_id)
    where ((post_status IN ( 'publish', 'static' ) && ID != '10') and post_password ='' and post_type IN ('post') )
    ) as rawscores where (bodyscore * 0 + titlescore * 0 + tagscore * 1 + catscore * 1) >= order by score desc limit made by yarpp_related

  2. soniczen
    Member
    Posted 6 years ago #

    UPDATE: I rolled back to WP 2.6, and that seems to have fixed the problem.

  3. @soniczen - I'm sorry that happened to you... I also recently upgraded to 2.6.1 without any issues... I believe the issue can be solved once upgrading to 2.6.1 by going to the YARPP settings page and re-entering your threshold value. Please let me know if that works for you.

    mitcho

Topic Closed

This topic has been closed to new replies.

About this Topic