Issue: Script Error - XenForo 2.2.x

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xenforo.vw_counter' doesn't exist src/XF/Db/AbstractStatement.php:230

Generated by: Dino_10 Oct 23, 2024 at 11:54 PM

Stack trace

SELECT search_index.content_type, search_index.content_id
FROM xf_search_index_temp AS search_index
INNER JOIN vw_counter AS vw_counter ON (vw_counter.routeid = search_index.content_id)



ORDER BY vw_counter.lastupdate DESC, search_index.hit_position ASC
LIMIT 200

------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(162): XF\Db\AbstractAdapter->query('
SELECT sear...', Array)
#5 src/addons/XFES/Search/Source/Elasticsearch.php(921): XF\Db\AbstractAdapter->fetchAllNum('
SELECT sear...')
#6 src/addons/SV/ElasticSearchEssentials/XFES/Search/Source/Elasticsearch.php(560): XFES\Search\Source\Elasticsearch->getSqlResults(Array, Object(SV\ElasticSearchEssentials\XF\Search\Query\Keyword Query), 200)
#7 src/addons/XFES/Search/Source/Elasticsearch.php(769): SV\ElasticSearchEssentials\XFES\Search\Source\Elasticsear ch->getSqlResults(Array, Object(SV\ElasticSearchEssentials\XF\Search\Query\Keyword Query), '200')
#8 src/addons/SV/SearchImprovements/XFES/Search/Source/Elasticsearch.php(332): XFES\Search\Source\Elasticsearch->executeSearch(Object(SV\ElasticSearchEssentials\XF\Searc h\Query\KeywordQuery), Array, '200')
#9 src/addons/XFES/Search/Source/Elasticsearch.php(145): SV\SearchImprovements\XFES\Search\Source\Elasticsearch->executeSearch(Object(SV\ElasticSearchEssentials\XF\Searc h\Query\KeywordQuery), Array, '200')
#10 src/XF/Search/Search.php(185): XFES\Search\Source\Elasticsearch->search(Object(SV\ElasticSearchEssentials\XF\Search\Query \KeywordQuery), '200')
#11 src/XF/Search/Search.php(214): XF\Search\Search->XF\Search\{closure}(Object(SV\ElasticSearchEssentials\XF \Search\Query\KeywordQuery), '200')
#12 src/addons/SV/ElasticSearchEssentials/XF/Search/Search.php(48): XF\Search\Search->executeSearch(Object(SV\ElasticSearchEssentials\XF\Searc h\Query\KeywordQuery), '200', Object(Closure), true)
#13 src/XF/Search/Search.php(180): SV\ElasticSearchEssentials\XF\Search\Search->executeSearch(Object(SV\ElasticSearchEssentials\XF\Searc h\Query\KeywordQuery), NULL, Object(Closure), true)
#14 src/XF/Repository/Search.php(33): XF\Search\Search->search(Object(SV\ElasticSearchEssentials\XF\Search\Query \KeywordQuery))
#15 src/addons/SV/ElasticSearchEssentials/XF/Repository/XF22/SearchPatch.php(33): XF\Repository\Search->runSearch(Object(SV\ElasticSearchEssentials\XF\Search\Qu ery\KeywordQuery), Array, true)
#16 src/addons/SV/ElasticSearchEssentials/Repository/SearchTrait.php(42): SV\ElasticSearchEssentials\XF\Repository\XF22\SearchPatch->SV\ElasticSearchEssentials\XF\Repository\XF22\{closure}( Object(SV\ElasticSearchEssentials\XF\Search\Query\Keyword Query), Array, true)
#17 src/addons/SV/ElasticSearchEssentials/XF/Repository/XF22/SearchPatch.php(32): SV\ElasticSearchEssentials\XF\Repository\XF22\SearchPatch->wrapRunSearchForSvEss(Object(Closure), Object(SV\ElasticSearchEssentials\XF\Search\Query\Keyword Query), Array, true)
#18 src/addons/SV/SearchImprovements/XF/Repository/XF22/SearchPatch.php(45): SV\ElasticSearchEssentials\XF\Repository\XF22\SearchPatch->runSearch(Object(SV\ElasticSearchEssentials\XF\Search\Qu ery\KeywordQuery), Array, true)
#19 src/addons/SV/ElasticSearchEssentials/XF/Pub/Controller/XF22/SearchPatch.php(27): SV\SearchImprovements\XF\Repository\XF22\SearchPatch->runSearch(Object(SV\ElasticSearchEssentials\XF\Search\Qu ery\KeywordQuery), Array, true)
#20 src/XF/Pub/Controller/Search.php(119): SV\ElasticSearchEssentials\XF\Pub\Controller\XF22\SearchP atch->runSearch(Object(SV\ElasticSearchEssentials\XF\Search\Qu ery\KeywordQuery), Array)
#21 src/addons/SV/SearchImprovements/XF/Pub/Controller/Search.php(92): XF\Pub\Controller\Search->actionSearch()
#22 src/addons/SV/ElasticSearchEssentials/XF/Pub/Controller/Search.php(521): SV\SearchImprovements\XF\Pub\Controller\Search->actionSearch()
#23 src/XF/Mvc/Dispatcher.php(352): SV\ElasticSearchEssentials\XF\Pub\Controller\Search->actionSearch(Object(XF\Mvc\ParameterBag))
#24 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Search', 'Search', Object(XF\Mvc\RouteMatch), Object(SV\SearchImprovements\XF\Pub\Controller\SearchPatc hFirst), NULL)
#25 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\SearchImprovements\XF\Pub\Controller\SearchPatc hFirst), NULL)
#26 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#27 src/XF/App.php(2485): XF\Mvc\Dispatcher->run()
#28 src/XF.php(524): XF\App->run()
#29 index.php(20): XF::runApp('XF\\Pub\\App')
#30 {main}

Request state

array(4) {
["url"] => string(21) "/forums/search/search"
["referrer"] => string(218) "https://www.500eboard.co/forums/search/91572/?searchform=1&q=8+pin+maf+sensor+diagram&t=vwpage&c[areachoice][0]=0&c[areachoice][1]=2&c[areachoice][2]=5&c[children]=1&c[prefixchoice][0]=-1&c[typechoice][0]=0&o=relevance"
["_GET"] => array(0) {
}
["_POST"] => array(8) {
["_xfToken"] => string(8) "********"
["keywords"] => string(24) "8 pin maf sensor diagram"
["c"] => array(4) {
["areachoice"] => array(3) {
[0] => string(1) "0"
[1] => string(1) "2"
[2] => string(1) "5"
}
["children"] => string(1) "1"
["prefixchoice"] => array(1) {
[0] => string(2) "-1"
}
["typechoice"] => array(1) {
[0] => string(1) "0"
}
}
["order"] => string(10) "lastupdate"
["search_type"] => string(6) "vwpage"
["_xfRequestUri"] => string(194) "/forums/search/91572/?searchform=1&q=8+pin+maf+sensor+diagram&t=vwpage&c[areachoice][0]=0&c[areachoice][1]=2&c[areachoice][2]=5&c[children]=1&c[prefixchoice][0]=-1&c[typechoice][0]=0&o=relevance"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}