upPrev — Next Post Slide-in Box
Error In SQL Syntax (3 posts)

  1. Perryb2006
    Posted 5 years ago #

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

    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 :)

  2. Grzegorz Krzyminski
    Plugin Contributor

    Posted 5 years ago #

    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.

  3. Perryb2006
    Posted 5 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic