Jump to content

Recommended Posts

Posted (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 by DawPi
Posted

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.

Posted
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:

Could contain: Text, Word, Number, Symbol, Page

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...