Hmm, I thought I had this working... someone else raised it quite a while ago on the list.
What's the output of 'rake db:migrate --trace'? -- Pat On 31/01/2009, at 1:57 AM, mr_lotd wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
