UCenter Home 错误

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.

哪位大哥帮帮忙！谢谢！

执行下面的SQL

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

复制代码