Search not working in wpforo - DOUBLE value is out of range - How-to and Troubleshooting - wpForo 2.0 https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/ Discussion Board en-US Wed, 13 May 2026 06:21:54 +0000 wpForo 60 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10622 Wed, 02 Aug 2017 00:35:44 +0000 thank you!

]]> How-to and Troubleshooting - wpForo 2.0 AccessibleJapan https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10622 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10588 Tue, 01 Aug 2017 10:58:17 +0000 You can change it in website cPanel > phpMyAdmin database manager:

https://wpforo.com/wp-content/uploads/2017/08/wpForo-Search-Error-Double-Value-fix-change-collation.png

]]> How-to and Troubleshooting - wpForo 2.0 Robert https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10588 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10561 Mon, 31 Jul 2017 03:24:47 +0000 I am having the same issues.

How do you change the encoding?

I only get an error if the search word is in the title of the post.  It works fine if the keyword is in the post body...

]]> How-to and Troubleshooting - wpForo 2.0 AccessibleJapan https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10561 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10490 Wed, 26 Jul 2017 20:20:40 +0000 In case anyone comes across this issue, I resolved it by changing the Encoding for the following two tables from utf8mb4 to utf8, and Collation from utf8mb4_unicode_520_ci to utf8_general_ci. 

We are running MySQL  5.7.19. The issue seems to be related to using Boolean mode on utf8mb4 encoded tables with columns using utf8mb4_unicode_520_ci collation.

HTH

]]> How-to and Troubleshooting - wpForo 2.0 arzoum https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-10490 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8209 Tue, 21 Mar 2017 14:31:40 +0000 Unfortunately, switching themes does not resolve this issue for us.

Warning: mysqli_query(): (22003/1690): DOUBLE value is out of range in '((match `wp-original`.`t`.`title` against ('discuss*' in boolean mode)) + (match `wp-original`.`p`.`title` against ('discuss*' in boolean mode)))' in /var/www/public/wp-includes/wp-db.php on line 1877

WordPress database error:

SELECT p.`postid`, t.`topicid`, t.`private`, t.`status`, t.`forumid`, p.`userid`, t.`title`, p.`created`, p.`body`, MATCH(t.`title`) AGAINST('discuss*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('discuss*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('discuss*' IN BOOLEAN MODE) AS matches FROM `wp_wpforo_posts` p INNER JOIN `wp_wpforo_topics` t ON t.`topicid` = p.`topicid` WHERE ( MATCH(t.`title`) AGAINST('discuss*' IN BOOLEAN MODE) OR MATCH(p.`title`, p.`body`) AGAINST('discuss*' IN BOOLEAN MODE) ) ORDER BY MATCH(t.`title`) AGAINST('discuss*') + MATCH(p.`title`) AGAINST('discuss*') + MATCH(p.`body`) AGAINST('discuss*') DESC, MATCH(t.`title`) AGAINST('discuss*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('discuss*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('discuss*' IN BOOLEAN MODE) DESC LIMIT 15

]]> How-to and Troubleshooting - wpForo 2.0 arzoum https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8209 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8179 Tue, 21 Mar 2017 07:14:44 +0000 In my case changing the wordpress theme resolved the issue. I was using the Sahifa theme before. 

]]> How-to and Troubleshooting - wpForo 2.0 Josephino https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8179 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8174 Tue, 21 Mar 2017 02:14:31 +0000 Hi,

Was this ever resolved?

I have the exact same issue. This is the query that fails when you try to search the forum:

SELECT p.`postid`, t.`topicid`, t.`private`, t.`status`, t.`forumid`, p.`userid`, t.`title`, p.`created`, p.`body`, MATCH(t.`title`) AGAINST('discussion*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('discussion*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('discussion*' IN BOOLEAN MODE) AS matches FROM `wp_wpforo_posts` p INNER JOIN `wp_wpforo_topics` t ON t.`topicid` = p.`topicid` WHERE ( MATCH(t.`title`) AGAINST('discussion*' IN BOOLEAN MODE) OR MATCH(p.`title`, p.`body`) AGAINST('discussion*' IN BOOLEAN MODE) ) ORDER BY MATCH(t.`title`) AGAINST('discussion*') + MATCH(p.`title`) AGAINST('discussion*') + MATCH(p.`body`) AGAINST('discussion*') DESC, MATCH(t.`title`) AGAINST('discussion*' IN BOOLEAN MODE) + MATCH(p.`title`) AGAINST('discussion*' IN BOOLEAN MODE) + MATCH(p.`body`) AGAINST('discussion*' IN BOOLEAN MODE) DESC LIMIT 15

Server is being hosted on DigitalOcean and managed by ServerPilot. It's using MySQL 5.7. Here are screenshots of the two tables used in the above query:

http://d.pr/i/35DP/22YJFvLs

http://d.pr/i/mwEI/2ooareSy

Maybe it's the Collation/Encoding used in the table?

 

]]> How-to and Troubleshooting - wpForo 2.0 arzoum https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/paged/2/#post-8174 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5504 Thu, 03 Nov 2016 20:10:40 +0000 How-to and Troubleshooting - wpForo 2.0 Robert https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5504 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5500 Thu, 03 Nov 2016 18:08:05 +0000 Any ideas what's going on there? I would really like to get the forum set up by december and we still have a lot of work to do.

]]> How-to and Troubleshooting - wpForo 2.0 Josephino https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5500 RE: Search not working in wpforo - DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5465 Tue, 01 Nov 2016 18:26:03 +0000 Thank you for your quick reply. Here is the info from the dashboard:

Web Server / PHPApache
MySQL Version5.6.30
PHP Max Post Size128M
PHP Max Upload Size128M
PHP Memory Limit512M
PHP DateTime ClassAvailable

Inmotion hosting is taking care of hosting. Their Power plan to be exact http://www.inmotionhosting.com/business-hosting. Hope this helps.

]]> How-to and Troubleshooting - wpForo 2.0 Josephino https://wpforo.com/community/how-to-and-troubleshooting-2/search-not-working-in-wpforo-double-value-is-out-of-range/#post-5465