If you get
#1064 – 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
or
ERROR 1064 (42000) at line 9: 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
and it’s on or during an insert, verify the table’s fields are the correct length to match the data you’re inserting. I received my errors during an insert with a select substring. Sometimes it’s a comma or an apostrophe.
This did not correct my issue this time, though. This time, I had a field called INOUT, which is aparantly a reserved word/process. I guess that’s what happens when you hack your way around MySQL. If nothing else works, change the field name.