Hi, Can you try to also regenerate the sphinx configuration? Seems like you have stale database information. `bundle exec rake ultrasphinx:configure`
Christian On Fri, Jul 1, 2011 at 12:22, Wiz of Id <[email protected]> wrote: > 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.... > > -- > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > -- MVH Christian -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected]
