-
-
Notifications
You must be signed in to change notification settings - Fork 214
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
[Bug]: The search menu and page doesn't found any content on the page #5209
Comments
@sanslash332 try to go to Preferences, Search, and resave settings. |
thanks @Jimmi08 for the tip. I go to the settings / search menu and save preferences, inclusive edited some of the searchable areas changing things like results displayed per page and other things to force a setting change, but same behavior. Any thing that you search got nothing as a result. Maybe a method to check which mysql query is using the system? Or some other thing that can be bad configured? Thanks |
I can't help more, I had a similar issue, I debugged and I found that relevance is not working for me. |
I can confirm that with the latest GitHub the search function no longer works, English or Dutch makes no difference, PHP Version 8.1.27, e107 Version 2.4.0 (git), MySQL 10.5.24-MariaDB you can test it on https://e107.nl/search screen_search_2024-03-12 101230 |
Go to preferences, Advanced and set developer mode ON. Then select SQL Analysis You should get something like this: Copy the query and put it directly to phpmyadmin. In my case it should found something in pages
getting error: Can't find FULLTEXT index matching the column list Tested in 2.3.3 database - it works, tested in latest github - it doesn't. |
Okay… this is a moderate challenge to fix… Indeed, the search bug was caused by the migration from MyISAM to InnoDB in #4501. We somehow need to |
Just for have more evidence, but its the same bugs that various of you show before: here the query that I've got through the debug system of the page, when search the word "manamon" over the download section. On the site exists a page with exact that name, so the system must found it. SELECT SQL_CALC_FOUND_ROWS d.download_id, d.download_sef, d.download_category, d.download_name, d.download_description, d.download_author, d.download_author_website,
d.download_datestamp, d.download_class, c.download_category_id, c.download_category_name, c.download_category_sef, c.download_category_class, ((1.2 * (MATCH(d.download_name)
AGAINST ('manamon' IN BOOLEAN MODE))) + (0.9 * (MATCH(d.download_url) AGAINST ('manamon' IN BOOLEAN MODE))) + (0.6 * (MATCH(d.download_description) AGAINST
('manamon' IN BOOLEAN MODE))) + (0.6 * (MATCH(d.download_author) AGAINST ('manamon' IN BOOLEAN MODE))) + (0.4 * (MATCH(d.download_author_website) AGAINST
('manamon' IN BOOLEAN MODE)))) AS relevance FROM e107_download AS d LEFT JOIN e107_download_category AS c ON d.download_category = c.download_category_id
WHERE download_active > '0' AND d.download_visible IN (3,0,1,2,253,254,250,251) AND c.download_category_class IN (3,0,1,2,253,254,250,251) AND (MATCH(d.download_name)
AGAINST ('manamon' IN BOOLEAN MODE) || MATCH(d.download_url) AGAINST ('manamon' IN BOOLEAN MODE) || MATCH(d.download_description) AGAINST ('manamon' IN
BOOLEAN MODE) || MATCH(d.download_author) AGAINST ('manamon' IN BOOLEAN MODE) || MATCH(d.download_author_website) AGAINST ('manamon' IN BOOLEAN MODE))
HAVING relevance > 0 ORDER BY relevance DESC , download_datestamp DESC LIMIT 0,10; The system found 0 results, and this error appear on the page: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list Same errors got on phpmyadmin. #1191 - No puedo encontrar índice FULLTEXT correspondiendo a la lista de columnas Well, thanks for all guys; wait to the fix :-) |
For anybody that can't wait to the fix be solved on the code, You can follow the instructions of @Deltik on this comment. It solved the problem for me without changing the database structure. ¡thanks! |
What e107 version are you using?
Latest Github version (just updated)
Bug description
Hello guys. With a few friends we have a production Ready site using e107 since 2015, and recently we've updated from 2.2 to the latest git 2.4.0, and upgraded from php 5.6.40 to 7.4.33, because well... the hosting is deprecating all php below version 7, so we had to update. ANd for future we are planing to upgrade to php8.
We lost some small plugins and other small things during the update process that aren't important, but we found that the search feature isn't working on the new version.
We tried using the search menus and page, but the query didn't found anithing. The site have a lot of content on downloads, forums, news, but the search can't find anythin.
This is the page
https://www.tiflojuegos.com
Is in spanish.
Is something wrong with that plugin? We forget configure something?
All other things works veri fine.
A, is a site for blind people, so... dont take care about the theme; we are using the default bootstrap5. Because our old theme (defianstrap) aren't compatible with php8.
How to reproduce
Expected behavior
That the search feature works. Finding the exact results or similar according with the search.
What browser(s) are you seeing the problem on?
Firefox, Chrome / Brave, Microsoft Edge
PHP Version
7.4.33
The text was updated successfully, but these errors were encountered: