# Update 4.0.8 > 4..1

**URL:** <https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210>\
**Category:** Shopware 3.5\
**Tags:** installation--gettin\
**Created:** [5. Juli 2013 um 10:43 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210 "2013-07-05T10:43:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![TheViper85](https://avatars.discourse-cdn.com/v4/letter/t/c0e974/32.png) [@TheViper85](https://forum.shopware.com/u/TheViper85)\
**Post date:** [5. Juli 2013 um 10:43 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/1 "2013-07-05T10:43:20Z")

</div>

Guten Morgen ersteinmal habe vorgestern das update von 408 auf 41 ausgeführt alles ohne probleme nach und nach fiel auf das der server immer häufiger 503 ausgibt “sprich zusammenbricht” Grundsetzliche uhrsache ist diese abfrage a.id as articleID, a.laststock, a.taxID, a.pricegroupID, a.pricegroupActive, a.notification as notification, a.datum, a.description AS description, a.description\_long, a.name AS articleName, a.topseller as highlight, (a.configurator\_set\_id IS NOT NULL) as sConfigurator, aDetails.id AS articleDetailsID, aDetails.ordernumber, aDetails.releasedate, aDetails.shippingfree, aDetails.shippingtime, aDetails.minpurchase, aDetails.purchasesteps, aDetails.maxpurchase, aDetails.purchaseunit, aDetails.referenceunit, aDetails.unitID, aDetails.weight, aDetails.additionaltext, aDetails.instock, aDetails.sales, IF(aDetails.sales\>=30,1,0) as topseller, IF(aDetails.releasedate\>‘2013-07-05’,1,0) as sUpcoming, IF(aDetails.releasedate\>‘2013-07-05’, aDetails.releasedate, ‘’) as sReleasedate, aSupplier.name AS supplierName, aSupplier.img AS supplierImg, aTax.tax, aAttributes.attr1, aAttributes.attr2, aAttributes.attr3, aAttributes.attr4, aAttributes.attr5, aAttributes.attr6, aAttributes.attr7, aAttributes.attr8, aAttributes.attr9, aAttributes.attr10, aAttributes.attr11, aAttributes.attr12, aAttributes.attr13, aAttributes.attr14, aAttributes.attr15, aAttributes.attr16, aAttributes.attr17, aAttributes.attr18, aAttributes.attr19, aAttributes.attr20, ( SELECT price FROM s\_articles\_prices WHERE articledetailsID = aDetails.id AND pricegroup= IF(p.id IS NULL, ‘EK’, p.pricegroup) AND `from` = 1 LIMIT 1 ) as priceForBasePrice, IFNULL(p.price, p2.price) as price, IF(p.pseudoprice,p.pseudoprice,p2.pseudoprice) as pseudoprice, IFNULL(p.pricegroup,IFNULL(p2.pricegroup,‘EK’)) as pricegroup, IFNULL((SELECT 1 FROM s\_articles\_details WHERE articleID=a.id AND kind=2 LIMIT 1), 0) as variants, IFNULL((SELECT 1 FROM s\_articles\_esd WHERE articleID=a.id LIMIT 1), 0) as esd, IF(DATEDIFF(‘2013-07-05’, a.datum) \<= 30,1,0) as newArticle, ( SELECT CONCAT(AVG(points), ‘|’,COUNT(\*)) as votes FROM s\_articles\_vote WHERE s\_articles\_vote.active=1 AND s\_articles\_vote.articleID = a.id ) AS sVoteAverange FROM s\_articles AS a FORCE INDEX (articles\_by\_category\_sort\_release) INNER JOIN s\_articles\_details AS aDetails ON aDetails.id = a.main\_detail\_id INNER JOIN s\_articles\_categories\_ro ac ON ac.articleID = a.id AND ac.categoryID = 170 INNER JOIN s\_categories c ON c.id = ac.categoryID AND c.active = 1 JOIN s\_articles\_attributes AS aAttributes ON aAttributes.articledetailsID = aDetails.id JOIN s\_core\_tax AS aTax ON aTax.id = a.taxID LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID = a.id AND ag.customergroupID = 1 LEFT JOIN s\_articles\_supplier AS aSupplier ON aSupplier.id = a.supplierID INNER JOIN s\_filter\_articles fv23 ON fv23.articleID = a.id AND fv23.valueID = 23 INNER JOIN s\_filter\_articles fv5 ON fv5.articleID = a.id AND fv5.valueID = 5 INNER JOIN s\_filter\_articles fv21 ON fv21.articleID = a.id AND fv21.valueID = 21 LEFT JOIN s\_articles\_prices p ON p.articleDetailsID = aDetails.id AND p.pricegroup = ‘EK’ AND p.to = ‘beliebig’ LEFT JOIN s\_articles\_prices p2 ON p2.articledetailsID = aDetails.id AND p2.pricegroup = ‘EK’ AND p2.to = ‘beliebig’ WHERE ag.articleID IS NULL AND a.active=1 GROUP BY a.datum, a.id ORDER BY a.datum DESC, a.id DESC LIMIT 0, 12 with 603s Hat jemand vieleicht eine idee woran es liegen könnte… denn die abfrage läuft ins unendliche

---

<div class="post-metadata">

**Author:** ![Patrick\_Schucker](https://avatars.discourse-cdn.com/v4/letter/p/a5b964/32.png) [@Patrick\_Schucker](https://forum.shopware.com/u/Patrick_Schucker)\
**Post date:** [5. Juli 2013 um 11:04 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/2 "2013-07-05T11:04:06Z")

</div>

Hi, kann es sein, dass du sehr viele Filtereigenschaften hast? Eventuell hilft [http://wiki.shopware.de/Performance-Tip … Engp.E4sse](http://wiki.shopware.de/Performance-Tipps-Shopware-4%5C_detail%5C_1258.html#Viele%5C_Eigenschaften%5C_und%5C_dadurch%5C_Performance-Engp.E4sse) weiter. Gruß Patrick

---

<div class="post-metadata">

**Author:** ![TheViper85](https://avatars.discourse-cdn.com/v4/letter/t/c0e974/32.png) [@TheViper85](https://forum.shopware.com/u/TheViper85)\
**Post date:** [5. Juli 2013 um 11:13 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/3 "2013-07-05T11:13:36Z")

</div>

Eigentlich nur 30 artik,. mit eigenschaften und die haben jeweils ca 10 eigenschaften ich verstehe aber WHERE ag.articleID IS NULL AND a.active=1 das nicht so ganz … da er ja nach einem artikel sucht der die id NULL hat und aktiv ist was ja nicht sein kann

---

<div class="post-metadata">

**Author:** ![Marcel\_S](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@Marcel\_S](https://forum.shopware.com/u/Marcel_S)\
**Post date:** [5. Juli 2013 um 11:30 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/4 "2013-07-05T11:30:46Z")

</div>

Hi, jo das passt schon achte mal auf den Alias hier geht es um die “s\_articles\_avoid\_customergroups”. Hast du bereits die Option gesetzt, wie Patrick das vorgeschlagen hat? Das sollte helfen. Vg, Marcel

---

<div class="post-metadata">

**Author:** ![TheViper85](https://avatars.discourse-cdn.com/v4/letter/t/c0e974/32.png) [@TheViper85](https://forum.shopware.com/u/TheViper85)\
**Post date:** [5. Juli 2013 um 11:35 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/5 "2013-07-05T11:35:01Z")

</div>

optimizer\_search\_depth ist auf 0

---

<div class="post-metadata">

**Author:** ![Marcel\_S](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@Marcel\_S](https://forum.shopware.com/u/Marcel_S)\
**Post date:** [5. Juli 2013 um 11:55 UTC](https://forum.shopware.com/t/update-4-0-8-gt-4-1/14210/6 "2013-07-05T11:55:51Z")

</div>

Hi, hast du mal nen Link wo wir uns das einmal anschauen können? Ansonsten einfach kurz Zugangsdaten(FTP, phpMyAdmin, Backend-Login) an [forum@shopware.de](mailto:forum@shopware.de) sen. Vg, Marcel