Question

帝国CMS安装时 mysql出错。

建立数据表: 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
这是错误提示，我试过默认的表前缀和数据库名字。都错。

Answer 1

你空间使用的MYSQL版本和CMS系统所需要MYSQL版本不同，退回安装首页选择正确的MYSQL版本。。。。