sphinx error after update of gitorious. search no more working

[Wiz of Id]

Hello.

Almost a week ago:

- fetched the latest master branch of gitorious

- reinstalled the gem bundle

- run rake db:migrate

- restarted apache

- fixed some minor issues

all worked but the search

Whenever i try to reindex, here's the error and a useless 0 bytes index:

git-user@myserver:~$ cd /var/www/gitorious.host/gitorious && rake ultrasphinx:index RAILS_ENV=production

(in /var/www/gitorious.host/gitorious)

$ indexer --config '/var/www/gitorious.host/gitorious/config/ultrasphinx/production.conf' --rotate --all

Sphinx 0.9.8.1-release (r1533)

Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/var/www/gitorious.host/gitorious/config/ultrasphinx/production.conf'...

indexing index 'main'...

ERROR: index 'main': sql_range_query: Unknown column 'base_tags.name' in 'field list' (DSN=mysql://mysqluser:***@localhost:3306/gitorious_production).

total 0 docs, 0 bytes

total 0.013 sec, 0.00 bytes/sec, 0.00 docs/sec

Index rotated ok

Can't figure out what to do... I did rake db:migrate on top of the gitorious folder when I updated....

[Christian Johansen]

Hi,

Can you try to also regenerate the sphinx configuration? Seems like you have stale database information. `bundle exec rake ultrasphinx:configure`

Christian

--
To post to this group, send email to gito...@googlegroups.com
To unsubscribe from this group, send email to
gitorious+...@googlegroups.com

--
MVH
Christian

[JereKrischel]

try this:

vi /home/git/gitorious/config/ultrasphinx/production.conf
# replace base_tags with tags

bundle exec rake ultrasphinx:index RAILS_ENV=production

[Wiz of Id]

Thank you, just added RAILS_ENV=production to that command and it worked and fixed the issue.

Is there a web page or a document I should have read before asking here?

Thank you again,

Wiz

[Jimit Ndiaye]

'bundle exec rake ultrasphinx:configure' didn't work for me. I had to use JereKrischel 's solution above.