abahgat / redmine_didyoumean

A Redmine plugin to search for possible duplicates when users are about to open new issues.
Other
68 stars 45 forks source link

use thinking sphinxs error #80

Open archonwang opened 8 years ago

archonwang commented 8 years ago

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 commented 8 years ago

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.