WordPress.org

Ready to get started?Download WordPress

Forums

Polylang
Calendar widget bug (3 posts)

  1. RavanH
    Member
    Posted 2 years ago #

    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_calendar

    Thanks for your support and development of this great plugin :)

    http://wordpress.org/extend/plugins/polylang/

  2. Chouby
    Member
    Plugin Author

    Posted 2 years ago #

    The new version 0.8.5 should "hide" the error but since I did not reproduce the bug, I made corrections blindly and I am not sure it solves the problem hidden behind.

  3. RavanH
    Member
    Posted 2 years ago #

    OK thanks. I'll keep you posted if I still see the error after upgrade and if I can find out more about it's origin.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags