Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

use thinking sphinxs error #80

Open
archonwang opened this issue May 5, 2016 · 1 comment
Open

use thinking sphinxs error #80

archonwang opened this issue May 5, 2016 · 1 comment

Comments

@archonwang
Copy link
Contributor

when I bundle rake index , occured an error. How can I fix it? Thanks so much.

the error information is

[root@jira redmine]# bundle exec rake ts:index RAILS_ENV=production
Generating configuration to /opt/redmine/config/production.sphinx.conf
Sphinx 2.2.10-id64-release (2c212e0)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/opt/redmine/config/production.sphinx.conf'...
WARNING: key 'enable_star' was permanently removed from Sphinx configuration. Refer to documentation for details.
indexing index 'issue_core'...
ERROR: index 'issue_core': id is not a valid attribute name.
total 0 docs, 0 bytes
total 0.004 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'issue'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

@archonwang
Copy link
Contributor Author

by the way, I used mysql and rails 4.2
and in the conf file I found SQL that

sql_query = SELECT SQL_NO_CACHE issues.id * 2 + 0 AS id, issues.subject AS subject, issues.id AS sphinx_internal_id, 'Issue' AS sphinx_internal_class, 0 AS sphinx_deleted, issues.id AS id, issues.status_id AS status_id, issues.project_id AS project_id FROM issues WHERE (issues.id BETWEEN $start AND $end) GROUP BY issues.id, issues.subject, issues.id, issues.id, issues.status_id, issues.project_id ORDER BY NULL

I doubt the sql is wrong in mysql... anyone could tell me how to solve it? Thanks so much.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant