MySQLdb insert fails on one table

[Carsten Haese]

On Fri, 2007-06-01 at 11:48 -0400, Sells, Fred wrote:
> INSERT INTO valid_individuals (fname,lname,alias,email) VALUES (%s,%s,%s,%s)
> [['xxxx', 'yyyy', 'zzzzz', 'aaaaaa']]
> 
> this function works fine for several other tables, but on this one I get no
> errors and there is nothing in the table.  If I run the equivalent insert on
> the command line, it's just fine.

This usually indicates that the table is transaction-aware (e.g. storage
mechanism InnoDB versus MyISAM) and you're not committing your
transaction, so the transaction gets rolled back when your connection is
closed.

HTH,

-- 
Carsten Haese
http://informixdb.sourceforge.net