wpForo Search results error: DOUBLE value is out of range - How-to and Troubleshooting https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/ Discussion Board en-US Sun, 15 Mar 2026 14:21:18 +0000 wpForo 60 RE: wpForo Search results error: DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12204 Thu, 09 Nov 2017 03:29:05 +0000 I don't know why or how, but the search page has been working correctly for the past two days.

I haven't changed anything.

At any rate, I'll check back in if the issue returns. Thanks so much for your willingness to review my server settings! That is above and beyond.

Sincerely,

Joe

]]> How-to and Troubleshooting joekotvas https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12204 RE: wpForo Search results error: DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12167 Tue, 07 Nov 2017 15:08:41 +0000 This problem comes from you database configuration. This is a MySQL server configuration issue. We could help you if you send MySQL database access (phpMyAdmin). You can download phpMyAdmin, upload to root, send database login details (DB User and DB password in wp-config.php) and phpMyAdmin URL.

 

]]> How-to and Troubleshooting Robert https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12167 RE: wpForo Search results error: DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12148 Mon, 06 Nov 2017 21:01:48 +0000

Wat is your server MySQL version? Please copy server information from Dashboard > Forums > Dashboard admin page and leave it here.

Sure, here are the details:

Web Server Apache
PHP Version 7.0.24
MySQL Version 5.6.36
PHP Max Post Size 128M
PHP Max Upload Size 128M
PHP Memory Limit 768M
PHP DateTime Class Available

Thanks for looking into this.

]]> How-to and Troubleshooting joekotvas https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12148 RE: wpForo Search results error: DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12139 Mon, 06 Nov 2017 16:44:32 +0000 Wat is your server MySQL version? Please copy server information from Dashboard > Forums > Dashboard admin page and leave it here.

]]> How-to and Troubleshooting Robert https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12139 wpForo Search results error: DOUBLE value is out of range https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12131 Mon, 06 Nov 2017 00:03:44 +0000 I'm getting a warning when I search for "casa." I'm expecting one result, but it does not appear.

Full error: 

Warning: mysqli_query(): (22003/1690): DOUBLE value is out of range in '((match `compar23_clsp`.`t`.`title` against ('casa*' in boolean mode)) + (match `compar23_clsp`.`p`.`title` against ('casa*' in boolean mode)))' in /home/compar23/public_html/wp-includes/wp-db.php on line 1942

URL: https://compartelsp.com/foros/?wpfs=casa

screenshot.png
]]> How-to and Troubleshooting joekotvas https://wpforo.com/community/how-to-and-troubleshooting-2/wpforo-search-results-error-double-value-is-out-of-range/#post-12131