Search result: Database query error
After upgrading to UNA and all modules Version: 13.1.0
Searching result= Error Database query error. How can i fix it, cron works fine?
Database error in Katolička društvena mreža
Query:
SELECT * FROM `bx_timeline_events` WHERE 1 AND `bx_timeline_events`.`type` ='timeline_common_post' AND `bx_timeline_events`.`status` ='active' AND `bx_timeline_events`.`status_admin` ='active' AND `bx_timeline_events`.`active` ='1' AND MATCH(`bx_timeline_events`.`title`) AGAINST ('SVETI LEOPOLD BOGDAN MANDIĆ') LIMIT 0, 4
Mysql error:
Can't find FULLTEXT index matching the column list
collation_connection:
utf8mb4_unicode_ci
-
Ok, help yourself and God will help you 😃
Solution sql query: ALTER TABLE bx_timeline_events ADD FULLTEXT(title);
-
Hello @Darko !
Glad to hear that you've found that fix but, weirdly, your `bx_timeline_events` table didn't have it after installation (the necessary point exists in the install.sql file of this app).
-
Hello @LeonidS
before the upgrade, I transferred UNA to a new server (nginx), it is possible that this is the cause!
-
Yes, it seems the DB hasn't been transferred properly. I little confused with the table encoding too. It is better to have the utf8mb4_unicode_ci variant.
-
It looks like a bug - https://github.com/unaio/una/issues/4589
This error can happen only when FULLTEXT search is used, for a while you can disable it in Studio > Settings > General > Use operator LIKE for search (recommended for small content)
-
The search result is much more accurate when "Use operator LIKE for search" is turned on.
Thanks guys!
