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 🙂
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 🙂
- The topic ‘Error In SQL Syntax’ is closed to new replies.