Manyou诚邀开发者加盟 | 常见问题
《站长》“开发者特刊”限量赠送		立即免费下载 Discuz!6.1.0正式版
Discuz! 6.1.0使用说明 | 使用手册		Discuz!NT2.5正式版发布
开放源码下载 | 使用手册
Discuz!收费服务内容及价格
《站长》俱乐部各地聚会活动进行中
Discuz!/ECShop 专用官方虚拟主机
论坛游戏插件再开新区 助你在聚新人气		基于Discuz!的免费论坛空间5D6D
《站长》第八期：实战互联网开放平台
12
返回列表 回复 发帖

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
楼主
打印
tT
在某些方面发表于 2005-12-31 09:13 | 只看该作者

求助:我的论坛从2.5升上4.0过程中的第七步出现以下乱码.请问怎么解决!

Discuz! info: MySQL Query Error

Time: 2005-12-31 12:52am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060

An error report has been dispatched to our administrator.
收藏 分享 评分
回复 引用

订阅 TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
沙发
在某些方面发表于 2005-12-31 13:38 | 只看该作者
求助:我的论坛从2.5升上4.0过程中的第七步出现以下乱码.请问怎么解决!

Discuz! info: MySQL Query Error

Time: 2005-12-31 12:52am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060

An error report has been dispatched to our administrator.
回复 引用

TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
藤椅
在某些方面发表于 2005-12-31 16:24 | 只看该作者
?????????????没人帮我??????????
回复 引用

TOP

Comsenz Team

Rank: 12Rank: 12Rank: 12

帖子
3030 
积分
3536 
威望
75  
金币
201 个 
体力
2889  
板凳
ramboo发表于 2005-12-31 17:28 | 只看该作者
在升级程序中巴
  1. DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
  2. DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
  3. CHANGE username username char(15) NOT NULL default '',
  4. CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
  5. CHANGE password password char(32) NOT NULL default '',
  6. CHANGE secques secques char(8) NOT NULL default '',
  7. CHANGE regip regip char(15) NOT NULL default '',
  8. CHANGE lastip lastip char(15) NOT NULL default '',
  9. CHANGE email email char(50) NOT NULL default '',
  10. CHANGE dateformat dateformat char(10) NOT NULL default '',
  11. CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
  12. CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
  13. CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
  14. CHANGE credit credits int(10) NOT NULL,
  15. CHANGE showemail showemail tinyint(1) NOT NULL default '0',
  16. CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
  17. ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
  18. ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
  19. ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
复制代码
去掉，然后重新从这一步运行。
气定则心定，心定则事圆
一人独处时，能超然物外
与人相处时，能和蔼可掬
无所事事时，能语默澄静
处理事务时，能雷厉风行

春风得意时，能淡然坦荡

惊慌失意时，能泰然处之
回复 引用

TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
报纸
在某些方面发表于 2005-12-31 19:24 | 只看该作者
怎么去呀???我是在浏览器中输入http://localhost/aa/upgrade25to4.php升级论坛的第七步出现以下的网页
Discuz! info: MySQL Query Error

Time: 2005-12-31 12:52am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060

An error report has been dispatched to our administrator.


不知哪个地方出了错呀..
回复 引用

TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
地板
在某些方面发表于 2006-1-1 16:31 | 只看该作者
求助:我的论坛从2.5升上4.0过程中的第七步出现以下乱码.请问怎么解决!

Discuz! info: MySQL Query Error

Time: 2005-12-31 12:52am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060

An error report has been dispatched to our administrator.
回复 引用

TOP

Member

Rank: 2

帖子
37 
积分
180 
威望
0  
金币
100 个 
体力
50  
7#
foc发表于 2006-1-1 22:13 | 只看该作者
你的出错 和偶的一样

求救啊
回复 引用

TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
8#
在某些方面发表于 2006-1-3 21:58 | 只看该作者
求助:我的论坛从2.5升上4.0过程中的第七步出现以下乱码.请问怎么解决!

Discuz! info: MySQL Query Error

Time: 2005-12-31 12:52am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
CHANGE username username char(15) NOT NULL default '',
CHANGE adminid adminid TINYINT( 1 ) DEFAULT '0' NOT NULL,
CHANGE password password char(32) NOT NULL default '',
CHANGE secques secques char(8) NOT NULL default '',
CHANGE regip regip char(15) NOT NULL default '',
CHANGE lastip lastip char(15) NOT NULL default '',
CHANGE email email char(50) NOT NULL default '',
CHANGE dateformat dateformat char(10) NOT NULL default '',
CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
CHANGE credit credits int(10) NOT NULL,
CHANGE showemail showemail tinyint(1) NOT NULL default '0',
CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Duplicate column name 'pmsound'
Errno.: 1060
回复 引用

TOP

Comsenz Team

Rank: 12Rank: 12Rank: 12

帖子
3030 
积分
3536 
威望
75  
金币
201 个 
体力
2889  
9#
ramboo发表于 2006-1-4 09:20 | 只看该作者
原帖由 ramboo 于 2005-12-31 17:28 发表
在升级程序中巴[code]DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identify ...
在升级程序中去阿。
打开upgrade25to4.php找到上面的语句，去掉，然后从这一步开始运行就可以了。
气定则心定，心定则事圆
一人独处时，能超然物外
与人相处时，能和蔼可掬
无所事事时，能语默澄静
处理事务时，能雷厉风行

春风得意时，能淡然坦荡

惊慌失意时，能泰然处之
回复 引用

TOP

Newbie

Rank: 1

帖子
15 
积分
12 
威望
0  
金币
0 个 
体力
50  
10#
在某些方面发表于 2006-1-4 13:01 | 只看该作者
ramboo 你好..
我改了你所说的..可是第七步出现这样的了:
Discuz! info: MySQL Query Error

Time: 2006-1-4 4:57am
Script: /aa/upgrade25to4.php

SQL: ALTER TABLE cdb_members
CHANGE extracredit extcredits1 int(10) NOT NULL,
ADD extcredits5 int(10) NOT NULL AFTER extcredits1,
ADD extcredits4 int(10) NOT NULL AFTER extcredits1,
ADD extcredits3 int(10) NOT NULL AFTER extcredits1,
ADD extcredits2 int(10) NOT NULL AFTER extcredits1,
ADD extgroupids char(60) NOT NULL AFTER groupexpiry,
ADD avatarshowid int(10) UNSIGNED NOT NULL default '0' AFTER extcredits5,
ADD extcredits8 int(10) NOT NULL AFTER extcredits5,
ADD extcredits7 int(10) NOT NULL AFTER extcredits5,
ADD extcredits6 int(10) NOT NULL AFTER extcredits5,
ADD pageviews mediumint(8) UNSIGNED NOT NULL AFTER digestposts,
ADD oltime smallint(6) UNSIGNED NOT NULL AFTER digestposts,
DROP INDEX username,
ADD UNIQUE (username),
ADD INDEX (email)
Error: Unknown column 'groupexpiry' in 'cdb_members'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

An error report has been dispatched to our administrator.
回复 引用

TOP

12
返回列表