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

Bug In Database Import Wizard

forums forums SQLyog SQLyog: Bugs / Feature Requests Bug In Database Import Wizard

This topic contains 0 replies, has 0 voices, and was last updated by  peterlaursen 6 years, 1 month ago.

  • Author
    Posts
  • #12874

    treadmill
    Member

    Found a new bug in the Database Import Wizard, when importing Access database. If you look at the error below, it does not enclose the value E-4 in single quotes.

    Can this be fixed as a matter of urgency.



    SQLyog Job Agent v10.42 Copyright(c) Webyog Inc. All Rights Reserved.

    Job started at Thu Dec 06 16:35:26 2012

    DBMS Information: ACCESS



    Importing table schema: MnExport... Successful...

    Importing table schema: MnFuels... Successful...

    Importing table schema: MnInstallations... Successful...

    Importing table schema: MnInstallationsYearly... Successful...

    Importing table data: MnExport...

    2194 rows transferred!

    Successful...



    Importing table data: MnFuels...

    ERROR: 1054, Unknown column 'E' in 'field list'

    Table:MnFuels

    Sql:REPLACE INTO `chpqa_dukes`.`MnFuels` (`RefNo` ,`SchemeRef` ,`Version` ,`FuelID` ,`Year` ,`ElectricalFuel` ,`HeatFuel` ,`TotalFuel` ,`ElectricalFuelQA` ,`HeatFuelQA` ,`FuelElsewhere` ,`CVNotes` ,`FuelComments` ,`ElectricalFuelold` ,`HeatFuelold` ,`ElectricalPercent` ,`HeatPercent` ,`TFI` ,`ChangeDate`) VALUES (137.0, 'A', -2001.0, 1, 2001, 0.0, 0.0, 1272.182, 690.030555675916, 582.151444324084, E-4, NULL, 'From 2000 fuel data. BW 19/04/02', 0.0, 0.0, 0.0, 0.0, 1272.182, '2012-05-01 15:03:43');

    Check C:UsersKevinAppDataRoamingSQLyogsja.log for complete error details.



    ERROR: Import aborted...

    Check C:UsersKevinAppDataRoamingSQLyogsja.log for complete error details.



    Total time taken - 31 sec(s)



  • #34027

    peterlaursen
    Participant

    Can you provide an Access database where this is reproducible? As small as possible as long as reproducible.

    Also please tell: what is the datatype for the column (in both Access and MySQL)? It could be the data type mapping the ODBC drvier does that causes this.

You must be logged in to reply to this topic.