Error messages at system log related to searches

[Gabriel Torres]

Hi guys,

After upgrading to 4.3.x, I am seeing a few messages like this at our system log:

SELECT main.*, ((MATCH(index_title) AGAINST ('*Placa* *mãe* *ASUS* *P5* *G41TM* *LX2BR,* *não* *aceita* *4* *(hd\'s,) *fonte* *ou* *defeito* *na* *placa'IPS\cms\Pages\PageItem'*' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('*Placa* *mãe* *ASUS* *P5* *G41TM* *LX2BR,* *não* *aceita* *4* *(hd\'s,) *fonte* *ou* *defeito* *na* *placa'IPS\forums\Topic\Post'*' 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\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\cms\\Records5','IPS\\cms\\Records\\Comment5','IPS\\cms\\Records\\Review5') ) OR ( index_class IN('IPS\\cms\\Records6','IPS\\cms\\Records\\Comment6','IPS\\cms\\Records\\Review6') ) OR ( index_class IN('IPS\\cms\\Records7','IPS\\cms\\Records\\Comment7','IPS\\cms\\Records\\Review7') ) OR ( index_class IN('IPS\\cms\\Records8','IPS\\cms\\Records\\Comment8','IPS\\cms\\Records\\Review8') ) OR index_class='IPS\forums\Topic\Post' OR index_class='*Placa* *mãe* *ASUS* *P5* *G41TM* *LX2BR,* *não* *aceita* *4* *(hd\'s,) *fonte* *ou* *defeito* *na* *placa0*' OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) ) AND ( index_class=? ) AND MATCH(index_title) AGAINST (? IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(17,index_permissions) OR FIND_IN_SET('m589297',index_permissions) ) ) AND index_hidden=? ORDER BY calcscore DESC LIMIT 0,25
IPS\Db\Exception: syntax error, unexpected '(', expecting FTS_TERM or FTS_NUMB or '*' (1064)
#0 [redacted]system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\Content\\S...', Array, true)
#1 [redacted]system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [redacted]system/Content/Search/Mysql/Query.php(1284): iterator_to_array(Object(IPS\Db\Select))
#4 [redacted]applications/core/modules/front/search/search.php(623): IPS\Content\Search\Mysql\_Query->search('*Placa* *m\xC3\xA3e* ...', NULL, 25, 'or')
#5 [internal function]: IPS\core\modules\front\search\_search->_results()
#6 [redacted]init.php(460) : eval()'d code(101): call_user_func_array('parent::_result...', Array)
#7 [redacted]applications/core/modules/front/search/search.php(73): IPS\core\modules\front\search\hook2209->_results()
#8 [internal function]: IPS\core\modules\front\search\_search->manage()
#9 [redacted]init.php(460) : eval()'d code(178): call_user_func_array('parent::manage', Array)
#10 [redacted]system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\hook2209->manage()
#11 [redacted]system/Dispatcher/Dispatcher.php(146): IPS\Dispatcher\_Controller->execute()
#12 [redacted]index.php(13): IPS\_Dispatcher->run()
#13 {main}

It seems like a bug on the search engine, but I can't be sure. Anyone else who has Pages (cms) installed is seeing something like this?

I want a confirmation that this is a bug before reporting it.

Cheers,

Gabriel.