in reply to Debugging DBD/SQL syntax error

Many of the best practices for posting a question have been gathered in jeffa's epic tutorial, How (Not) To Ask A Question.
Especially relevant are these sections:

For your particular quandary, take the size of your intended post as an indicator that you have more trimming to do. While keeping the same occurrence of the error, can you trim the program down:

  1. To just contain 1 INSERT?
  2. With just 10 names, place holders and variables?
  3. In a command-line (non-CGI) form?
  4. That needs no external data?
As a bonus, you will often find that the exercise of reducing your program to post-able size will uncover the bad code, and make the solution obvious.