FAQ
1.Q:升级错误,MySQL 提示: Duplicate column name 'khtime' ,请返回
A:估计你安装过这个插件了,你可以不执行sql升级,直接覆盖相应的文件即可。
如果接着出现
SQL: UPDATE [Table]clubhorse SET buyuser = '', horsename = '', horsenation = '未知', horseinfo = '未知', buytime = '0' WHERE buytime < '1181560284' AND buyuser != ''
Error: Table 'a10111824144.[Table]clubhorse' doesn't exist
这样的错误,那么需要再执行相应的sql文件中除“ALTER TABLE `cdb_memberfields` ADD `khtime` INT( 11 ) DEFAULT '0' NOT NULL;”外余下SQL升级语句。
按你说的方法修改了、但跑马场还是显示这样的错误
Discuz! info: MySQL Query Error
User: 苍狼
Time: 2007-9-14 2:34am
Script: /m/club_index.php
SQL: UPDATE [Table]clubhorse SET buyuser = '', horsename = '', horsenation = '未知', horseinfo = '未知', buytime = '0' WHERE buytime < '1189708446' AND buyuser != ''
Error: Table 'tggh.[Table]clubhorse' doesn't exist
Errno.: 1146 |