Search not showing results

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:

submission_id journal_id i_pub s_pub count
171 1 2021-10-08 20:12:41 2021-10-08 2

However the search in my page shows no results.

Thanks for any help.

1 Like

Hi @RoWEN,

Can you please indicate what specific version of OJS you’re using (e.g. 3.3.0-8)?

-Roger
PKP Team

Hello. My OJS v is 3.2.1.1. Thanks

Hi @RoWEN,

Do you have records in your submission_search_* tables?

Also, I’d try manually rebuilding indices from the CLI, with:

php tools/rebuildSearchIndex.php

Have you tried this approach?

Best,
Janio