有问题了 第四步怎么也过不去
正在进行 PWBlog 4.3.2 To VeryCMS 2.0/PWBlog 5.0 升级的第四步(共六步)
请耐心等待... Query Error: CREATE TABLE pw_advt (id int(8) unsigned NOT NULL auto_increment,subject varchar(100) character set gbk NOT NULL,hits int(10) NOT NULL,width int(4) NOT NULL,height int(4) NOT NULL,postdate int(10) NOT NULL,type tinyint(1) NOT NULL,advdata text NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM;
The URL Is:
http://blog.361.cn/upto.php?action=creattableMySQL Server Error:
You have an error in your SQL syntax near 'character set gbk NOT NULL,hits int(10) NOT NULL,width int(4) NOT NULL,height in' at line 1 ( 1064 )
You Can Get Help In:
http://www.phpwind.net正在进行 PWBlog 4.3.2 To VeryCMS 2.0/PWBlog 5.0 升级的第四步(共六步)
请耐心等待... Query Error: CREATE TABLE pw_blogvote (id mediumint(8) unsigned NOT NULL auto_increment,subject varchar(255) NOT NULL,content mediumtext NOT NULL,type tinyint(1) unsigned NOT NULL,votedate int(10) unsigned NOT NULL,_ifshow tinyint(1) unsigned NOT NULL,maxnum tinyint(3) NOT NULL,_ifview tinyint(1) NOT NULL default '0',PRIMARY KEY (id),KEY type (type,_ifshow),KEY _ifview (_ifview)) ENGINE=MyISAM;
The URL Is:
http://blog.361.cn/upto.php?action=creattableMySQL Server Error:
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1 ( 1064 )
You Can Get Help In:
http://www.phpwind.net
这和你的mysql数据库设置,引起的原因是:一、版本过低,可考虑升级至较高版本;二、mySQL设置不合理,缺少字符集支持;
方法:一、升级mysql,或者重新配置;二、把升级的SQL里面的 character set gbk ,ENGINE=MyISAM等语句全部删除
by greenrock
[ 此贴被greenrock在2006-09-18 09:31重新编辑 ]