Getting this error when using search on my boards

[Mutterz108]

SELECT main.*, ((MATCH(index_title) AGAINST ('breeze' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('breeze' 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 `core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' 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') ) ) AND MATCH(index_content,index_title) AGAINST ('breeze' 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('c121',index_permissions) OR FIND_IN_SET('c1',index_permissions) OR FIND_IN_SET('c2',index_permissions) OR FIND_IN_SET('c12532',index_permissions) OR FIND_IN_SET('cm1',index_permissions) OR FIND_IN_SET('cm2',index_permissions) OR FIND_IN_SET('cm12532',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25
IPS\Db\Exception: DOUBLE value is out of range in '(match `cruise`.`main`.`index_title` against ('breeze' in boolean mode)) * 5 + (match `cruise`.`main`.`index_content`,`cruise`.`main`.`index_title` against ('breeze' in boolean mode))' (1690)
#0 /www/wwwroot/*********.com/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 [internal function]: IPS\Db\_Select->rewind()
#2 /www/wwwroot/*********.com/system/Content/Search/Mysql/Query.php(1336): iterator_to_array()
#3 /www/wwwroot/*********.com/applications/core/modules/front/search/search.php(761): IPS\Content\Search\Mysql\_Query->search()
#4 /www/wwwroot/*********.com/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#5 /www/wwwroot/*********.com/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#6 /www/wwwroot/*********.com/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#7 /www/wwwroot/*********.com/index.php(13): IPS\_Dispatcher->run()
#8 {main}

[Jim M]

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

[Mutterz108]

9 minutes ago, Jim M said:

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

 

Updated

[Jim M]

Thank you, I have moved this to a ticket now for further investigation. Please check your email for next steps.