Search Error When Using Searching Entire Posts Option - How-to and Troubleshooting - wpForo 2.0

RE: Search Error When Using Searching Entire Posts Option

peterd — Thu, 19 Nov 2020 15:16:53 +0000

FYI... I upgraded to PHP 7.3.24 on SiteGround and the problem went away. I also tried going one step further to release 7.4.12. Unfortunately, this caused other issues with my site not even starting. For now, I'm gong to stay on 7.3.24, since it looks like the issue doesn't occur here. My sense is that there's still issues with PHP compatibility between the plugin and the host.

RE: Search Error When Using Searching Entire Posts Option

peterd — Wed, 18 Nov 2020 15:19:55 +0000

I would like to further clarify your comment. When you say: 'We don't think that the issue is caused by the higher version of PHP". Does that mean you've either tested it or seen it running on the latest release of PHP? Don't misinterpret my comment as being critical. I, and others, go through this often, where we get into a situation where each party says it's the other party's problem. It would be good if others could comment on whether their PHP hosting environment is causing similar issues or not. This could save us time in trying to understand if it really is an issue or not with running on the current release of PHP on SiteGround. Again, always appreciate your great support. You've been a big help to a lot of us!

RE: Search Error When Using Searching Entire Posts Option

Alvina — Tue, 17 Nov 2020 11:43:29 +0000

@peterd,

They suggested I downgrade from PHP 7.3.24 to 7.1.33. When I did this the error went away!!! Running a lower release of PHP is not ideal. Any thoughts on whether there's an issue with PHP 7.3.XX running with wpForo?

We don't think that the issue is caused by the higher version of PHP.

Please contact your hosting server support and ask them to check this issue with this version PHP. Probably there should change some settings in the PHP version that have this issue.

RE: Search Error When Using Searching Entire Posts Option

peterd — Sat, 14 Nov 2020 19:01:59 +0000

I used the plugin 'Insert Headers and Footers' and was successful to deactivate the option of Search Entire Posts. Here's the code that I placed in the Footer:

Unfortunately, I still have the problem that both the sidebar search widget, and the search in the header defaults to 'Search Entire Posts' initially. This causes the warning to show. Is there a way to have the initial search defaults use 'Search Titles Only'?

I did follow-up with your suggestion to contact SiteGround support. They indicated that the error message related to different PHP versions used for my website and the website plugin. They suggested I downgrade from PHP 7.3.24 to 7.1.33. When I did this the error went away!!! Running a lower release of PHP is not ideal. Any thoughts on whether there's an issue with PHP 7.3.XX running with wpForo?

RE: Search Error When Using Searching Entire Posts Option

Alvina — Fri, 13 Nov 2020 11:36:27 +0000

@peterd,

I could use a bit more direction on what I should be asking them. Could you provide some advice on what I should be asking them to look at, which could potentially be causing the error?

Just provide a Warning message that you provided in your first post.

Also, is there a way to temporarily disable this search option? I'm Ok in the short term if we can use all the other search options except for the 'Searching Entire Posts' Option.

Try the following JS code:

jQuery("option").remove();

The code should be added in the current active theme JS files.

RE: Search Error When Using Searching Entire Posts Option

peterd — Thu, 12 Nov 2020 12:20:50 +0000

We're currently running on SiteGround, which is a very popular hosting service for Wordpress. I could use a bit more direction on what I should be asking them. Could you provide some advice on what I should be asking them to look at, which could potentially be causing the error? Also, is there a way to temporarily disable this search option. I'm Ok in the short term if we can use all the other search options except for the 'Searching Entire Posts' Option. Thanks again for your help.

RE: Search Error When Using Searching Entire Posts Option

Alvina — Thu, 12 Nov 2020 07:55:41 +0000

@peterd,

Then we've suggested you to contact your hosting server support and let them know about the issue.

RE: Search Error When Using Searching Entire Posts Option

peterd — Wed, 11 Nov 2020 14:34:50 +0000

It's a new installation of wpForo, so we're currently running version 1.8.4.

RE: Search Error When Using Searching Entire Posts Option

Alvina — Wed, 11 Nov 2020 06:46:11 +0000

Hi @peterd,

Please let us know the version you use? If it, not the latest please update to the latest wpForo version(v.1.8.4) and check again.

Search Error When Using Searching Entire Posts Option

peterd — Mon, 09 Nov 2020 14:54:29 +0000

I can successfully use Search on all of the Search Types expect 'Search Entire Posts'. I get the following error when trying to do this:

Warning: mysqli_query(): (22003/1690): DOUBLE value is out of range in '((match `db9dd6w7ev6y6f`.`p`.`title` against ('+pictures*' in boolean mode)) + (match `db9dd6w7ev6y6f`.`p`.`body` against ('+pictures*' in boolean mode)))' in /home/customer/www/bookoncapecod.com/public_html/wp-includes/wp-db.php on line 2033

This is a very similar message that I found in this forum post:
https://wpforo.com/community/general-forums-bug-reports/search-showing-error/#post-47322

I tried using the recommendation in this post, but Search still fails when trying to use Search Entire Posts. I've seen some other posts that suggest updating the database Collation value. Similar to this post:
https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/

Any advice on how to resolve this error?

Attached is my current server configuration, which is quite current.

Server-Config.jpg