Limited Time Offer - from RM2.99/month
00
DAYS
01
HOURS
59
MINUTES
31
SECONDS
Get Started
×

Knowledge base

Find information within our custom articles about Hostinger's features
and all information relating to hosting practices.

#1064 - You have an error in your SQL syntax

Modified on:
sql syntax error error in syntax 1064 error

The error 1064 occurs due to MySQL version mismatch. Different versions have different reserved words, which, if they are used by a previous version, causes the error to occur.

The simplest and most effective solution for it is the following: when using phpMyadmin (accessible from your Control Panel), select the "compatibility mode" & select the target database version from the drop down box. That's it! You shouldn't get the same error again.

  • Free Website Builder
  • 99.9% Uptime Guarantee
  • 24/7 Live Support
  • Powerful Control Panel
  • 30-Days Money-Back Guarantee
Limited Time Special Offer!
From
RM
2
99
/mo
Save 90%
Let's go!