[Answer]-Zinnia returned an invalid value in QuerySet.datetimes() with MySQL backend

by

0👍

✅

This link.

In short, you need to manually load the timezone information and the problem is solved. The unknown timezone was the issue.

👤David Boshton

1👍

I have change the timezone of mysql like this

mysql> SET GLOBAL time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)

mysql> SET time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| +08:00             | +08:00              |
+--------------------+---------------------+
1 row in set (0.00 sec)

but the error was still existed.

👤henry.chen

Leave a comment