Posted 26 января, 20222 yr comment_176941 Перестало работать нормально поиск выдает ошибку (под сполером) Спойлер SELECT main.*, ((MATCH(index_title) AGAINST ('статистика' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('статистика' 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\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR index_class='IPS\downloads\File\PendingVersion' OR index_class='IPS\cms\Pages\PageItem' ) AND MATCH(index_content,index_title) AGAINST ('статистика' 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('c1',index_permissions) OR FIND_IN_SET('c2',index_permissions) OR FIND_IN_SET('c3',index_permissions) OR FIND_IN_SET('cm1',index_permissions) OR FIND_IN_SET('cm2',index_permissions) OR FIND_IN_SET('cm3',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: DOUBLE value is out of range in '(match `msforum`.`main`.`index_title` against ('статистика' in boolean mode)) * 5 + (match `msforum`.`main`.`index_content`,`msforum`.`main`.`index_title` against ('статистика' in boolean mode))' (1690) #0 /var/www/msnews/data/www/forum.msnews.cf/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 /var/www/msnews/data/www/forum.msnews.cf/system/Content/Search/Mysql/Query.php(1302): iterator_to_array(Object(IPS\Db\Select)) #3 /var/www/msnews/data/www/forum.msnews.cf/applications/core/modules/front/search/search.php(728): IPS\Content\Search\Mysql\_Query->search('\xD1\x81\xD1\x82\xD0\xB0\xD1\x82\xD0\xB8\xD1\x81\xD1\x82\xD0...', NULL, 17, 'or') #4 /var/www/msnews/data/www/forum.msnews.cf/applications/core/modules/front/search/search.php(109): IPS\core\modules\front\search\_search->_results() #5 /var/www/msnews/data/www/forum.msnews.cf/system/Dispatcher/Controller.php(101): IPS\core\modules\front\search\_search->manage() #6 /var/www/msnews/data/www/forum.msnews.cf/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/msnews/data/www/forum.msnews.cf/index.php(13): IPS\_Dispatcher->run() #8 {main} до это менял базу mysql на MariaDB могло это как повлиять еще интересный баг, поиск работает если вводишь цифру, но любое слово ошибку выдает
26 января, 20222 yr comment_176942 https://ipbmafia.ru/topic/24003-oshibka-pri-popytki-ispolzovat-poisk-na-forume-double-value-is-out-of-range/
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.