DawPi Posted May 27, 2022 Share Posted May 27, 2022 (edited) 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 Link to comment Share on other sites More sharing options...
Marc Posted May 27, 2022 Share Posted May 27, 2022 Where are you seeing this? What action is being performed at the time? Link to comment Share on other sites More sharing options...
Daniel F Posted May 27, 2022 Share Posted May 27, 2022 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. Link to comment Share on other sites More sharing options...
DawPi Posted May 27, 2022 Author Share Posted May 27, 2022 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: Link to comment Share on other sites More sharing options...
Marc Posted May 27, 2022 Share Posted May 27, 2022 I have created a ticket for you on this, so we can look further into the issue Link to comment Share on other sites More sharing options...
DawPi Posted May 27, 2022 Author Share Posted May 27, 2022 Thanks, all access details were provided in the CA. Link to comment Share on other sites More sharing options...
Recommended Posts