Error: 1136, Column Count Doesn't Match Value Count

[materix]

Hi.

I am trying to import a simple table from an odbc-datasource. The table contains 4 columns and 12 rows.

But when I run the “Migration Toolkit” I get this error message and nothing is imported.

Other tables give the same error while some tables are possible to import.

Any suggestions?

Code:

SQLyog Job Agent Version 5.12
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Job started at Fri Jun 02 10:29:31 2006

DBMS Information: N/ODBC
Importing table schema: Moms… Successful…

Importing table data: Moms…

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

ERROR: 1136, Column count doesn't match value count at row 1

Table:Moms
Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

12 rows transferred!

Successful…

Total time taken – 0 sec(s)

[TomBez]

materix wrote on Jun 2 2006, 11:33 AM:

Code:

Check C:ProgrammerSQLyog Enterprisesja.log for complete error details.

And what is the output in this file?

[materix]

“C:ProgrammerSQLyog Enterprisesja.log” contains the same error messages.

But I have figured it out. I changed my regional settings from danish to english.

[peterlaursen]

@materix

“I changed my regional settings from danish to english.”

Could I ask you to elaborate a little bit!

Actually we would like to understand this issue …

WHERE and WHAT EXACTLY did you change?

[Ritesh]

Yes, I would love to get more details about this. We would probably be able to fix it if know the real issue.

What is your source DB?

[materix]

Hi.

The problem has something to do with how float values are displayed.

I figured this out when I noticed that I had problems with all tables containing columns with floating values. The source is a Navision-DB.

But when I changed the “Regional Settings” in “Control Panel” from Danish to English, everything started working perfectly.

As you know the number a million is written like this with regional settings set to english “1,000,000.00”. When regional settings is set to danish it is written “1.000.000,00”.

All the best.

[peterlaursen]

Now ..

neither MySQL or SQLyog read these regional settings at all. So it must be the ODBC-driver that does – and generates the data stream accordingly. Actually that is probably a nice feature when importing to a localized MS-Excel for instance. But not pretty nice when importing to MySQL – as it does not handle it!

There is no setting available with the driver itself?

[peterlaursen]

Actually I made a FAQ out of it!

http://webyog.com/faq/17_111_en.html

[Author]

Posts