On the latest version (1.0.7.9) we are having a few issues on the search page currently with "awards_awarded_pl" showing and throwing errors on search terms specificallly if the search term is the name of the award,
SELECT `awarded_id`, `awarded_title`, `awarded_` FROM `awards_awarded` WHERE ( awarded_id IN(255,235,220,219,215,207,177,170,162,130,72,52) )
IPS\Db\Exception: Unknown column 'awarded_' in 'field list' (1054)
#0 /home/nginx/domains/[DOMAIN]/public/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT `awarded...', Array)
#1 /home/nginx/domains/[DOMAIN]/public/system/Db/Select.php(244): IPS\Db\_Select->runQuery()
#2 /home/nginx/domains/[DOMAIN]/public/system/Content/Search/Results.php(161): IPS\Db\_Select->setKeyField('awarded_id')
#3 /home/nginx/domains/[DOMAIN]/public/system/Content/Search/Results.php(318): IPS\Content\Search\_Results->init()
#4 /home/nginx/domains/[DOMAIN]/public/system/Theme/Theme.php(734) : eval()'d code(2690): IPS\Content\Search\_Results->rewind()
#5 [internal function]: IPS\Theme\class_core_front_search->resultStream(Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly))
#6 /home/nginx/domains/[DOMAIN]/public/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array)
#7 /home/nginx/domains/[DOMAIN]/public/system/Theme/Theme.php(734) : eval()'d code(2776): IPS\Theme\_SandboxedTemplate->__call('resultStream', Array)
#8 /home/nginx/domains/[DOMAIN]/public/system/Theme/Theme.php(734) : eval()'d code(2776): IPS\Theme\SandboxedTemplate->resultStream(Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly))
#9 [internal function]: IPS\Theme\class_core_front_search->results('["Logi","School...', 'fe1d9c0742bc05f...', Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly), 49)
#10 /home/nginx/domains/[DOMAIN]/public/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array)
#11 /home/nginx/domains/[DOMAIN]/public/system/Theme/Theme.php(734) : eval()'d code(2853): IPS\Theme\_SandboxedTemplate->__call('results', Array)
#12 /home/nginx/domains/[DOMAIN]/public/system/Theme/Theme.php(734) : eval()'d code(2853): IPS\Theme\SandboxedTemplate->results('["Logi","School...', 'fe1d9c0742bc05f...', Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly), 49)
#13 [internal function]: IPS\Theme\class_core_front_search->search('["Logi","School...', 'fe1d9c0742bc05f...', Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly), Array, '\n\n\n<form accept...', 49)
#14 /home/nginx/domains/[DOMAIN]/public/system/Theme/SandboxedTemplate.php(57): call_user_func_array(Array, Array)
#15 /home/nginx/domains/[DOMAIN]/public/applications/core/modules/front/search/search.php(579): IPS\Theme\_SandboxedTemplate->__call('search', Array)
#16 /home/nginx/domains/[DOMAIN]/public/applications/core/modules/front/search/search.php(579): IPS\Theme\SandboxedTemplate->search('["Logi","School...', 'fe1d9c0742bc05f...', Object(IPS\Content\Search\Results), '<ul class='ipsP...', Object(IPS\Http\Url\Friendly), Array, '\n\n\n<form accept...', 49)
#17 /home/nginx/domains/[DOMAIN]/public/applications/core/modules/front/search/search.php(74): IPS\core\modules\front\search\_search->_results()
#18 /home/nginx/domains/[DOMAIN]/public/system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\_search->manage()
#19 /home/nginx/domains/[DOMAIN]/public/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#20 /home/nginx/domains/[DOMAIN]/public/index.php(13): IPS\_Dispatcher->run()
#21 {main}
It also appears this issue is also raising its head on all member profiles where "members_pl" is visable with the following error, on the following domain pattern
[domain]/profile/[userid-username]/content/?type=forums_topic&sortby=last_post&sortdirection=desc&page=1
[domain]/profile/[userid-username]/?do=content&change_section=1
[domain]/profile/[userid-username]/content/?type=core_statuses_status&sortby=status_content&sortdirection=asc&page=1
[domain]/profile/[userid-username]/content/?type=forums_topic&sortby=title&sortdirection=asc&page=1
[domain]/profile/[userid-username]/content/?type=forums_topic&page=1&sortby=posts&sortdirection=desc
[domain]/profile/[userid-username]/content/?type=core_statuses_status&page=1&sortby=status_replies&sortdirection=desc
[domain]/profile/[userid-username]/content/?type=forums_topic&sortby=posts&sortdirection=desc&page=1
[domain]/profile/[userid-username]/content/?type=core_statuses_status&sortby=status_date&sortdirection=desc&page=1
[domain]/profile/[userid-username]/?do=content&type=forums_topic_post&change_section=1
SELECT perm_type_id FROM `core_permission_index` WHERE core_permission_index.app='awards' AND core_permission_index.perm_type='awards' AND (( FIND_IN_SET(4,perm_) OR FIND_IN_SET(7,perm_) OR FIND_IN_SET(10,perm_) ) OR perm_='*' )
IPS\Db\Exception: Unknown column 'perm_' in 'where clause' (1054)
#0 /home/nginx/domains/[domain]/public/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT perm_typ...', Array)
#1 /home/nginx/domains/[domain]/public/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#2 /home/nginx/domains/[domain]/public/system/Content/Item.php(2245): IPS\Db\_Select->rewind()
#3 /home/nginx/domains/[domain]/public/system/Helpers/Table/Content.php(267): IPS\Content\_Item::getItemsWithPermission(Array, 'awarded_date de...', NULL, 'read', NULL, 0, NULL, false, false, false, true, Array, false, true, true, true, false)
#4 /home/nginx/domains/[domain]/public/system/Helpers/Table/Table.php(448): IPS\Helpers\Table\_Content->getRows(Array)
#5 /home/nginx/domains/[domain]/public/applications/core/modules/front/members/profile.php(502): IPS\Helpers\Table\_Table->__toString()
#6 [internal function]: IPS\core\modules\front\members\_profile->content()
#7 /home/nginx/domains/[domain]/public/system/Dispatcher/Controller.php(85): call_user_func(Array)
#8 /home/nginx/domains/[domain]/public/applications/core/modules/front/members/profile.php(64): IPS\Dispatcher\_Controller->execute()
#9 /home/nginx/domains/[domain]/public/system/Dispatcher/Dispatcher.php(129): IPS\core\modules\front\members\_profile->execute()
#10 /home/nginx/domains/[domain]/public/index.php(13): IPS\_Dispatcher->run()
#11 {main}
