Hello. My search results are always empty no matters what text I introduce. Any time I try to search something I can see a new file created in the /cache/_db folder, then I opened the file and manually copy the query in my phpmyadmin, first the query was giving error because some collation diferences, but now I can see the results of the query and how it actually find results. For example I try this:
SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) AS s_pub, COUNT(*) AS count FROM submissions s JOIN publications p ON (p.publication_id = s.current_publication_id) JOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId') JOIN issues i ON (CAST(i.issue_id AS CHAR) = ps.setting_value) JOIN submission_search_objects o ON (s.submission_id = o.submission_id) NATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0 WHERE s.status = 3 AND i.published = 1 AND k0.keyword_text = 'incorporado' AND i.journal_id = 1 GROUP BY o.submission_id ORDER BY count DESC LIMIT 500
And the result was:
However the search in my page shows no results.
Thanks for any help.