WordPress.org

Forums

WordPress Related Posts
[resolved] Error Syntax SQL [AND tt.term_id IN ()] (10 posts)

  1. nodokita
    Member
    Posted 2 years ago #

    Hi ! I have this.. and more of this in the error log:

    [29-Dec-2012 20:36:16 UTC] 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 ')' at line 1 de la base de datos de WordPress para la consulta SELECT COUNT(tt.term_id) FROM wp_term_taxonomy tt, wp_term_relationships tr WHERE tt.taxonomy = 'category' AND tt.term_taxonomy_id = tr.term_taxonomy_id AND tr.object_id = 7204 AND tt.term_id IN () realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/MyTheme/single.php'), wp_related_posts, wp_get_related_posts, wp_rp_get_related_posts, wp_rp_should_exclude
    .....

    I desactivate the plugin, and the problem stop.
    I have been using this plugin in 3 pages, and all have the same error.. differents hostings, themes, and plugins instaled..
    Can you help me? thanks!

    http://wordpress.org/extend/plugins/wordpress-23-related-posts-plugin/

  2. jureham
    Member
    Plugin Author

    Posted 2 years ago #

    Hi,

    I'm not sure it will fix the issue but I pushed something that potentially could to the development version.

    http://downloads.wordpress.org/plugin/wordpress-23-related-posts-plugin.zip

    Please try it out.

    Thanks,

    Jure

  3. nodokita
    Member
    Posted 2 years ago #

    I will try! Thanks!

  4. nodokita
    Member
    Posted 2 years ago #

    No more errors in the Logs, thank you very much !!

  5. xdaseinx
    Member
    Plugin Author

    Posted 2 years ago #

    Great!

  6. forsandree
    Member
    Posted 2 years ago #

    I'm getting the same error at the top of my 404 error pages. Disappears when the plugin is disabled. Any ideas what's causing this?

    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 tt.term_id IN (1,9,12,14)' at line 1]
    SELECT COUNT(tt.term_id) FROM wp_term_taxonomy tt, wp_term_relationships tr WHERE tt.taxonomy = 'category' AND tt.term_taxonomy_id = tr.term_taxonomy_id AND tr.object_id = AND tt.term_id IN (1,9,12,14)
  7. forsandree
    Member
    Posted 2 years ago #

    Oh, forgot to mention, I am using the version in the zip above.

  8. jureham
    Member
    Plugin Author

    Posted 2 years ago #

    Hi,

    please try the new version from
    http://downloads.wordpress.org/plugin/wordpress-23-related-posts-plugin.zip

    Thanks.

    Best, Jure

  9. forsandree
    Member
    Posted 2 years ago #

    Works like a charm! Thanks!

  10. nodokita
    Member
    Posted 2 years ago #

    With the new version (2.3) this fix it's included? It's safe update the plugin? Thanks!

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WordPress Related Posts
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic