Column count doesn't match value count

[meisi]

hi,

hat jemand von euch schonmal folgende MySQL Fehlermeldung erhalten, obwohl die Anzahl der VALUE Werte exakt der Anzahl der Felder entspricht??

ca. 3000 Inserts laufen fehlerfrei und dann kommt plötzlich : "Column count doesn't match value count "

[Stuck Mojo]

Und wie lautet der besagte Query?

Gruss
Jan

[meisi]

ok ... kurzer Ausschnitt ...

(mysql): INSERT INTO tb_order ( order_index_ID, FK_customer_index_ID, FK_customer_country_index_ID, FK_shipment_country_index_ID, FK_shipment_index_ID, FK_payment_index_ID, FK_order_status_index_ID, FK_shipment_tax_index_ID, FK_payment_tax_index_ID, order_ID, currency, invoice_company, invoice_gender, invoice_surname, invoice_forename, invoice_street, invoice_postcode, invoice_city, invoice_country, ip, provider, shipment_name, shipment_cost, shipment_tax, shipment_tax_cost, shipment_tax_shortcut, payment_name, payment_cost, payment_tax, payment_tax_cost, payment_tax_shortcut, customer_discount, cash_discount, bonuscode_discount, shipment_company, shipment_gender, shipment_surname, shipment_forename, shipment_street, shipment_postcode, shipment_city, shipment_country, shipment_phone, order_date, tax_ID, invoice, trash ) VALUES ( '4209', '1859', '1', '1', '2', '1', '3', '4', '4', NULL, 'EUR', 'xxx', NULL, 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', '80.248.199.163', NULL, 'UPS-Standard', '43.5', '0', '0', 'MwSt', 'Nachnahme', '0', '0', '0', 'MwSt', '0', '0', '0', 'xxx', NULL, 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', '', '2003-06-17-14:59:53', NULL, NULL, 'N' )

personenbezogene Daten hab ich ausge"x"ed

[Stuck Mojo]

Ist das auch definitiv ein Query, der "flöten" geht, oder warum hast du "Ausschnitt" geschrieben? Mal grob überflogen passt die Anzahl nämlich tatsächlich...