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.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Suspected Bugs and Errors - 8
  5. V8 search "entire site" loading too much data

V8 search "entire site" loading too much data

Asked Modified Viewed 986 times
Back to Forum Index Previous Topic Next Topic
Print
M
Mickelvlm
M
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions
asked
Junior Member

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:
Code Download source
(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/PHPFusion/PHPFusio...de.php#L36
https://github.com/PHPFusion/PHPFusio...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.
Edited by Mickelvlm on 02-07-2019 12:30,
0 replies

1 post

C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

Thanks for the report. We'll issue it right away.
0 replies

Category Forum

Suspected Bugs and Errors - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 1 post
  • Votes 0 votes
  • Topic users 2 members

2 participants

C
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
M
M
  • Junior Member, joined since
  • Contributed 10 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet