[Zope-DB] Zope MySQL error message

Matthew T. Kromer matt@zope.com
Tue, 12 Feb 2002 16:16:53 -0500

BlueDopamine@aol.com wrote:

> Hi, I'm pretty new to Zope and MySQL and I have some problems yet....
> I tried to put new data rows into our MySQL database via the Z MySQL 
> Database Connection /  Z SQL Method.
> When I test the Z SQL Method I get the following error-code - table 
> and column names altered to dummy names here:
> Error, _mysql_exceptions.OperationalError: (1136, "Column count 
> doesn't match value count at row 1")
> SQL used:
> insert ignore into dummy(silly_id, silly1, silly2, silly3, silly 4, 
> silly 5, silly6, silly7, silly8, silly9, silly10, silly11, silly12, 
> silly13, silly14)values('5000','','','','','','',''  
> '','','','','','',  '')

It looks to me like you're trying to insert into 14 silly arguments but 
only providing 13 nulls. (or there is a comma missing)

Matt Kromer
Zope Corporation  http://www.zope.com/