[Closed] DOUBLE value is out of range in

How-to and Troubleshooting

Last Post by misiak007 2 years ago

3 Posts

2 Users

0 Reactions

392 Views

RSS

Posts: 16

misiak007

Topic starter

Oct 24, 2022 3:06 pm

(@misiak007)

Eminent Member

Joined: 2 years ago

Hi,

after I am searching for "changelog"

https://www.itcred.eu/forum-sk-cz/?wpfs=changelog

I get WP warning. It is because I have forum search and sidebar search ... I think.
Warning: mysqli_query(): (22003/1690): DOUBLE value is out of range in xxxxxxx /itcred.eu/web/wp-includes/wp-db.php on line 2169

Thanks for help

2 Replies

Posts: 2615

dimalifragis

Oct 24, 2022 3:16 pm

(@dimalifragis)

Famed Member

Joined: 4 years ago

https://wpforo.com/community/how-to-and-troubleshooting-2/remove-search-entire-post-search-type-and-replace-with-search-tags-2/

Posts: 16

misiak007

Topic starter

Oct 24, 2022 3:54 pm

(@misiak007)

Eminent Member

Joined: 2 years ago

Thank you for the link, but I did not see the solution there and also the posts are from year 2020.

So what should I do to fix it?

"I changed it to utf8-general-ci and everything is working again" - this should help, but on other side another user wrote

"I changed my database settings with the following command but I still get the error in search:
ALTER DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;"

Thanks for help