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


Print Track
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:
(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.

1 reply

Thanks for the report. We'll issue it right away.
author Mickelvlm
forumSuspected Bugs and Errors - 8
replies2 posts
viewed68 times
activeLast updated on 18 days ago

Related

Php include at php fusion site
Started by
B
budje123 - 2 posts
AD banner removes Site banner?
Started by
D
degre - 6 posts
@Admins/ We can't submit themes on the themes site!
Started by Harly Harly - 5 posts
PANEL SNIPPIT:: Some Site Stats Panel
Started by Craig Craig - 35 posts
Solved: Logs in and logs out again? Site moved.
Started by
1
1click - 11 posts
Updating a PHP-Fusion 7 site to PHP-Fusion 8 on PHP Versions > 5.6
Started by Falk Falk - 1 post

Hot Questions

Druid
Latest Comment Panel
Druid - 7 posts
Basti
N
Incorrect Validation Code
Nomak - 25 posts
B
Index.php always broken
bobesama - 19 posts
starefossen
PHP 5.3/6 Comparability Problems
starefossen - 8 posts
R
You can view all discussion threads in this forum.
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.
Users who participated in discussion: Chan, Mickelvlm