Rydenlol

Fair enough, marked as answered. Thanks again sir.

Okay, so I'll need to disable that part of Kitchen Sink then. Has there been any functionality added to 4.2.7 to default search by relevancy or is this all going to have to wait until 4.3?

Hi. So after I upgraded to 4.2.7, the search by relevancy option no longer triggered an error. However, what it does now within the results, is it adds "/&searchlight=1" at the end of the page url of the result which then forces a "Page Not Found Error code: 2T251/5" Easily enough, removing that last bit will send me to the page but I can't expect end users to know that. I have narrowed down the issue though. Since IPB does not have an option to search by relevancy by default, I use Kitchen Sink to force it. Kitchen Sink also forces the searchlight text as mentioned above. When I disable Kitchen Sink, search for something, and manually select more relevant results, the issue does not occur. But, I cant have my end users either missing searches or having to select "more relevant results" every time they search. At least that's not ideal lol. In short, I assume this is on Kitchen Sinks end but wanted to see if anyone knew of any workarounds to achieve default search by relevancy.

Just upgraded, it's fixed! Thank you everyone!

Great! I will try to upgrade and see if that changes anything and will update this post and mark as best answer.

Bump, I haven't been able to resolve this

Sidenote, I have installed a fresh copy of 4.2.6 off a fresh download from here, and I am still having an issue with searching by relevancy, it appears to be the same exact error.

Hello, All the products from webflake have been working beautifully, except I cannot seem to get the Search by Relevancy feature to work properly. It throws an error and will not show results unless I search by Date. As for troubleshooting, I have done a great deal of Googling and encountered similar issues with many different fixes, but for different areas of IPB. I have checked my Support area to determine if it detected anything and everything is green except I do not have the best version of cURL on there. I have disabled all customizations and tried again, but it is still happening. Here is the error: SELECT main.*, ((Array*5)+(Array))/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\\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\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) ) 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) ) ) ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: Unknown column 'Array' in 'field list' (1054) #0 htdocs/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\Content\\S...', Array, true) #1 htdocs/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 htdocs/system/Content/Search/Mysql/Query.php(1258): iterator_to_array(Object(IPS\Db\Select)) #4 htdocs/applications/core/modules/front/search/search.php(608): IPS\Content\Search\Mysql\_Query->search('test', NULL, 17) #5 htdocs/applications/core/modules/front/search/search.php(73): IPS\core\modules\front\search\_search->_results() #6 htdocs/system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\_search->manage() #7 htdocs/system/Dispatcher/Dispatcher.php(146): IPS\Dispatcher\_Controller->execute() #8 htdocs/index.php(12): IPS\_Dispatcher->run() #9 {main} Thank you so much for any insight you can provide.