Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
DawPi Posted May 27, 2022 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
Marc Posted May 27, 2022 Posted May 27, 2022 Where are you seeing this? What action is being performed at the time?
Daniel F Posted May 27, 2022 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.
DawPi Posted May 27, 2022 Author 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:
Marc Posted May 27, 2022 Posted May 27, 2022 I have created a ticket for you on this, so we can look further into the issue
DawPi Posted May 27, 2022 Author Posted May 27, 2022 Thanks, all access details were provided in the CA.
Recommended Posts