Community & Support

#1298 - Unknown or incorrect time zone: 'NULL' problem

Hi

Just recently I had to move my site from one account to another.
I took backup for files and DB with cpanel gui.
Then in new account I have tried to put my backup
and I got error during db import.

Then I have tried to put manually threw phpmysqladmin->SQL
and also it gives me more specify error like bellow

Error

SQL query:

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

MySQL said: Documentation
#1298 - Unknown or incorrect time zone: 'NULL'

I have found recommendation on internet to delete

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;

somewhere more bellow:
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

Will Drupal be affected if I will delete it?

ps.
I need to add that everything seems to works ok,
but I really don't want to find some nasty error much later when site will be almost finished.

Any Suggestions are welcome...

Comments

Do you confirm that deleting

Do you confirm that deleting those lines fixes the issue? Thanks anyway.

nobody click here