首页 / 浏览问题 / 桌面GIS / 问题详情
idestop链接mysql不成功
9EXP 2018年04月16日
先看报错信息:

[09:27:17] Failed Exec strSQL : Create Table test.SmRegister(SmDatasetID INT NOT NULL primary key,SmDatasetName VarChar(64) NOT NULL,SmTableName VarChar(64) NOT NULL,SmIndexTableName VarChar(64) NOT NULL,SmSubTableName VarChar(64),SmParentID INT DEFAULT 0 NOT NULL,SmIsSub Char(1),SmDatasetType INT DEFAULT 0 NOT NULL,SmRecordCount INT DEFAULT 0 NOT NULL,SmLeft Double DEFAULT 0 NOT NULL,SmRight Double DEFAULT 0 NOT NULL,SmTop Double DEFAULT 0 NOT NULL,SmBottom Double DEFAULT 0 NOT NULL,SmIndexType Double DEFAULT 1 NOT NULL,SmIndexLevel INT DEFAULT 0 NOT NULL,SmIndexLeft Double DEFAULT 0 NOT NULL,SmIndexRight Double DEFAULT 0 NOT NULL,SmIndexTop Double DEFAULT 0 NOT NULL,SmIndexBottom Double DEFAULT 0 NOT NULL,SmMinZ Double DEFAULT 0 NOT NULL,SmMaxZ Double DEFAULT 0 NOT NULL,SmDtVersion INT DEFAULT 0 NOT NULL,SmOption INT,SmEncType INT DEFAULT 0 NOT NULL,SmDescription VarChar(256),SmExtInfo VarChar(2048),SmToleRanceFuzzy Double DEFAULT 0 NOT NULL,SmToleranceDAngle Double DEFAULT 0 NOT NULL,SmToleranceNodeSnap Double DEFAULT 0 NOT NULL,SmToleranceSmallPolygon Double DEFAULT 0 NOT NULL,SmToleranceGrain Double DEFAULT 0 NOT NULL,SmMaxGeometrySize INT DEFAULT 0 NOT NULL,SmOnceFetchCount INT DEFAULT 4096 NOT NULL,SmOptimizeCount INT DEFAULT 100000 NOT NULL,SmOptimizeRatio Double DEFAULT 0.6 NOT NULL,SmCreateTime TIMESTAMP(6) NOT NULL,SmLastUpdate TIMESTAMP(6),SmCreator VarChar(32) DEFAULT ' ' NOT NULL, SmThumb BLOB,SmProjectInfo LONGBLOB) ENGINE = MyISAM-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 '(6) NOT NULL,SmLastUpdate TIMESTAMP(6),SmCreator VarChar(32) DEFAULT ' ' NOT NUL' at line 1

[09:27:17] 创建数据源“127.0.0.1_test”失败。

将本sql 复制到mysql执行,问题可以定位 到  

                SmCreateTime TIMESTAMP(6) NOT NULL               ,
                SmLastUpdate TIMESTAMP(6)                        ,

TIMESTAMP 指定长度后报错,去掉指定长度后,就可以!mysql 版本是 service version :5.5.56 mysql communtiy server<GPL>  该问题谁能该解决一下?

1个回答

您好,错误提示是版本的原因,iDesktop只支持mysql 5.6以上的版本
9,127EXP 2018年04月16日
...