Question

discuz的mysql数据库升级

用PHP,MYSQL,PHPMYADMIN做discuz论坛很麻烦,所以本人就下了一个老版本的easydiscuz因为里边的东西都是集成的,而且都是一起安装,不需要花很多时间配置,但是安装下来的是discuz论坛4.0.0版的,现在想升级到5.0.0
可是出现了这样的状况:
Discuz! info: MySQL Query Error

Time: 2008-6-17 9:32pm
Script: /Bbs/member.php

SQL: SELECT m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw,
m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset,
m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5,
m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus, m.editormode, m.customshow
FROM cdb_members m WHERE uid='1'
Error: Unknown column 'm.xspacestatus' in 'field list'
Errno.: 1054

Similar error report has beed dispatched to administrator before.
高手教教我,
其实知道是mysql数据库没有升级,但是就是不知道mysql数据库怎么升级

Answer 1

Unknown column 'm.xspacestatus' in 'field list'

这句话是说没有xspacestatus这个字段，属于sql语句错误