Posted September 5, 20231 yr 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}
September 5, 20231 yr 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.
September 5, 20231 yr Author 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
September 5, 20231 yr Thank you, I have moved this to a ticket now for further investigation. Please check your email for next steps.
