AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] wpForo Search results error: DOUBLE value is out of range

5 Posts
2 Users
1 Reactions
3,390 Views
Posts: 14
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@joekotvas)
Eminent Member
Joined: 9 years ago
[#5194]

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

4 Replies
Robert
Posts: 10752
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 3 months ago

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


1 Reply
(@joekotvas)
Joined: 9 years ago

Eminent Member
Posts: 14
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

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.


Robert
Posts: 10752
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 3 months ago

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.

 


Posts: 14
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@joekotvas)
Eminent Member
Joined: 9 years ago

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


Share: