帝国cms安装 mysql支持错误_帝国CMS安装时 mysql出错。

建立数据表:em_enewsad完毕......YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'\'\',`url`textNOTNULL,`pic_wi...

建立数据表: em_enewsad 完毕......

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 '\'\', `url` text NOT NULL, `pic_width` int(10) unsigned NOT NULL

default \'0\'' at line 1

CREATE TABLE `em_enewsad` ( `adid` int(10) unsigned

NOT NULL auto_increment, `picurl` varchar(255) NOT NULL default \'\', `url` text

NOT NULL, `pic_width` int(10) unsigned NOT NULL default \'0\', `pic_height`

int(10) unsigned NOT NULL default \'0\', `onclick` int(10) unsigned NOT NULL

default \'0\', `classid` smallint(5) unsigned NOT NULL default \'0\', `adtype`

tinyint(3) unsigned NOT NULL default \'0\', `title` varchar(100) NOT NULL

default \'\', `target` varchar(10) NOT NULL default \'\', `alt` varchar(120) NOT

NULL default \'\', `starttime` date NOT NULL default \'0000-00-00\', `endtime`

date NOT NULL default \'0000-00-00\', `adsay` varchar(255) NOT NULL default

\'\', `titlefont` varchar(14) NOT NULL default \'\', `titlecolor` varchar(10)

NOT NULL default \'\', `htmlcode` text NOT NULL, `t` tinyint(3) unsigned NOT

NULL default \'0\', `ylink` tinyint(1) NOT NULL default \'0\', `reptext` text

NOT NULL, PRIMARY KEY (`adid`), KEY `classid` (`classid`), KEY `t` (`t`))

TYPE=MyISAM

这是错误提示，我试过默认的表前缀和数据库名字。都错。

展开