MySQLdb insert fails on one table

[Sells, Fred]

thank you! that was it.

I created the table using a create table (select from....

which must have defaulted to InnoDb, now I just create it in a script.

> -----Original Message-----
> From: Carsten Haese [mailto:carsten at uniqsys.com]
> Sent: Friday, June 01, 2007 8:56 AM
> To: Sells, Fred
> Cc: python-list at python.org
> Subject: Re: MySQLdb insert fails on one table
> 
> 
> 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
>