forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error: 1136, Column Count Doesn't Match Value Count
- This topic is empty.
-
AuthorPosts
-
-
June 2, 2006 at 9:33 am #9717materixMember
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)
-
June 2, 2006 at 12:31 pm #21812TomBezMembermaterix 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?
-
June 2, 2006 at 1:54 pm #21813materixMember
“C:ProgrammerSQLyog Enterprisesja.log” contains the same error messages.
But I have figured it out. I changed my regional settings from danish to english.
-
June 4, 2006 at 7:26 pm #21814peterlaursenParticipant
“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?
-
June 5, 2006 at 7:11 am #21815RiteshMember
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?
-
June 6, 2006 at 3:35 pm #21816materixMember
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.
-
June 6, 2006 at 4:13 pm #21817peterlaursenParticipant
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?
-
June 6, 2006 at 4:29 pm #21818peterlaursenParticipant
Actually I made a FAQ out of it!
-
-
AuthorPosts
- You must be logged in to reply to this topic.