Issue information
-
#034543
-
Fixed
-
2.5.0
-
2.5.1
-
2 - Fair
Issue Confirmations
-
Yes (1)No (0)
1
Two small bugs in the Sphinx Template
(Line 65):
Should be:
To this:
(Line 65):
FROM <!--SPHINX_DB_PREFIX-->downloads_files \
Should be:
FROM <!--SPHINX_DB_PREFIX-->downloads_files f \Lines 98/99 should be switched;
LEFT JOIN <!--SPHINX_DB_PREFIX-->downloads_ccontent cc ON (cc.file_id=f.file_id) LEFT JOIN <!--SPHINX_DB_PREFIX-->downloads_files f ON ( c.comment_fid=f.file_id ) \
To this:
LEFT JOIN <!--SPHINX_DB_PREFIX-->downloads_files f ON ( c.comment_fid=f.file_id ) \ LEFT JOIN <!--SPHINX_DB_PREFIX-->downloads_ccontent cc ON (cc.file_id=f.file_id) \
changed version to: 2.5.0,
changed status to: Confirmed - General,
changed severity to: 2 - Fair
The above changes are correct, and lead to no errors in indexer but searchd returns:
WARNING: index 'downloads_comments_main': duplicate attribute name: file_id
WARNING: index 'downloads_comments_delta': duplicate attribute name: file_id
It's probably due to the fact that file_id exists in both ibf_downloads_files and ibf_downloads_ccontent.
Is there any nice way to handle this and avoid this warning (except deleting file_id completely as an attribute for downloads_comments)?
WARNING: index 'downloads_comments_main': duplicate attribute name: file_id
WARNING: index 'downloads_comments_delta': duplicate attribute name: file_id
It's probably due to the fact that file_id exists in both ibf_downloads_files and ibf_downloads_ccontent.
Is there any nice way to handle this and avoid this warning (except deleting file_id completely as an attribute for downloads_comments)?
I recommend opening new reports for different issues. I've opened one for you for this issue you are reporting.
http://community.inv...phinx-warnings/
http://community.inv...phinx-warnings/
1 user(s) are reading this issue
0 members, 1 guests, 0 anonymous users
