谁来帮帮我1.5升级2.0后首页1054错误

MySQL Error
Message: MySQL Query Error
SQL: SELECT album.albumname, album.friend, space.username, space.name, space.namestatus, main.* FROM uchome_pic main LEFT JOIN uchome_album album ON album.albumid=main.albumid LEFT JOIN uchome_space space ON space.uid=main.uid WHERE 1 AND main.hot >= '3' ORDER BY main.dateline desc LIMIT 0,28
Error: Unknown column 'main.hot' in 'where clause'
Errno.: 1054
Click here to seek help.
地址www.woween.cn/home

怎么办啊。。。~~

执行下面的SQL语

1. ALTER TABLE `uchome_pic` ADD `hot` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0';

复制代码

谢谢你。。我试试。。

又出现这个错误
MySQL Error
Message: MySQL Query Error
SQL: SELECT main.*, field.* FROM uchome_blog main LEFT JOIN uchome_blogfield field ON field.blogid=main.blogid WHERE 1 AND main.hot >= '3' AND main.friend='0' ORDER BY main.dateline desc LIMIT 0,6
Error: Unknown column 'main.hot' in 'where clause'
Errno.: 1054
Click here to seek help.

搞定了又出新问题了
MySQL Error
Message: MySQL Query Error
SQL: UPDATE uchome_space SET `doingnum`='0' WHERE `uid`='1'
Error: Unknown column 'doingnum' in 'field list'
Errno.: 1054