On Aug 12, 2010, at 3:08 PM, Jigal sanders wrote:
According to my profiler, the insert qeury is never executed.
Try fetching profilers with getQueryProfiles(null, true) to include unfinished statements (those with no end time recorded).
It would be good to examine the SQL generated, so you can spot obvious errors. It could be an imbalanced parenthesis or an extra comma or something that would be easy to spot once you see the SQL, not the code that generates the SQL.
You can also copy & paste that generated SQL into your database client tool and see if it gives an error.
Basically, you need to get more diagnostic information about the query. We can stare all day at PHP code that generates SQL without diagnosing the problem.
Regards, Bill Karwin
