logo

Cyber Sale

  •  99.9% Uptime
  •  Free SSL Certificate
  •  24/7 Live Support
  •  30-Days Money-Back Guarantee
Get Started

Up To

90

%

OFF

00
DAYS
01
HOURS
25
MINUTES
02
SECONDS
Cyber Sale: Best Web Hosting
From ₹45.00 /Month!
See All Deals
×

Hostinger's Knowledge Base

Find articles and information about features, various troubleshooting guides,
and other technical information related to the Hostinger's services

#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.