diff options
| author | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2011-11-07 20:58:57 -0300 |
|---|---|---|
| committer | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2011-11-07 20:58:57 -0300 |
| commit | cbdc2d7fd1a0d9748e4f08462a343b15454c1b6f (patch) | |
| tree | 8635e56e434b392e6ab3d2e5a5d42ee43ff94575 | |
| parent | 60fbbbefa82927bc3c2c2f18344037bdfa78495e (diff) | |
| download | askbot-cbdc2d7fd1a0d9748e4f08462a343b15454c1b6f.tar.gz askbot-cbdc2d7fd1a0d9748e4f08462a343b15454c1b6f.tar.bz2 askbot-cbdc2d7fd1a0d9748e4f08462a343b15454c1b6f.zip | |
hopefully fixed the sphinx conf
| -rw-r--r-- | askbot/search/sphinx/sphinx.conf | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/askbot/search/sphinx/sphinx.conf b/askbot/search/sphinx/sphinx.conf index 7ff44604..cdf0f004 100644 --- a/askbot/search/sphinx/sphinx.conf +++ b/askbot/search/sphinx/sphinx.conf @@ -25,12 +25,13 @@ source src_askbot INNER JOIN \ ( \ SELECT MAX(id) as id, question_id \ - FROM question_revision \ + FROM askbot_postrevision \ + WHERE revision_type = 1 \ GROUP BY question_id \ ) \ AS mqr \ ON q.id=mqr.question_id \ - INNER JOIN question_revision AS qr ON qr.id=mqr.id \ + INNER JOIN askbot_postrevision AS qr ON qr.id=mqr.id \ LEFT JOIN \ ( \ SELECT GROUP_CONCAT(answer_current.text SEPARATOR '. ') AS text, \ @@ -42,12 +43,13 @@ source src_askbot INNER JOIN \ ( \ SELECT MAX(id) as id, answer_id \ - FROM answer_revision \ + FROM askbot_postrevision \ + WHERE revision_type = 2 \ GROUP BY answer_id \ ) \ AS mar \ ON mar.answer_id = a.id \ - INNER JOIN answer_revision AS ar ON ar.id=mar.id \ + INNER JOIN askbot_postrevision AS ar ON ar.id=mar.id \ WHERE a.deleted=0 \ ) \ AS answer_current \ |