后台删除动态（feed),出现Message: MySQL Query Error，如何解决？

已知UCH2。0，后台删除动态（feed),点下面菜单，出现Message: MySQL Query Error，目前仅备份有UCH1。5的数据，当时升级2。0时备份的，请问如何解决？

点记录：
MySQL Error
Message: MySQL Query Error
SQL: SELECT * FROM uchome_docomment USE INDEX(dateline) WHERE doid IN ('8','7','6','5','4','3','2','1')

ORDER BY dateline
Error: Key 'dateline' doesn't exist in table 'uchome_docomment'
Errno.: 1176
Click here to seek help.


点相册：
MySQL Error
Message: MySQL Query Error
SQL: SELECT COUNT(*) FROM uchome_pic p WHERE 1 AND p.hot>='3'
Error: Unknown column 'p.hot' in 'where clause'
Errno.: 1054
Click here to seek help.

点日志：
MySQL Error
Message: MySQL Query Error
SQL: SELECT COUNT(*) FROM uchome_blog b WHERE 1 AND b.hot>='3'
Error: Unknown column 'b.hot' in 'where clause'
Errno.: 1054
Click here to seek help.

点群组：
MySQL Error
Message: MySQL Query Error
SQL: SELECT main.*,mt.* FROM uchome_tagspace main LEFT JOIN uchome_mtag mt ON mt.tagid=main.tagid WHERE

main.uid='1' ORDER BY mt.threadnum DESC LIMIT 0,20
Error: Unknown column 'mt.threadnum' in 'order clause'
Errno.: 1054
Click here to seek help.

已解决。。。

怎么解决的

数据库表没升级成功

可以根据./data/install.sql
里的SQL重建　添加字段