|
升級表 pre_forum_post 出錯,請手工執行以下升級語句后,再重新運行本升級程序:
升級SQL語句:
ALTER TABLE pre_forum_post CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', ADD `repid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tid`, CHANGE `subject` `subject` varchar(255) NOT NULL DEFAULT '', ADD `lastupdate` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dateline`, ADD `updateuid` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `lastupdate`, ADD `premsg` text NOT NULL AFTER `updateuid`, CHANGE `useip` `useip` varchar(45) NOT NULL DEFAULT '', CHANGE `position` `position` int(10) unsigned NOT NULL
Error: Duplicate column name 'repid'
Errno.: 1060
手工運行也不行! |
|