[Zope-DB] Zope MySQL error message
Matthew T. Kromer
Tue, 12 Feb 2002 16:16:53 -0500
> 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)
Zope Corporation http://www.zope.com/