WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cantehk_wrdp1.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

Archive for January, 2011

Sunday, January 9th, 2011

Cantoneseclass101.com

I came across a free site cantoneseclass101.com, they provide free mp3 and transcripts for many many lessons in beginner, intermediate, and advanced. I think, however, they could remove the 10 second English trailer on each MP3 which becomes annoying when looping the audio on your mp3 player.
Edit: Oh wait… It’s not really free… […]

8 Comments » - Posted in Cantonese by 馬先生