Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

V8 search "entire site" loading too much data

I have this V8 site with a somewhat big database. Searching the individual categories like "Articles" is no problem, but when searching the entire site, this happens:
i.imgur.com/PQu2TMD.png

I managed to track the problem to the forum search include, where $fieldsvar (which is used in both queries, effectively turning them into monsters) yields this:
CodeDownload  
(thread_subject LIKE '% %' || post_message LIKE '% %')



This is supposed to include my search words, but it doesn't. As far as I can tell, the following two lines of code are the issues:

https://github.com/php-fusion/PHP-Fus...de.php#L36
https://github.com/php-fusion/PHP-Fus...de.php#L31

I don't know why they're there, but they've been around since 8.00.19 on Github, and removing them fixes the issue. They reset the $swords-array which is used in the search_querylike()-function, rendering the latter a (useless) monster in the forum and every other big table.
Thanks for the report. We'll issue it right away.
Thread Information
Author
Replies
2 posts
Views
164 times
Last Post
Last updated on 3 months ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Chan, Mickelvlm