Debugging form submissions that raise warnings on
insertion are quite difficult as there is little to no
information given by MySQLdb regarding the action. It
generally appears when you're sending data of one type
(such as a string) into fields of another type (such as
a date or integer).
Often it's fairly obvious. You have a limited number of
date fields, so make sure you're actually trying to
insert a date at that point. etc. but in massive tables
where the data inputted is even more convoluted
debugging becomes a tedious mess of one-at-a-time
"maybe this one is the problem" debugging.
If MySQLdb would only say what field(s) caused the
warning it would be immensely helpful.
Thanks for the great product! MySQLdb is invaluable!