Open

How to Solve: SQLSTATE[HY000]

February 27th, 2021      Admin

How to Solve: SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone

Its a specific issue with Windows systems doesn’t come usually on linux servers. Specially systems that use XAMPP for running php and maria db or mysql.

There is an easy fix for it, you just need to download this zip: timezone_2018e_posix

After downloading extract the contents of the zip file, this contains mysql time zone tables.

Press Control/Command + A then Control/Command + C to copy all files.

then go to the directory XAMPP is installed.

Open mysql folder then data folder then mysql folder and press Control/Command + V to paste the table files copied in previous step.

Restart mysql server.

Voila! Its fixed!

Happy coding!

Share This Story, Chhose Your Platform!

Why work from home is
becoming the new norm

  February 27th, 2021

The constant quarantine amidst the coronavirus pandemic has led to most businesses adapting to a remote work from home lifestyle.

Learn More

Top 5 Problems Artificial Intelligence Can Solve in Logistics

  February 27th, 2021

By Ashish Goyal Artificial Intelligence has hit the global world by storm. Nearly every sector has been under the influence of technologies by AI.

Learn More

PayPal Express with Payflow API for WooCommerce

  February 27th, 2021

By Ashish Goyal Artificial Intelligence has hit the global world by storm. Nearly every sector has been under the influence of technologies by AI.

Learn More