WordPress.org

Support

Support » Plugins and Hacks » Error In SQL Syntax

Error In SQL Syntax

  • Talking about this plugin: http://wordpress.org/extend/plugins/upprev-nytimes-style-next-post-jquery-animated-fly-in-button/

    Hi,
    After updating wordpress to 3.1.4 and later on to 3.2, the error log started registering following error repeatedly:

    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 p.post_date < ‘2010-06-23 21:07:11’ AND p.post_type = ‘attachment’ AND p’ at line 1 for query SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = ‘category’ AND tt.term_id IN () WHERE p.post_date < ‘2010-06-23 21:07:11’ AND p.post_type = ‘attachment’ AND p.post_status = ‘publish’ AND tt.taxonomy = ‘category’ ORDER BY p.post_date DESC LIMIT 1 made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, upprev_box, get_adjacent_post

    I am guessing this has something to do with plugin’s compatibility with newer version of wordpress.
    Please help 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Grzegorz Krzyminski

    @gkrzyminski

    I will check do I get similar logs, but the problem is, this is generated by a standard wp function: get_adjacent_post: http://codex.wordpress.org/Function_Reference/get_adjacent_post

    I would be rather suggesting to report this at some general WP thread.

    Alright. I will raise this issue in General forum. However this error disappeared once I disabled the plugin, so I guess either it’s is conflicting with some other plugin or has general compatibility issue with WordPress 3.2.

    BTW is “upPrev Previous Post Animated Notification” compatible with wordpress 3.2.1? I never tried it with the latest release.

    Thanks for the help 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error In SQL Syntax’ is closed to new replies.