Notifications
Clear all

[Closed] DOUBLE value is out of range in

3 Posts
2 Users
0 Reactions
538 Views
Posts: 16
Topic starter
(@misiak007)
Eminent Member
Joined: 3 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
dimalifragis
Posts: 2611
Posts: 16
Topic starter
(@misiak007)
Eminent Member
Joined: 3 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