Dvbbs.php info: MySQL Query Error
The URL Is: http://localhost/upgrade.php?
Errno: 1054
Error: Unknown column 'groupface' in 'where clause'
SQL: select id,appusername from dv_group_name where groupface='' or groupface is null

问题描述：dvbbs2.0 升级到dvbbs2.0++ 时，出现这个错误 。

这种类似的错误（缺少数据表字段）不只一次，是不是升级到dvbbs2.0++需要增加一些表字段？

有没有完整的数据库脚本来添加这些字段？

求助动网的各位高手！！Thank you so much!

Dvbbs.php info: MySQL Query Error
The URL Is:?http://localhost/index.php?
Errno: 1054
Error: Unknown column 'u.posttimelimit' in 'field list'
SQL: Select /*!40001 SQL_CACHE */ u.userid,u.username,u.userpassword,u.useremail,u.userpost,u.posttimelimit,u.usertopic,u.usersex,u.userface,u.userwidth,u.userheight,u.joindate,u.lastlogin,u.userlogins,u.lockuser,u.userclass,u.usergroupid,u.usergroup,u.userwealth,u.userep,u.usercp,u.userpower,u.userbirthday,u.userlastip,u.userdel,u.userisbest,u.userhidden,u.usermsg,u.ischallenge,u.usermobile,u.titlepic,u.usertitle,u.truepassword,u.usertoday,u.userupfiledate,u.usermoney,u.userticket,u.followmsgid,u.vip_startime,u.vip_endtime,u.userfav,o.id,o.actforip as getcode,o.boardid,o.ip,o.lastimebk,o.browser,o.usergroupid as nowgroupid From dv_user u,dv_online o Where u.userid=o.userid And u.userid=1
You Can Get Help In:?http://p.dvbbs.net

还有这个错误是 没有执行upgrade.php升级程序之后（不能执行成功），然后导入数据，打开首页，出现这个错误。

数据库脚本是dvbbs2.0备份的。

在dv_user表中确实没有字段posttimelimit

mysql> desc dv_user;
+----------------+---------------------+------+-----+---------+----------------

| Field???????? | Type?????????????? | Null | Key | Default | Extra

+----------------+---------------------+------+-----+---------+----------------

| userid??????? | int(11)??????????? | NO? | PRI | NULL?? | auto_increment

| username????? | varchar(50)??????? | NO? | MUL |??????? |

| userpassword? | varchar(32)??????? | NO? |??? |??????? |

| useremail???? | varchar(255)?????? | YES | MUL | NULL?? |

| userpost????? | int(11) unsigned?? | NO? | MUL | 0????? |

| usertopic???? | int(11) unsigned?? | NO? |??? | 0????? |

| usersign????? | varchar(255)?????? | YES |??? | NULL?? |

| usersex?????? | tinyint(3) unsigned | NO? |??? | 0????? |

| userface????? | varchar(255)?????? | YES |??? | NULL?? |

| userwidth???? | int(11) unsigned?? | NO? |??? | 0????? |

| userheight??? | int(11) unsigned?? | NO? |??? | 0????? |

| userim??????? | text?????????????? | YES |??? | NULL?? |

| joindate????? | int(10) unsigned?? | NO? | MUL | 0????? |

| lastlogin???? | int(10) unsigned?? | NO? | MUL | 0????? |

| userlogins??? | int(11) unsigned?? | NO? |??? | 0????? |

| userviews???? | int(11) unsigned?? | NO? |??? | 0????? |

| lockuser????? | tinyint(3) unsigned | YES |??? | NULL?? |

| userclass???? | varchar(20)??????? | YES |??? | NULL?? |

| usergroup???? | varchar(50)??????? | YES |??? | NULL?? |

| userwealth??? | int(11) unsigned?? | NO? | MUL | 0????? |

| userep??????? | int(11) unsigned?? | NO? |??? | 0????? |

| usercp??????? | int(11) unsigned?? | NO? |??? | 0????? |

| userpower???? | int(11) unsigned?? | NO? |??? | 0????? |

| userdel?????? | int(11) unsigned?? | NO? |??? | 0????? |

| userisbest??? | int(11) unsigned?? | NO? |??? | 0????? |

| usertitle???? | varchar(50)??????? | YES |??? | NULL?? |

| userbirthday? | int(11) unsigned?? | NO? | MUL | 0????? |

| userquesion?? | varchar(50)??????? | YES |??? | NULL?? |

| useranswer??? | varchar(50)??????? | YES |??? | NULL?? |

| userlastip??? | varchar(30)??????? | YES |??? | NULL?? |

| userphoto???? | varchar(255)?????? | YES |??? | NULL?? |

| userfav?????? | varchar(255)?????? | YES |??? | NULL?? |

| userinfo????? | text?????????????? | YES |??? | NULL?? |

| usersetting?? | varchar(255)?????? | YES |??? | NULL?? |

| usergroupid?? | int(11) unsigned?? | NO? | MUL | 0????? |

| userhidden??? | tinyint(3) unsigned | NO? |??? | 0????? |

| titlepic????? | varchar(50)??????? | YES |??? | NULL?? |

| usermsg?????? | varchar(100)?????? | YES |??? | NULL?? |

| ischallenge?? | tinyint(3) unsigned | NO? |??? | 0????? |

| usermobile??? | varchar(20)??????? | YES |??? | NULL?? |

| truepassword? | varchar(20)??????? | YES |??? | NULL?? |

| usertoday???? | varchar(250)?????? | YES |??? | NULL?? |

| userisava???? | tinyint(3) unsigned | NO? |??? | 0????? |

| useravasetting | text?????????????? | YES |??? | NULL?? |

| usermoney???? | int(11) unsigned?? | NO? |??? | 0????? |

| userticket??? | int(11) unsigned?? | NO? |??? | 0????? |

| followmsgid?? | varchar(128)?????? | YES |??? | NULL?? |

| vip_startime? | int(10) unsigned?? | NO? |??? | 0????? |

| vip_endtime?? | int(10) unsigned?? | NO? | MUL | 0????? |

| passport????? | varchar(50)??????? | YES |??? | NULL?? |

| userupfiledate | int(10) unsigned?? | YES |??? | NULL?? |

| userhonor???? | varchar(255)?????? | YES |??? | NULL?? |

+----------------+---------------------+------+-----+---------+----------------

52 rows in set (0.00 sec)

动网的高手们，怎么处理，有没有dv2.0++所有增加字段的脚本。只有插入这些字段才能弥补这个错误。

在我从dvbbs2.0导入数据的过程中，有很多数据库脚本错误。希望动网的高手们重视这点。

可以进后台吗？先在后台修复一下数据库。

1、执行upgrade.php升级程序，就会升级数据库。

２、2.0的dv_user里没有这个字段posttimelimit，新建一个试试，类型：int(11)，默认数值为0——其实用不着这样做的，执行一下upgrade.php就OK了。

升级成功了

我的需要在表dv_admin_name加个字段 groupface

而且先要导入数据后才能升级 因为升级后改变了一些表的结构

您导入旧的数据表，就得重新升级一次数据库。

其实执行upgrade.php就是为了升级版本号和数据库的。

楼主坛子是什么语言的？？