Documentation

You have an error in your SQL syntax

WordPress database error: [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 ‘1’ at line 1]

This is error can occur when a server error occurs during a migration, usually because something goes wrong when creating the SQL for a database migration. Often times this is caused by a large single record in a database table, usually the wp_options table.

Sometimes this error can be resolved by increasing the the ‘Max Request Size’ slider in the Settings tab of the plugin. Other times you may have to increase the ‘max_allowed_packet’ setting in your MySQL configuration – usually a my.cnf setting.