Unsupported Screen Size: The viewport size is too small for the theme to render properly.

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

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Error: 1136, Column Count Doesn't Match Value Count

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • #9717
      materix
      Member

      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)

    • #21812
      TomBez
      Member
      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?

    • #21813
      materix
      Member

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

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

    • #21814
      peterlaursen
      Participant

      @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?

    • #21815
      Ritesh
      Member

      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?

    • #21816
      materix
      Member

      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.

    • #21817
      peterlaursen
      Participant

      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?

    • #21818
      peterlaursen
      Participant

      Actually I made a FAQ out of it!

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

Viewing 7 reply threads
  • You must be logged in to reply to this topic.