Latest WP 3.3.1 (Multisite)
Latest Infinite SEO 1.3.6
I'm seeing the following block of errors in MySQL log repeated at different dates / times:
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_title, apply_filters, call_user_func_array, WDS_OnPage->wds_title, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, Wdfb_PublicPages->inject_opengraph_info, wdfb_get_og_image, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, WDS_OnPage->wds_head, WDS_OnPage->wds_stop_title_buffer, ob_end_flush, WDS_OnPage->wds_process_title_buffer, WDS_OnPage->wds_title, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, WDS_OnPage->wds_head, WDS_OnPage->wds_metadesc, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, the_content, apply_filters, call_user_func_array, stream_output
Post terms vary in the errors of course, but the entire block is repeated per post_term. Times are in GMT, so no I'm not posting from the future :) Thanks.
Latest WP 3.3.1 (Multisite)
Latest Infinite SEO 1.3.6
I'm seeing the following block of errors in MySQL log repeated at different dates / times:
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_title, apply_filters, call_user_func_array, WDS_OnPage->wds_title, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, Wdfb_PublicPages->inject_opengraph_info, wdfb_get_og_image, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, WDS_OnPage->wds_head, WDS_OnPage->wds_stop_title_buffer, ob_end_flush, WDS_OnPage->wds_process_title_buffer, WDS_OnPage->wds_title, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, WDS_OnPage->wds_head, WDS_OnPage->wds_metadesc, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
[10-Jan-2012 06:57:52] 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 '-10, 10' at line 1 for query SELECT * FROM wp_site_posts WHERE post_terms LIKE '%|210|%' AND blog_public = 1 AND post_type = 'post' ORDER BY site_post_id DESC LIMIT -10, 10 made by require, require_once, include, the_content, apply_filters, call_user_func_array, stream_output
Post terms vary in the errors of course, but the entire block is repeated per post_term. Times are in GMT, so no I'm not posting from the future :) Thanks.
9603 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Sales & Support Pro
—
10th January 2012 (4 months ago)
#
Hiya!
Can you explain why you think it's Infinite SEO related please? Looking at the errors are telling me it's to do with Post Indexer or one of the related global plugins.
I'm going to ask the developer about what might be causing such errors.
10624 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Sales & Support Lead
—
25th January 2012 (3 months ago)
#
Hiya,
Just checking if it was eventually resolved in another thread? Or by yourself separately to us? Or by us over email with you? Or using our live support?
If so, no need to reply, that's great news.
If not, could you let us know by re-opening this topic, and we'll get onto it and helping you out asap!
Otherwise, happy days, glad you got it sorted :)
It was mostly FYI as something for your developers to look into fixing for the next version. I honestly haven't had time to dig deeply into researching impact and if it is causing a practical issue in operation or just adding superfluous errors to the mysql log :) If a developer doesn't see the same issue in the logs and/or can't reproduce it, then I'll have to dive deeper or just live with it :) But I wanted to let you know in case it was something that needed fixing.
5567 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Kangaroo
—
17th February 2012 (3 months ago)
#
Greetings ClvrTv,
Just checking if this issue was eventually resolved in another thread? Or by
yourself separately to us? Or by us over email with you? Or using our live
support?
If so, no need to reply, that's great news.
If not, or you have any more questions related to this thread, please feel free
to post them below including any new symptoms or errors and tick the 'Mark as
Not Resolved (re-open)' box below the post area (or else we'll miss it!)
Responses (6)
Sales & Support Pro — 10th January 2012 (4 months ago) #
Hiya!
Can you explain why you think it's Infinite SEO related please? Looking at the errors are telling me it's to do with Post Indexer or one of the related global plugins.
I'm going to ask the developer about what might be causing such errors.
Thanks,
Phil
Member — 10th January 2012 (4 months ago) #
Because the stack trace in the error shows that the queries are initiated by wds functions which are part of Infinite SEO:
made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, WDS_OnPage->wds_head, WDS_OnPage->wds_metadesc, wds_replace_vars, wp_trim_excerpt, apply_filters, call_user_func_array, stream_output
(couldn't think of any other reason WDS calls would be involved)
Thanks!
Sales & Support Lead — 25th January 2012 (3 months ago) #
Hiya,
Just checking if it was eventually resolved in another thread? Or by yourself separately to us? Or by us over email with you? Or using our live support?
If so, no need to reply, that's great news.
If not, could you let us know by re-opening this topic, and we'll get onto it and helping you out asap!
Otherwise, happy days, glad you got it sorted :)
Thanks!
Member — 27th January 2012 (3 months ago) #
It was mostly FYI as something for your developers to look into fixing for the next version. I honestly haven't had time to dig deeply into researching impact and if it is causing a practical issue in operation or just adding superfluous errors to the mysql log :) If a developer doesn't see the same issue in the logs and/or can't reproduce it, then I'll have to dive deeper or just live with it :) But I wanted to let you know in case it was something that needed fixing.
Thanks!
Sales & Support Lead — 1st February 2012 (3 months ago) #
Cool. Flagging this for the Infinite SEO Dev to take a look.
Thanks!
Support Kangaroo — 17th February 2012 (3 months ago) #
Greetings ClvrTv,
Just checking if this issue was eventually resolved in another thread? Or by
yourself separately to us? Or by us over email with you? Or using our live
support?
If so, no need to reply, that's great news.
If not, or you have any more questions related to this thread, please feel free
to post them below including any new symptoms or errors and tick the 'Mark as
Not Resolved (re-open)' box below the post area (or else we'll miss it!)
Otherwise, happy days, glad you got it sorted :)
Thank you for being a WPMU Dev member!
Cheers, Joe :-)
Become a member