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 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:


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
viewed69 times
activeLast updated on 18 days ago


Php include at php fusion site
Started by
budje123 - 2 posts
AD banner removes Site banner?
Started by
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
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

Latest Comment Panel
Druid - 7 posts
Incorrect Validation Code
Nomak - 25 posts
Index.php always broken
bobesama - 19 posts
PHP 5.3/6 Comparability Problems
starefossen - 8 posts
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