Looks like error caused Django’s 1.6 timezone functionality changes. The docs now mention this error specifically (bug report, link to docs).
You have to load timezone tables into mysql (http://dev.mysql.com/doc/refman/5.6/en/mysql-tzinfo-to-sql.html).
Try execute on your database server:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -D mysql -u root -p
And then run “flush tables” or “flush query cache”, otherwise the problem may not disappear even though you’ve loaded the correct timezone data:
mysql -u root -p -e "flush tables;" mysql
updated by @qris