针对4.0升级到4.1不完全的解决方案！

最近很多会员在升级4.0到4.1的时候，升级是成功了
不过执行相关操作的时候就会出现很多的Mysql error，是由于升级不完全造成的。

下面给出解决方法

去系统设置

数据库升级

依此执行下列语句，一次执行一句(注意：执行过程中如果出错不要理会，继续执行下一个！)

1. DELETE FROM cdb_sessions;
   
2. ALTER TABLE cdb_sessions TYPE=HEAP;
   
3. 
   
4. DELETE FROM cdb_settings WHERE variable='avatarext';
   
5. REPLACE INTO cdb_settings (variable, value) VALUES ('bdaystatus', 1);
   
6. REPLACE INTO cdb_settings (variable, value) VALUES ('maxspm', 0);
   
7. REPLACE INTO cdb_settings (variable, value) VALUES ('rewritestatus', 0);
   
8. REPLACE INTO cdb_settings (variable, value) VALUES ('watermarkquality', 80);
   
9. REPLACE INTO cdb_settings (variable, value) VALUES ('boardlicensed', 0);
   
10. REPLACE INTO cdb_settings (variable, value) VALUES ('regfloodctrl', 0);
    
11. REPLACE INTO cdb_settings (variable, value) VALUES ('modworkstatus', 0);
    
12. REPLACE INTO cdb_settings (variable, value) VALUES ('maxmodworksmonths', 3);

复制代码

1. ALTER TABLE cdb_announcements ADD INDEX timespan (starttime, endtime);

复制代码

1. ALTER TABLE cdb_threads ADD subscribed TINYINT(1) NOT NULL AFTER attachment;

复制代码

1. ALTER TABLE cdb_subscriptions DROP PRIMARY KEY, ADD PRIMARY KEY (tid, uid), DROP email, ADD lastpost int(10) UNSIGNED NOT NULL AFTER tid;

复制代码

1. ALTER TABLE cdb_usergroups ADD allowanonymous TINYINT(1) NOT NULL DEFAULT '0' AFTER allowcusbbcode;

复制代码

1. ALTER TABLE cdb_forums ADD allowanonymous TINYINT(1) NOT NULL DEFAULT '0' AFTER allowimgcode;

复制代码

1. ALTER TABLE cdb_advertisements CHANGE targets targets TEXT NOT NULL;

复制代码

1. ALTER TABLE cdb_orders CHANGE amount amount int(10) UNSIGNED NOT NULL DEFAULT '0';

复制代码

1. ALTER TABLE cdb_paymentlog CHANGE amount amount INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE netamount netamount INT(10) UNSIGNED NOT NULL DEFAULT '0';

复制代码

1. ALTER TABLE cdb_ratelog CHANGE reason reason CHAR(40) NOT NULL;

复制代码

1. ALTER TABLE cdb_threadsmod ADD expiration int(10) unsigned NOT NULL default '0' AFTER dateline, ADD status tinyint(1) NOT NULL default '0' AFTER action;

复制代码

1. ALTER TABLE cdb_threadsmod DROP PRIMARY KEY, ADD INDEX (tid , dateline), ADD INDEX (expiration ,status);

复制代码

1. DELETE FROM cdb_stylevars WHERE variable='maintablespace';

复制代码

1. UPDATE cdb_stylevars SET substitute='98%' WHERE styleid=1 AND variable='tablewidth';

复制代码

Discuz! info: MySQL Query Error

User: kulai
Time: 2006-4-22 1:33am
Script: /forum/post.php

SQL: SELECT email FROM cdb_subscriptions WHERE uid<>'1' AND tid='1912' AND lastnotify<'1145554435'
Error: Unknown column 'email' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

根据你的步骤，还是没办法解决问题。。。。但还是感谢！

其他人怎样？

非常感谢，依照上面的方法，我的问题解决了。

決解了一部份問題，無法發新帖的問題比較嚴重~  一發新帖就給偶下面的字~

Discuz! info: MySQL Query Error

Time: 2006-6-30 2:54pm
Script: /post.php

SQL: INSERT INTO cdb_posts (fid, tid, first, author, authorid, subject, dateline, message, useip, invisible, anonymous, usesig, htmlon, bbcodeoff, smileyoff, parseurloff, attachment)
VALUES ('104', '2557', '1', 'engine', '7', 'ee', '1151650483', 'e', '218.160.87.52', '0', '0', '', '0', '-1', '-1', '', '0')
Error: Unknown column 'anonymous' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

[ 本帖最后由 pinguo 于 2006-6-30 14:55 编辑 ]

程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

請問以那一個版本的正确的程序文件?

升級問題多多啊~

搞得天暈地轉了~

这个字符真是搞死人了

支持，谢谢楼主

如果照这些升级下来.数据库会不会有问题呀.我数据太大.不敢尝试.