Timezone missing in mysql database (celery periodic task)

 Ref: https://stackoverflow.com/questions/21351251/database-returned-an-invalid-value-in-queryset-dates#21571350

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 

Comments

Popular posts from this blog

Generate SHA-1 and SHA-256 for Debug and Release android app

How to Import and Export MySQL Database Command line in Linux

JAVA_HOME setup and Integrate with Android Studio Project in Ubuntu