zuohaocheng / hudbt

Automatically exported from code.google.com/p/hudbt
GNU General Public License v2.0
14 stars 7 forks source link

种子详情页面 “分类” 报http500 #168

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
分类 (错误如下)

Database Error
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Bookmark.id' in 
'field list'

SQL Query: SELECT `BookmarkedUser`.`id`, `BookmarkedUser`.`username`, 
`BookmarkedUser`.`passhash`, `BookmarkedUser`.`secret`, 
`BookmarkedUser`.`email`, `BookmarkedUser`.`status`, `BookmarkedUser`.`added`, 
`BookmarkedUser`.`last_login`, `BookmarkedUser`.`last_access`, 
`BookmarkedUser`.`last_home`, `BookmarkedUser`.`last_offer`, 
`BookmarkedUser`.`forum_access`, `BookmarkedUser`.`last_staffmsg`, 
`BookmarkedUser`.`last_pm`, `BookmarkedUser`.`last_comment`, 
`BookmarkedUser`.`last_post`, `BookmarkedUser`.`last_browse`, 
`BookmarkedUser`.`last_music`, `BookmarkedUser`.`last_catchup`, 
`BookmarkedUser`.`editsecret`, `BookmarkedUser`.`privacy`, 
`BookmarkedUser`.`stylesheet`, `BookmarkedUser`.`caticon`, 
`BookmarkedUser`.`fontsize`, `BookmarkedUser`.`info`, 
`BookmarkedUser`.`acceptpms`, `BookmarkedUser`.`commentpm`, 
`BookmarkedUser`.`ip`, `BookmarkedUser`.`class`, 
`BookmarkedUser`.`max_class_once`, `BookmarkedUser`.`avatar`, 
`BookmarkedUser`.`uploaded`, `BookmarkedUser`.`downloaded`, 
`BookmarkedUser`.`seedtime`, `BookmarkedUser`.`leechtime`, 
`BookmarkedUser`.`title`, `BookmarkedUser`.`country`, 
`BookmarkedUser`.`notifs`, `BookmarkedUser`.`modcomment`, 
`BookmarkedUser`.`enabled`, `BookmarkedUser`.`avatars`, 
`BookmarkedUser`.`donor`, `BookmarkedUser`.`donated`, 
`BookmarkedUser`.`donated_cny`, `BookmarkedUser`.`donoruntil`, 
`BookmarkedUser`.`warned`, `BookmarkedUser`.`warneduntil`, 
`BookmarkedUser`.`noad`, `BookmarkedUser`.`noaduntil`, 
`BookmarkedUser`.`topicsperpage`, `BookmarkedUser`.`postsperpage`, 
`BookmarkedUser`.`clicktopic`, `BookmarkedUser`.`deletepms`, 
`BookmarkedUser`.`savepms`, `BookmarkedUser`.`support`, 
`BookmarkedUser`.`picker`, `BookmarkedUser`.`stafffor`, 
`BookmarkedUser`.`supportfor`, `BookmarkedUser`.`pickfor`, 
`BookmarkedUser`.`supportlang`, `BookmarkedUser`.`passkey`, 
`BookmarkedUser`.`promotion_link`, `BookmarkedUser`.`uploadpos`, 
`BookmarkedUser`.`forumpost`, `BookmarkedUser`.`downloadpos`, 
`BookmarkedUser`.`clientselect`, `BookmarkedUser`.`signatures`, 
`BookmarkedUser`.`signature`, `BookmarkedUser`.`lang`, 
`BookmarkedUser`.`cheat`, `BookmarkedUser`.`download`, 
`BookmarkedUser`.`upload`, `BookmarkedUser`.`isp`, `BookmarkedUser`.`invites`, 
`BookmarkedUser`.`invited_by`, `BookmarkedUser`.`gender`, 
`BookmarkedUser`.`vip_added`, `BookmarkedUser`.`vip_until`, 
`BookmarkedUser`.`seedbonus`, `BookmarkedUser`.`charity`, 
`BookmarkedUser`.`bonuscomment`, `BookmarkedUser`.`parked`, 
`BookmarkedUser`.`leechwarn`, `BookmarkedUser`.`leechwarnuntil`, 
`BookmarkedUser`.`lastwarned`, `BookmarkedUser`.`timeswarned`, 
`BookmarkedUser`.`warnedby`, `BookmarkedUser`.`sbnum`, 
`BookmarkedUser`.`sbrefresh`, `BookmarkedUser`.`hidehb`, 
`BookmarkedUser`.`showclienterror`, `BookmarkedUser`.`shownfo`, 
`BookmarkedUser`.`pmnum`, `BookmarkedUser`.`school`, `BookmarkedUser`.`showfb`, 
`BookmarkedUser`.`accepttdpms`, `BookmarkedUser`.`color`, `Bookmark`.`id`, 
`Bookmark`.`torrentid`, `Bookmark`.`userid` FROM `hudbt`.`users` AS 
`BookmarkedUser` JOIN `hudbt`.`bookmarks` AS `Bookmark` ON 
(`Bookmark`.`torrentid` = 86296 AND `Bookmark`.`userid` = `BookmarkedUser`.`id`)

Notice: If you want to customize this error message, create 
app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 460 → 
PDOStatement->execute(array)
CORE/Cake/Model/Datasource/DboSource.php line 426 → 
DboSource->_execute(string, array)
CORE/Cake/Model/Datasource/DboSource.php line 670 → 
DboSource->execute(string, array, array)
CORE/Cake/Model/Datasource/DboSource.php line 1255 → 
DboSource->fetchAll(string, boolean)
CORE/Cake/Model/Datasource/DboSource.php line 1116 → 
DboSource->queryAssociation(Torrent, User, string, string, array, array, 
boolean, array, integer, array)
CORE/Cake/Model/Model.php line 2694 → DboSource->read(Torrent, array)
CORE/Cake/Model/Model.php line 1527 → Model->find(string, array)
/var/webroot/hudbt/details.php line 589 → Model->read(null, integer)

Original issue reported on code.google.com by vrqq3...@gmail.com on 30 Jun 2013 at 5:53

GoogleCodeExporter commented 9 years ago
cake缓存没清,清一下cake缓存( cake/app/tmp/cache

Original comment by zuohaoch...@gmail.com on 1 Aug 2013 at 1:49