升级2.0时，按提示删除了数据库和数据表，但是升级失败，现在恢复1.5备份出现问题。MySQL Error
Message: MySQL Query Error
SQL: CREATE TABLE uchome_doing ( doid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', username varchar(15) NOT NULL default '', from varchar(20) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message text NOT NULL, ip varchar(20) NOT NULL default '', replynum int(10) unsigned NOT NULL default '0', mood smallint(6) NOT NULL default '0', PRIMARY KEY (doid), KEY uid (uid,dateline), KEY dateline (dateline)) TYPE=MyISAM AUTO_INCREMENT=9
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 'from varchar(20) NOT NULL default '', dateline int(10) unsigne
Errno.: 1064
Click here to seek help
请问该怎么做？ |
