Hi,
Recently, I noticed many of the following errors in my PHP server error log. These all seem related to the use of the calendar widget. The error occurs when browsing the monthly archives from the calendar widget but only in the default language and when the option Hide URL language information in the default language is checked. Other languages seem inaffected, or when the 'hide language URL info' is unchecked all is fine.
The error hinders the month browsing links at the bottom of the calendar widget to display.
[30-Apr-2012 11:12:26] WordPress databasefout 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 'ORDER BY post_date DESC
LIMIT 1' at line 6 bij query SELECT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_8_posts
INNER JOIN wp_8_term_relationships AS tr ON tr.object_id = ID
WHERE post_date < '2006-11-01'
AND post_type = 'post' AND post_status = 'publish' AND tr.term_taxonomy_id =
ORDER BY post_date DESC
LIMIT 1 gemaakt door require, require_once, include, thematic_sidebar, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Polylang_Widget_Calendar->widget, Polylang_Widget_Calendar->get_calendar
[30-Apr-2012 11:12:26] WordPress databasefout 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 'ORDER BY post_date ASC
LIMIT 1' at line 6 bij query SELECT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_8_posts
INNER JOIN wp_8_term_relationships AS tr ON tr.object_id = ID
WHERE post_date > '2006-11-30 23:59:59'
AND post_type = 'post' AND post_status = 'publish' AND tr.term_taxonomy_id =
ORDER BY post_date ASC
LIMIT 1 gemaakt door require, require_once, include, thematic_sidebar, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Polylang_Widget_Calendar->widget, Polylang_Widget_Calendar->get_calendar
[30-Apr-2012 11:12:26] WordPress databasefout 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 post_date <= '2006-11-30 23:59:59'' at line 6 bij query SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_8_posts
INNER JOIN wp_8_term_relationships AS tr ON tr.object_id = ID
WHERE post_date >= '2006-11-01 00:00:00'
AND post_type = 'post' AND post_status = 'publish' AND tr.term_taxonomy_id =
AND post_date <= '2006-11-30 23:59:59' gemaakt door require, require_once, include, thematic_sidebar, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Polylang_Widget_Calendar->widget, Polylang_Widget_Calendar->get_calendar
[30-Apr-2012 11:12:26] WordPress databasefout 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 bij query SELECT ID, post_title, DAYOFMONTH(post_date) as dom FROM wp_8_posts INNER JOIN wp_8_term_relationships AS tr ON tr.object_id = ID WHERE post_date >= '2006-11-01 00:00:00' AND post_date <= '2006-11-30 23:59:59' AND post_type = 'post' AND post_status = 'publish' AND tr.term_taxonomy_id = gemaakt door require, require_once, include, thematic_sidebar, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Polylang_Widget_Calendar->widget, Polylang_Widget_Calendar->get_calendarThanks for your support and development of this great plugin :)
