Hopefully fixed now. I did not test with InnoDB though, but added some code that would make migration 4 pass for you and fallback to simple title match for the search.
Evgeny (
2011-05-12 15:01:39 -0500
)edit
Can I use MySQL InnoDB?
Looks like only question and answer tables need fulltext index, which is not supported by InnoDB. What if I'm going to use a search engine for search of questions and answers anyway, can I not apply Migration 4 and use InnoDB? I have a lot of other tables in InnoDB and really don't want to fall back to MyISAM.
Comments
2 Answers
As of version 0.6.86, it is possible, but still InnoDB does not support text search properly.
To completely fix this issue, we'll need to support some external search library, such as solr, sphinx, etc.
At the moment, with askbot the best options are either transition your other app to PostgresQL or with a quick fix on our part - accept loss of text search support - until we work with a specialized search library. (e.g. Django Haystack)
Comments
If I'm willing to lose full text search, would the app still work for other functions under InnoDB? I'm already using Haystack and Solr, so I can provide search on my own page.
codedigger (
2011-05-11 14:39:38 -0500
)edit
Reliable Askbot Hosting
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.
create your Q&A site30 days free trial
Stats
Asked: 2011-05-11 13:49:42 -0500
Seen: 195 times
Last updated: Jan 12 '12
