日期:2014-05-16  浏览次数:20747 次

v9 安装模块出现 1064错误
贴出错误代码 请各位大虾解救 谢谢 

MySQL Query : ?INSERT INTO `v9_module` (`module`, `name`, `url`, `iscore`, `version`, `description`, `setting`, `listorder`, `disabled`, `installdate`, `updatedate`) VALUES ('machine', '终端日志', 'machine/', 0, '1.0', '终端日志', '', 0, 0, '2012-01-09', '2012-01-09')
MySQL Error : 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 '?INSERT INTO `v9_module` (`module`, `name`, `url`, `iscore`, `version`, `descr' at line 1
MySQL Errno : 1064
Message : 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 '?INSERT INTO `v9_module` (`module`, `name`, `url`, `iscore`, `version`, `descr' at line 1

------解决方案--------------------
你的INSERT之前有个不可见字符。

直接复制下面语句执行。

INSERT INTO `v9_module` (`module`, `name`, `url`, `iscore`, `version`, `description`, `setting`, `listorder`, `disabled`, `installdate`, `updatedate`) VALUES ('machine', '终端日志', 'machine/', 0, '1.0', '终端日志', '', 0, 0, '2012-01-09', '2012-01-09')