WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. nodokita
    Member
    Posted 1 year 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 1 year 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 1 year ago #

    I will try! Thanks!

  4. nodokita
    Member
    Posted 1 year ago #

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

  5. xdaseinx
    Member
    Plugin Author

    Posted 1 year ago #

    Great!

  6. forsandree
    Member
    Posted 1 year 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 1 year ago #

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

  8. jureham
    Member
    Plugin Author

    Posted 1 year 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 1 year ago #

    Works like a charm! Thanks!

  10. nodokita
    Member
    Posted 1 year 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

About this Topic