Resolved ERROR 1298 (HY000) at line 7: Unknown or incorrect time zone: 'NULL'

[kdrk1977]

Hello forum,

I was working fixing Unable to access Horde webmail or rename a domain in Plesk: Table 'horde.table_name' doesn't exist on CentOS 6.4 / Plesk Onyx 17.8.11 Update #65.

And when I ran "8.2. Restore the 'horde' database from a pre-upgrade dump:" I get

ERROR 1298 (HY000) at line 7: Unknown or incorrect time zone: 'NULL'

And not able to restore horde table.
My MySQL has

mysql> show variables like '%time_zone%';

+------------------+--------+

| Variable_name | Value |

+------------------+--------+

| system_time_zone | JST |

| time_zone | SYSTEM |

+------------------+--------+

2 rows in set (0.00 sec)

so it should not be null.

What should I do to fix "ERROR 1298 (HY000) at line 7: Unknown or incorrect time zone: 'NULL'" to restore horde table?

thank you for your help in advance.

Regards,

 

[alapshin]

Hello @kdrk1977,

Regarding this issue you will be updated in the scope of the ticket, that you have submitted in Plesk Support.