HeitorArgenta
18-Aug-2022, 01:59 PM
Ao tentar converter tabelas do padrão do Dataflex para MySQL encontro esse problema, ERROR 12289, 42000 (1064).
Converting Recnum table: 2, CADPONTO, CADPONTOStart time: 18/08/2022 14:57:42,319
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CADPONTO (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,348
Total time to convert table: 0:0:0:0,029
------------------------------------------------------------
Converting Recnum table: 3, CADPONTOIT, CADPONTOIT
Start time: 18/08/2022 14:57:42,352
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CADPONTOIT (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,357
Total time to convert table: 0:0:0:0,005
------------------------------------------------------------
Converting Recnum table: 253, CODETYPE, Code Maintenance Type Table
Start time: 18/08/2022 14:57:42,361
Creating new table.
ERROR 12289: Erro gen‚rico. HY000 (1101)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]BLOB, TEXT, GEOMETRY or JSON column 'Comment' can't have a default value Table = CodeType (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,366
Total time to convert table: 0:0:0:0,005
------------------------------------------------------------
Converting Recnum table: 254, CODEMAST, Code Maintenance Code Table
Start time: 18/08/2022 14:57:42,369
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CodeMast (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,374
Total time to convert table: 0:0:0:0,005
DataFlex 17.0
MySQL Server 5.7.39
Connector/ODBC 8.0.30
Converting Recnum table: 2, CADPONTO, CADPONTOStart time: 18/08/2022 14:57:42,319
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CADPONTO (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,348
Total time to convert table: 0:0:0:0,029
------------------------------------------------------------
Converting Recnum table: 3, CADPONTOIT, CADPONTOIT
Start time: 18/08/2022 14:57:42,352
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CADPONTOIT (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,357
Total time to convert table: 0:0:0:0,005
------------------------------------------------------------
Converting Recnum table: 253, CODETYPE, Code Maintenance Type Table
Start time: 18/08/2022 14:57:42,361
Creating new table.
ERROR 12289: Erro gen‚rico. HY000 (1101)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]BLOB, TEXT, GEOMETRY or JSON column 'Comment' can't have a default value Table = CodeType (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,366
Total time to convert table: 0:0:0:0,005
------------------------------------------------------------
Converting Recnum table: 254, CODEMAST, Code Maintenance Code Table
Start time: 18/08/2022 14:57:42,369
Creating new table.
ERROR 12289: Erro gen‚rico. 42000 (1064)--[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.39-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1 Table = CodeMast (0), Source = ODBC_DRV.Structure_End.CreateTable
End time: 18/08/2022 14:57:42,374
Total time to convert table: 0:0:0:0,005
DataFlex 17.0
MySQL Server 5.7.39
Connector/ODBC 8.0.30