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 October, 2007

Tuesday, October 16th, 2007

New mission - learning to read

When I first started to learn Cantonese and even up to a few days ago, I thought that reading and writing Chinese would be a total waste of my time. Speaking Cantonese fluently is all that I needed and I would be happy. Besides street signs are written in both English and Chinese.
I was only […]

5 Comments » - Posted in Cantonese by 馬先生

Tuesday, October 2nd, 2007

Cantonese in the Mainland

So I spent the last 6 days in Mainland China for a holiday. It wasn’t the complete culture shock being that road rules seem to not exist or sales assistants follow you everywhere you go that made me feel uncomfortable, it was that the so-called local language seemed to not exist.
廣州 - gwong2 zau1 - […]

11 Comments » - Posted in Cantonese by 馬先生