IPS\Db\Exception: DOUBLE value is out of range in

[DawPi]

Something isn't right. I have this problem on mine almost stock board and 4.7.0 Beta 3:

SELECT main.*, ((MATCH(index_title) AGAINST ('test' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('test' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ibbd_core_search_index` AS `main` WHERE ( index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR index_class='IPS\downloads\File\PendingVersion' OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR index_class='IPS\cms\Pages\PageItem' ) AND MATCH(index_content,index_title) AGAINST ('test' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET('m1',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('cm',index_permissions) OR FIND_IN_SET('s3',index_permissions) OR FIND_IN_SET('s5',index_permissions) OR FIND_IN_SET('s6',index_permissions) OR FIND_IN_SET('c4',index_permissions) OR FIND_IN_SET('c5',index_permissions) OR FIND_IN_SET('cm4',index_permissions) OR FIND_IN_SET('cm5',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25
IPS\Db\Exception: DOUBLE value is out of range in '(((match `*dbname*`.`main`.`index_title` against ('test' in boolean mode)) * 5) + (match `*dbname*`.`main`.`index_content`,`*dbname*`.`main`.`index_title` against ('test' in boolean mode)))' (1690)
#0 //system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 [internal function]: IPS\Db\_Select->rewind()
#2 //system/Content/Search/Mysql/Query.php(1326): iterator_to_array(Object(IPS\Db\Select))
#3 //applications/core/modules/front/search/search.php(746): IPS\Content\Search\Mysql\_Query->search('test', NULL, 17, 'or')
#4 //applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#5 //system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#6 //system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#7 //index.php(13): IPS\_Dispatcher->run()
#8 {main}

 

What is going on?

 

 

P.s. previously topic was added in wrong section. Please delete it.

Edited May 27, 2022 by DawPi

[Marc]

Where are you seeing this? What action is being performed at the time?

[Daniel F]

This would be a server configuration issue, the error you are seeing indicates that the MySQL full text score calculation is outside of the range allowed by the MySQL server.

Was the MySQL server updated recently or did you move to another server?  
I would take a look at the table to see if the table or the index is broken.

[DawPi]

2 hours ago, Marc Stridgen said:

Where are you seeing this? What action is being performed at the time?

Search operation. 🙂

2 hours ago, Daniel F said:

Was the MySQL server updated recently or did you move to another server?  
I would take a look at the table to see if the table or the index is broken.

Nope, just upgrade to 4.7. 🙂

Nope, everything is fine with SQL:

[Marc]

I have created a ticket for you on this, so we can look further into the issue

[DawPi]

Thanks, all access details were provided in the CA.