[Zope-DB] Zope MySQL error message
BlueDopamine@aol.com
BlueDopamine@aol.com
Tue, 12 Feb 2002 16:12:57 EST
--part1_87.1771b1ee.299adf59_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
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','','','','','','','' '','','','','','', '')
I really don't know what the problem is.... I tried to put new data rows
directly to the database via the mysql-prompt and it works without any
problems.
Any ideas how to solve this problem?
Birgit
--part1_87.1771b1ee.299adf59_boundary
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
<HTML><FONT FACE=arial,helvetica><FONT SIZE=2 FAMILY="SANSSERIF" FACE="Arial" LANG="2"><BR>
Hi, I'm pretty new to Zope and MySQL and I have some problems yet....<BR>
<BR>
I tried to put new data rows into our MySQL database via the Z MySQL Database Connection / Z SQL Method.<BR>
<BR>
When I test the Z SQL Method I get the following error-code - table and column names altered to dummy names here:<BR>
<BR>
Error, _mysql_exceptions.OperationalError: (1136, "Column count doesn't match value count at row 1")<BR>
SQL used:<BR>
insert ignore into dummy(silly_id, silly1, silly2, silly3, silly 4, silly 5, silly6, silly7, silly8, silly9, silly10, silly11, silly12, silly13, silly14)values('5000','','','','','','','' '','','','','','', '')<BR>
<BR>
I really don't know what the problem is.... I tried to put new data rows directly to the database via the mysql-prompt and it works without any problems.<BR>
<BR>
Any ideas how to solve this problem? <BR>
<BR>
Birgit</FONT></HTML>
--part1_87.1771b1ee.299adf59_boundary--