從首頁點選某個社群或類別後,再點選左方的「依作者瀏覽」,會出現內部系統錯誤?(Beta2問題)

問題編號: 
Q10
A: 

此問題原因為資料庫缺少部分欄位, 請手動以以下 步驟解決:

#cd $mysql_home/bin
#mysql -u dspace -p<Password>

$mysql_home為MySQL安裝的目錄;dspace為登入的帳號,<Password>為該帳號的密碼(需把 "<" 與 ">" 去掉)。登入後,請在mysql>提示符號後執行以下指令:

alter view `dspace`.`communityitemsbyauthor` as select `dspace`.`community2item`.`community_id` 
AS community_id`,`dspace`.`itemsbyauthor`.* from (`dspace`.`itemsbyauthor` join 
`dspace`.`community2item`) where (`dspace`.`itemsbyauthor`.`item_id` = `community2item`.`item_id`);

alter view `dspace`.`collectionitemsbyauthor` as select `dspace`.`collection2item`.`collection_id` 
AS collection_id`,`dspace`.`itemsbyauthor`.* from (`dspace`.`itemsbyauthor` join 
`dspace`.`collection2item`) where (`dspace`.`itemsbyauthor`.`item_id` = `dspace`.`collection2item`.`item_id`);

執行後,若出現

Query OK, x rows affected (xxxxx sec)%%

即表示更新成功

問題類型: