UXNUZPcUZ.*UZ^UZhUZ4_U@Z+ UP[=SU@[R U[3ЙUP[ASU[RЙU`[AQU [<U [`U@]. U`(]=UP]uQUP]<^UP`]hU`@]4_U@` ]+@Up^s^Up^_U ^+U`` UP0b=QUb<_Ub+UcϞUcU]dϞUd "Ub* U8e=QUe<_Ue+U]fϞUfU]gϞUg "Ue* U@j=SUHjRЙUPjAQUj<UjSU00`kR@[U0@k{_U@k+SU`xlRUNlϞU`l Upp= U`p=SUpppRЙUpPpApFUpUPpu U`p="UpPЙUPpApFUpU`pupFUpUp Up@s=UPsu U`s="UsPЙUPsApFUsU`supFUs^Us_Us+ U@u=UPuuIU uQЙU `uAQU0u<0yUuϞU0u U`x=UPxupFU@xU@x@U`zs^U`pz_Upz+ Up|=IU|QЙUP|AU`|C`DU| UPP}=UP}uIU }QЙU`}AQU}<0yU}ϞU} "Uz*IUQuUPϞU "Us*UMpRU `N|U  s_U + U=U PuIUp QЙU `AQU0 <0yUϞU0  "U*`jU "UO* U=QU@ <PcU@ P .SUp0` RU` p hUp P 4_UP +.relevance) as relevance', 'sm.keywordID', 'term']); $query->from('(' . $keywordSelection . ')', 'sm'); $query->innerJoin('sm', 's_search_index', 'si', 'sm.keywordID = si.keywordID'); $query->innerJoin('si', 's_search_fields', 'sf', 'si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = ' . $table['tableID']); $query->groupBy('articleID') ->addGroupBy('sm.term') ->addGroupBy('sf.id'); if (!empty($table['referenz_table'])) { $query->addSelect($alias . '.articleID as articleID'); $query->innerJoin('si', $table['referenz_table'], $alias, 'si.elementID = ' . $alias . '.' . $table['foreign_key']); } elseif (!empty($table['foreign_key'])) { $query->addSelect($alias . '.id as articleID'); $query->innerJoin('si', 's_articles', $alias, 'si.elementID = ' . $alias . '.' . $table['foreign_key']); } else { $query->addSelect('si.elementID as articleID'); } $tablesSql[] = $query->getSQL(); } $tablesSql = "\n" . implode("\n UNION ALL\n", $tablesSql); $subQuery = $this->connection->createQueryBuilder(); $subQuery->select(['srd.articleID', 'SUM(srd.relevance) as relevance', 'COUNT(DISTINCT term) as termCount']); $subQuery->from('(' . $tablesSql . ')', 'srd') ->groupBy('srd.articleID') ->orderBy('relevance', 'DESC') ->setMaxResults(5000); $query = $this->connection->createQueryBuilder(); $query->from('(' . $subQuery->getSQL() . ')', 'sr') ->innerJoin('sr', 's_articles', 'a', 'a.id = sr.articleID AND a.active = 1'); return $query; } /** * Calculates the search tolerance and adds an where condition * to the query. */ private function addToleranceCondition(QueryBuilder $query) { $distance = $this->config->get('fuzzySearchMinDistancenTop', 20); $query->select('MAX(' . $this->getRelevanceSelection() . ") / 100 * $distance"); // calculates the tolerance limit if ($distance) { $query->andWhere('(' . $this->getRelevanceSelection() . ') > (' . $query->getSQL() . ')'); } } /** * Get all tables and columns that might be involved in this search request as an array * * @return array */ private function getSearchTables() { return $this->connection->fetchAll(" SELECT STRAIGHT_JOIN st.id AS tableID, st.table, st.where, st.referenz_table, st.foreign_key, GROUP_CONCAT(sf.id SEPARATOR ', ') AS fieldIDs, GROUP_CONCAT(sf.field SEPARATOR ', ') AS `fields` FROM s_search_fields sf FORCE INDEX (tableID) INNER JOIN s_search_tables st ON st.id = sf.tableID AND sf.relevance != 0 GROUP BY sf.tableID "); } /** * checks if the given result set matches all search terms * * @param QueryBuilder $query * @param string $term */ private function addAndSearchLogic($query, $term) { $searchTerms = $this->termHelper->splitTerm($term); $query->andWhere('termCount >= ' . \count($searchTerms)); } }
Fatal error: Uncaught Error: Class "Shopware\Bundle\SearchBundleDBAL\SearchTerm\SearchTermQueryBuilder" not found in /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php:9153 Stack trace: #0 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(257): ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->getShopwareSearchdbal_SearchQueryBuilderDbalService() #1 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(231): Symfony\Component\DependencyInjection\Container->make() #2 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(209): Symfony\Component\DependencyInjection\Container->get() #3 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(133): Shopware\Components\DependencyInjection\Container->doLoad() #4 /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php(9141): Shopware\Components\DependencyInjection\Container->get() #5 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(257): ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->getShopwareSearchdbal_SearchConditionHandlerDbalService() #6 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(231): Symfony\Component\DependencyInjection\Container->make() #7 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(209): Symfony\Component\DependencyInjection\Container->get() #8 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(133): Shopware\Components\DependencyInjection\Container->doLoad() #9 /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php(8974): Shopware\Components\DependencyInjection\Container->get() #10 [internal function]: ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->{closure}() #11 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Bundle/SearchBundleDBAL/QueryBuilderFactory.php(70): iterator_to_array() #12 /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php(8966): Shopware\Bundle\SearchBundleDBAL\QueryBuilderFactory->__construct() #13 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(257): ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->getShopwareSearchdbal_DbalQueryBuilderFactoryService() #14 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(231): Symfony\Component\DependencyInjection\Container->make() #15 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(209): Symfony\Component\DependencyInjection\Container->get() #16 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(133): Shopware\Components\DependencyInjection\Container->doLoad() #17 /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php(8668): Shopware\Components\DependencyInjection\Container->get() #18 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(257): ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->getShopwareSearch_ProductNumberSearchService() #19 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(231): Symfony\Component\DependencyInjection\Container->make() #20 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(209): Symfony\Component\DependencyInjection\Container->get() #21 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(133): Shopware\Components\DependencyInjection\Container->doLoad() #22 /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php(8024): Shopware\Components\DependencyInjection\Container->get() #23 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(257): ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer->getShopwareControllersFrontendListingService() #24 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/dependency-injection/Container.php(231): Symfony\Component\DependencyInjection\Container->make() #25 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(209): Symfony\Component\DependencyInjection\Container->get() #26 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/DependencyInjection/Container.php(133): Shopware\Components\DependencyInjection\Container->doLoad() #27 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Library/Enlight/Controller/Dispatcher/Default.php(284): Shopware\Components\DependencyInjection\Container->get() #28 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Library/Enlight/Controller/Dispatcher/Default.php(365): Enlight_Controller_Dispatcher_Default->getControllerPath() #29 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Library/Enlight/Controller/Dispatcher/Default.php(416): Enlight_Controller_Dispatcher_Default->isDispatchable() #30 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch() #31 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #32 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #33 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #34 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #35 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/http-kernel/HttpCache/HttpCache.php(399): Shopware\Components\HttpCache\AppCache->forward() #36 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/http-kernel/HttpCache/HttpCache.php(352): Symfony\Component\HttpKernel\HttpCache\HttpCache->validate() #37 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #38 /var/www/vhosts/torix.at/httpdocs/copie5_11/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup() #39 /var/www/vhosts/torix.at/httpdocs/copie5_11/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #40 /var/www/vhosts/torix.at/httpdocs/copie5_11/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #41 {main} thrown in /var/www/vhosts/torix.at/httpdocs/copie5_11/var/cache/production_202306271137/proxies/ShopwareProductionf6114c0c113e2510b7dd2c27e23e1ae1a15aaaa8ProjectContainer.php on line 9153