MySQL error 1064 - #42000 You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to use...

Problem

The MySQL error 1064 is a broad range error message that deals with the MySQL database.  It will be seen in many different modules and contexts:

"MySQL error 1064 - #42000 You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to use near '...' at line 1

Solution

Contact Technical Support and send the errorLog.log file from the machine where this error appeared.