I've recently replaced Acts_as_Ferret with Sphinx in a Rails app, and
I'm quite impressed with the features and speed thus far, but I'm
having a problem. I've encountered the issue on Windows, Ubuntu
Desktop (Hardy) and Ubuntu Server (Hardy). I'm running Ruby 1.8.6, and
I've tried Rails 2.1 and 2.2. I've also tried MySQL 5.0 and 5.1.
Thinking Sphinx is the most recent version from GitHub.
The problem is that TS seems to cause problems when I try to deploy a
new instance of my Rails app. Here are the steps involved in getting
the error:
*I wipe my database with "rake db:drop:all"
*Create the wiki_development, wiki_test and wiki_production
databases from the MySQL command line tool.
*Run "rake db:migrate"
This results in the following error message:
rake aborted!
Mysql::Error: #42S02Table 'wiki_development.articles' doesn't exist:
SHOW FIELDS FROM 'articles'
I'm not surprised that the table doesn't exist, because this error
message pops up when I'm trying to run the migration that's going to
create it!
I can get the migration to work if I:
*Remove the Thinking Sphinx plugin from my vendor/plugins
directory
*Remove the index definitions from my models
Then the migrations run perfectly. Then I put the TS directory back
into the plugin folder, and put the index definitions back into the
models. Then after a quick TS:Index and TS:Start, everything is up and
running. If I had to venture a guess, I'd say TS is trying to
introspect on my model before the migrations have had a chance to run.
This app will (hopefully) be deployed in multiple corporate data
centers, and I'm not going to be the one installing them. I can't, in
good conscience, tell some poor sysadmin that he needs to move a whole
mess of files around, run a migration, then paste code into my models.
The guy would track me down and kill me. Either that, or post my
install instructions on thedailywtf.com for everyone to laugh at.
So, how can I get the migrations to run WITHOUT making the person
installing it rewrite my code every time?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
