分页出错

| 当我尝试为Feed中的元素设置分页时,出现此错误:
ActiveRecord::StatementInvalid in Videos#feed_display

Showing /rubyprograms/dreamstill/app/views/videos/feed_display.html.erb where line #6 raised:

SQLite3::SQLException: only a single result allowed for a SELECT that is part of an expression: SELECT  \"timeline_events\".* FROM \"timeline_events\" WHERE (SELECT timeline_events.* FROM timeline_events
                                       WHERE ((actor_type = \'User\' AND actor_id IN (SELECT followed_id FROM relationships WHERE follower_id = 2)) AND ((secondary_subject_type = \'Video\' AND subject_type <> \'Profile\' AND secondary_subject_id NOT IN (SELECT id FROM videos WHERE user_id = 2)) OR (secondary_subject_type = \'User\' AND secondary_subject_id <> 2) OR (secondary_subject_type = \'nil\') OR (subject_type = \'Profile\' AND secondary_subject_id NOT IN (SELECT id FROM videos WHERE user_id = 2) AND subject_id NOT IN (SELECT id FROM profiles WHERE user_id = 2))))
                                       ORDER BY timeline_events.created_at DESC) LIMIT 10 OFFSET 0
这是什么意思,我该如何解决?     
已邀请:
子查询之一返回多个结果。可以通过在子查询中添加Distinct或限制1来解决此问题。我将使用firefox插件\“ Sqlite Manager \”来测试此查询。     

要回复问题请先登录注册