# GELÖST: Suchergebnis liefert 500 Error **URL:** \ **Category:** Allgemein\ **Created:** [29. Dezember 2018 um 12:25 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209 "2018-12-29T12:25:35Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![GreMo](https://avatars.discourse-cdn.com/v4/letter/g/82dd89/32.png) [@GreMo](https://forum.shopware.com/u/GreMo)\ **Post date:** [29. Dezember 2018 um 12:25 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209/1 "2018-12-29T12:25:35Z")
Hallo Community, ich habe folgendes Problem, nämlich einen 500 Error bei der Suche nach “Basic 55” oder ähnliche Suchanfrage mit der Zahl 55. Folgendes wurde gemacht: - Shop neu aufgesetzt (SW 5.5.4) - Steuern eingestellt - JTL Connector installiert - Komplettabgleich durchgeführt - Suche Basic 55 --\> OK - Kategorie Verknüpfung & Seo URLs neu aufgebaut - Suche Basic 55 --\> OK - Cache gelöscht - Suche 55 --\> Error 500 Hier die Suchanfrage dazu: [https://haustierliebe.shop/search?sSearch=basic+55](https://haustierliebe.shop/search?sSearch=basic+55) Hier der Artikel der gefunden werden sollte: [https://haustierliebe.shop/hunter-halsband-basic-55-nickel-hals-41-49-cm](https://haustierliebe.shop/hunter-halsband-basic-55-nickel-hals-41-49-cm) Folgendes steht im Errorlog: [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852, referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: Stack trace:, referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #0 /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): PDO-\>query(‘SELECT template…’), referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #1 /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT template…’, Array, Array), referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #2 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/Inheritance.php(503): Doctrine\DBAL\Query\QueryBuilder-\>execute(), referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #3 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/Inheritance.php(239): Shopware\Components\Theme\Inheritance-\>fetchTemplates(), referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:41 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #4 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/EventListener/ConfigLoader.php(81): Shopware\Components\Theme\Inheritance-\>getSmartyDirectories(Object(Sh in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131, referer: [https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858](https://haustierliebe.shop/karlie-doggy-pool-hundepool?number=56858) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:168, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: Stack trace:, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #0 /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): PDOStatement-\>execute(Array), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #1 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Plugin/DBALConfigReader.php(86): Doctrine\DBAL\Statement-\>execute(Array), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #2 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Plugin/CachedConfigReader.php(66): Shopware\Components\Plugin\DBALConfigReader-\>getByPluginName(‘CoeScrollToTop’, Object(Shopware\Models\Shop\DetachedShop)), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #3 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Plugin/Namespace.php(85): Shopware\Components\Plugin\CachedConfigReader-\>getByPluginName(‘CoeScrollToTop’, Object(Shopware\Models\Shop\DetachedShop)), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:57 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #4 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Plugin/Bo in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: Stack trace:, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #0 /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): PDO-\>query(‘SELECT template…’), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #1 /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT template…’, Array, Array), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #2 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/Inheritance.php(503): Doctrine\DBAL\Query\QueryBuilder-\>execute(), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #3 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/Inheritance.php(239): Shopware\Components\Theme\Inheritance-\>fetchTemplates(), referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) [Sat Dec 29 13:21:58 2018] [warn] [client 185.69.245.170] mod\_fcgid: stderr: #4 /var/www/vhosts/haustierliebe.shop/httpdocs/engine/Shopware/Components/Theme/EventListener/ConfigLoader.php(81): Shopware\Components\Theme\Inheritance-\>getSmartyDirectories(Object(Sh in /var/www/vhosts/haustierliebe.shop/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131, referer: [https://haustierliebe.shop/](https://haustierliebe.shop/) Kann mir hierzu jemand einen Denkanstoss geben, wo ich den Fehler suchen muss? Vielen Dank!   ---
**Author:** ![kulli](https://avatars.discourse-cdn.com/v4/letter/k/a3d4f5/32.png) [@kulli](https://forum.shopware.com/u/kulli)\ **Post date:** [29. Dezember 2018 um 13:17 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209/2 "2018-12-29T13:17:18Z")
Harte Nuß 😉 1. Verdacht: War es eine komplett neu erstellte leere Datenbank, oder wuirde die Datenbank vorher von was anderem benutzt ? 2. Verdacht: Der Connector schreibt falsch in die Datenbank 3. Verdacht: Timeout: [Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away - Google Search](https://www.google.com/search?client=firefox-b-ab&q=Uncaught+PDOException%3A+SQLSTATE%5BHY000%5D%3A+General+error%3A+2006+MySQL+server+has+gone+away)   ---
**Author:** ![GreMo](https://avatars.discourse-cdn.com/v4/letter/g/82dd89/32.png) [@GreMo](https://forum.shopware.com/u/GreMo)\ **Post date:** [29. Dezember 2018 um 13:26 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209/3 "2018-12-29T13:26:10Z")
zu 1.) Ja es war eine komplett neue & leere DB zu 2.) Ich werde mal beim JTL Support anfragen und das Problem beschreiben zu 3.) Hierzu habe ich auch schon gesucht aber noch keine Lösung gefunden ---
**Author:** ![GreMo](https://avatars.discourse-cdn.com/v4/letter/g/82dd89/32.png) [@GreMo](https://forum.shopware.com/u/GreMo)\ **Post date:** [30. Dezember 2018 um 20:20 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209/4 "2018-12-30T20:20:41Z")
Mir ist folgendes aufgefallen: - die Nummerrange von 51 - 65 führt zu einem 500 er Error - meine Artikelnummern beginnen bei 51000 und enden irgendwo bei 65xxx - die Keyword Tabelle ist somit in der Range von 51 - 65 sehr groß Ich werde bei meinem Hoster anfragen ob folgende Werte erhöht werden können: wait\_timeout=  max\_allowed\_packet= Könnt ihr mir hier für die zwei Werte einen guten Richtwert geben und ob noch ein Wert erhöht werden sollte? Alternativ habe ich mir überlegt einen Prefix an die Arikelnummer zu hängen, das sollte auch helfen. Vielen Dank! ---
**Author:** ![GreMo](https://avatars.discourse-cdn.com/v4/letter/g/82dd89/32.png) [@GreMo](https://forum.shopware.com/u/GreMo)\ **Post date:** [7. Januar 2019 um 11:23 UTC](https://forum.shopware.com/t/gelost-suchergebnis-liefert-500-error/57209/5 "2019-01-07T11:23:42Z")
Nach Anhebung der max\_allowed\_packet funktioniert die Suche nun - vielen Dank!