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
Tue 10 Oct 2006
Posted by 馬先生 under Cantonese
Found some interesting HKATV documentaries on Non-Chinese people speaking Cantonese in Hong Kong:
| Norwegian | ||
| Part 1: 03:24min | Part 2: 07:17min | Part 3: 09:39min |
|
|
|
| Indian | ||
| Part 1: 04:38min | Part 2: 06:01min | Part 3: 09:49min |
|
|
|
| New Zealand / Australian | ||
| Part 1: 09:17min | Part 2: 05:30min | Part 3: 05:14min |
|
|
|
| American | ||
| Part 1: 09:25min | Part 2: 05:29min | Part 3: 05:20min |
|
|
|
Hong KongWordPress 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
October 14th, 2006 at 2:12 pm
How good are you then, why don’ you put a sample of your own on the site, so everyone else can compare?
October 14th, 2006 at 3:07 pm
Hi Simon,
I never intended to compare myself to people who have been speaking Cantonese for nearly their entire lives. These people have lived in Hong Kong and actively studied Cantonese for many years. I have only been studying Cantonese for a fraction of the time to what they have, so I don’t think its fair to compare me to them.
I just need a little more time to improve before I’m ready to upload samples of myself. I would only upload to simply seek feedback or note down my progress, not to show-off in anyway. At the moment, I don’t feel that I’m ready yet.
Thank you.
October 15th, 2006 at 1:44 pm
Oh, I thought you were in Hong Kong sorry.
How long on average do you think it takes a non-chinese to learn Cantonese well enough from scratch?
I have been learnig passively for 7 years and am no where fluent, depressing.
October 15th, 2006 at 11:28 pm
Hi Simon.
I never said whether I was or wasn’t in Hong Kong. What I am stating is that I haven’t learnt Cantonese for as long as these people, so it’s not fair to compare me to them.
I have collated a large amount of information on language acquisition discussing fluency and will write about it in future posts. I have actively studied French for 12+ years, so I have some experience in learning languages. I have seen people that have studied 2 years actively and speak much more advanced to someone speaking with 10 years passive studies. For me, I can only improve if I put effort in studying through Intermediate and Advanced Cantonese text books. I use my Guangzhou tutor to actively build my vocabulary, and my wife to practise what I’ve learnt somewhat passively. I think learning purely from the streets is not the best way to study the language quickly.
I’ll probably talk more about this later, but some helpful advice I’ve found came from:
Myth #1: “The best way to learn a foreign language is to go to a foreign country”
http://www.antimoon.com/other/myths-country.htm
Myth #2: “The best way to learn a foreign language is to speak it”
http://www.antimoon.com/other/myths-speaking.htm
I think passive learning is only a small component of language studies. I feel to improve, one needs to actively study.