Question

安装phpcms2008到最后的时候出现数据库错误帮忙看下啊

MySQL Query : CREATE TABLE `phpcms_admin` ( `userid` mediumint(8) unsigned NOT NULL, `username` char(20) NOT NULL, `allowmultilogin` tinyint(1) unsigned NOT NULL default '0', `alloweditpassword` tinyint(1) unsigned NOT NULL default '0', `editpasswordnextlogin` tinyint(1) unsigned NOT NULL default '0', `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`)) TYPE=MyISAM DEFAULT CHARSET=utf8
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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 1
MySQL Errno : 1064
Message : MySQL Query Error
这是错误的代码

Answer 1

看看CMS对数据库版本的要求吧！还有数据库的默认charset 最好也改成utf-8！