# Errormeldungen bulky\_goods
**URL:** https://forum.shopware.com/t/errormeldungen-bulky-goods/101996
**Category:** Shopware 5
**Created:** [21. November 2023 um 10:54 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996 "2023-11-21T10:54:48Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@muroshi](https://forum.shopware.com/u/muroshi)
#### Post date: [21. November 2023 um 10:54 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/1 "2023-11-21T10:54:49Z")
Ich erhalte folgende Errormeldungen:
An exception occurred while executing ‚SELECT d.id as `key`, d.id, d.name, d.description, d.calculation, d.status\_link, b.\* FROM s\_premium\_dispatch d INNER JOIN (SELECT ‚1‘ as `instock`,‚1‘ as `stockmin`,‚1‘ as `laststock`,‚0.050‘ as `weight`,‚1‘ as `count_article`,‚0‘ as `shippingfree`,‚16‘ as `amount`,‚14.86‘ as `amount_net`,‚16.00‘ as `amount_display`,‚8.000‘ as `length`,‚4.000‘ as `height`,‚4.000‘ as `width`,‘’ as `userID`,‚0‘ as `has_topseller`,‚‘ as `has_comment`,‚0‘ as `has_esd`,‚7.7‘ as `max_tax`,‚0‘ as `basketStateId`,‚26‘ as `countryID`,‚18‘ as `paymentID`,‚1‘ as `customergroupID`,‚1‘ as `multishopID`,‚e715e89b6bffb8278d7fe4a6577a0280‘ as `sessionID`) b ON 1=1 INNER JOIN s\_premium\_dispatch\_countries dc ON d.id = dc.dispatchID AND dc.countryID=b.countryID INNER JOIN s\_premium\_dispatch\_paymentmeans dp ON d.id = dp.dispatchID AND dp.paymentID=b.paymentID LEFT JOIN s\_premium\_holidays h ON h.date = CURDATE() LEFT JOIN s\_premium\_dispatch\_holidays dh ON d.id=dh.dispatchID AND h.id=dh.holidayID LEFT JOIN (SELECT dc.dispatchID FROM s\_order\_basket b INNER JOIN s\_articles\_categories\_ro ac ON ac.articleID = b.articleID INNER JOIN s\_premium\_dispatch\_categories dc ON dc.categoryID = ac.categoryID WHERE (b.modus = 0) AND (b.sessionID = ?) GROUP BY dc.dispatchID) dk ON dk.dispatchID=d.id LEFT JOIN s\_user u ON u.id=b.userID AND u.active=1 LEFT JOIN s\_user\_addresses ub ON ub.user\_id = u.id AND ub.id = ? LEFT JOIN s\_user\_addresses us ON us.user\_id = u.id AND us.id = ? WHERE (d.active = 1) AND ((
(bind\_time\_from IS NULL AND bind\_time\_to IS NULL)
OR
(IFNULL(bind\_time\_from,0) \<= IFNULL(bind\_time\_to,86400) AND TIME\_TO\_SEC(DATE\_FORMAT(NOW(),„%H:%i:00“)) BETWEEN IFNULL(bind\_time\_from,0) AND IFNULL(bind\_time\_to,86400))
OR
(bind\_time\_from \> bind\_time\_to AND TIME\_TO\_SEC(DATE\_FORMAT(NOW(),„%H:%i:00“)) NOT BETWEEN bind\_time\_to AND bind\_time\_from)
)) AND ((
(bind\_weekday\_from IS NULL AND bind\_weekday\_to IS NULL)
OR
(IFNULL(bind\_weekday\_from,1) \<= IFNULL(bind\_weekday\_to,7) AND WEEKDAY(NOW())+1 BETWEEN IFNULL(bind\_weekday\_from,1) AND IFNULL(bind\_weekday\_to,7))
OR
(bind\_weekday\_from \> bind\_weekday\_to AND WEEKDAY(NOW())+1 NOT BETWEEN bind\_weekday\_to AND bind\_weekday\_from)
)) AND ((bind\_weight\_from IS NULL OR bind\_weight\_from \<= b.weight)) AND ((bind\_weight\_to IS NULL OR bind\_weight\_to \>= b.weight)) AND ((bind\_price\_from IS NULL OR bind\_price\_from \<= b.amount)) AND ((bind\_price\_to IS NULL OR bind\_price\_to \>= b.amount)) AND ((bind\_instock=0 OR bind\_instock IS NULL OR (bind\_instock=1 AND b.instock) OR (bind\_instock=2 AND b.stockmin))) AND ((bind\_laststock=0 OR (bind\_laststock=1 AND b.laststock))) AND ((bind\_shippingfree!=1 OR NOT b.shippingfree)) AND (dh.holidayID IS NULL) AND ((d.multishopID IS NULL OR d.multishopID=b.multishopID)) AND ((d.customergroupID IS NULL OR d.customergroupID=b.customergroupID)) AND (dk.dispatchID IS NULL) AND (d.type IN (0)) AND ((d.id != 9 OR (has\_bulky\_goods))) GROUP BY d.id ORDER BY d.position, d.name ASC’ with params („e715e89b6bffb8278d7fe4a6577a0280“, 0, 0):
SQLSTATE(42S22): Column not found: 1054 Unknown column ‚has\_bulky\_goods‘ in ‚where clause‘
---
### Author:  [@SCOOPEX](https://forum.shopware.com/u/SCOOPEX)
#### Post date: [21. November 2023 um 11:01 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/2 "2023-11-21T11:01:46Z")
Hi,
> [@muroshi](#):
>
> SQLSTATE(42S22): Column not found: 1054 Unknown column ‚has\_bulky\_goods‘ in ‚where clause‘
… da fehlt eine Spalte in einer Tabelle - evtl. wurde ein Plugin nicht sauber deinstalliert ?
Da hilft evtl. nur ein Backup Restore.
Viele Grüße
---
### Author:  [@sacrofano](https://forum.shopware.com/u/sacrofano)
#### Post date: [21. November 2023 um 12:18 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/3 "2023-11-21T12:18:55Z")
Du musst das Freitextfeld „has\_bulky\_goods“ erst anlegen.
> **[Shopware 5 - Einstellungen - Freitextfelder / Attribute](https://docs.shopware.com/de/shopware-5-de/einstellungen/freitextfelder-attribute)**
>
> Mit Hilfe der Freitextfeld-Verwaltung kannst Du quasi allem in Shopware Freitextfelder geben und diese ganz individuell nutzen: Sei es, um Artikel als Sperrgut zu kennzeichnen oder Kunden als Bonuskunden zu markieren. Die Möglichkeiten der...
Dann die Sperrgutartikel auch in der Datenbank markieren.
---
### Author:  [@muroshi](https://forum.shopware.com/u/muroshi)
#### Post date: [22. November 2023 um 09:40 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/4 "2023-11-22T09:40:02Z")
Die aktuelle Fehlermeldung:
```auto
An exception occurred while executing 'SELECT d.id as `key`, d.id, d.name, d.description, d.calculation, d.status_link, b.* FROM s_premium_dispatch d INNER JOIN (SELECT '1' as `instock`,'0' as `stockmin`,'0' as `laststock`,'1.100' as `weight`,'1' as `count_article`,'0' as `shippingfree`,'41' as `amount`,'38.07' as `amount_net`,'41.00' as `amount_display`,'170.000' as `length`,'30.000' as `height`,'50.000' as `width`,'' as `userID`,'0' as `has_topseller`,'' as `has_comment`,'0' as `has_esd`,'7.7' as `max_tax`,'0' as `basketStateId`,'26' as `countryID`,'18' as `paymentID`,'1' as `customergroupID`,'1' as `multishopID`,'96fd5d1b10d15e6697d665d75bddf0e8' as `sessionID`) b ON 1=1 INNER JOIN s_premium_dispatch_countries dc ON d.id = dc.dispatchID AND dc.countryID=b.countryID INNER JOIN s_premium_dispatch_paymentmeans dp ON d.id = dp.dispatchID AND dp.paymentID=b.paymentID LEFT JOIN s_premium_holidays h ON h.date = CURDATE() LEFT JOIN s_premium_dispatch_holidays dh ON d.id=dh.dispatchID AND h.id=dh.holidayID LEFT JOIN (SELECT dc.dispatchID FROM s_order_basket b INNER JOIN s_articles_categories_ro ac ON ac.articleID = b.articleID INNER JOIN s_premium_dispatch_categories dc ON dc.categoryID = ac.categoryID WHERE (b.modus = 0) AND (b.sessionID = ?) GROUP BY dc.dispatchID) dk ON dk.dispatchID=d.id LEFT JOIN s_user u ON u.id=b.userID AND u.active=1 LEFT JOIN s_user_addresses ub ON ub.user_id = u.id AND ub.id = ? LEFT JOIN s_user_addresses us ON us.user_id = u.id AND us.id = ? WHERE (d.active = 1) AND ((
(bind_time_from IS NULL AND bind_time_to IS NULL)
OR
(IFNULL(bind_time_from,0) <= IFNULL(bind_time_to,86400) AND TIME_TO_SEC(DATE_FORMAT(NOW(),"%H:%i:00")) BETWEEN IFNULL(bind_time_from,0) AND IFNULL(bind_time_to,86400))
OR
(bind_time_from > bind_time_to AND TIME_TO_SEC(DATE_FORMAT(NOW(),"%H:%i:00")) NOT BETWEEN bind_time_to AND bind_time_from)
)) AND ((
(bind_weekday_from IS NULL AND bind_weekday_to IS NULL)
OR
(IFNULL(bind_weekday_from,1) <= IFNULL(bind_weekday_to,7) AND WEEKDAY(NOW())+1 BETWEEN IFNULL(bind_weekday_from,1) AND IFNULL(bind_weekday_to,7))
OR
(bind_weekday_from > bind_weekday_to AND WEEKDAY(NOW())+1 NOT BETWEEN bind_weekday_to AND bind_weekday_from)
)) AND ((bind_weight_from IS NULL OR bind_weight_from <= b.weight)) AND ((bind_weight_to IS NULL OR bind_weight_to >= b.weight)) AND ((bind_price_from IS NULL OR bind_price_from <= b.amount)) AND ((bind_price_to IS NULL OR bind_price_to >= b.amount)) AND ((bind_instock=0 OR bind_instock IS NULL OR (bind_instock=1 AND b.instock) OR (bind_instock=2 AND b.stockmin))) AND ((bind_laststock=0 OR (bind_laststock=1 AND b.laststock))) AND ((bind_shippingfree!=1 OR NOT b.shippingfree)) AND (dh.holidayID IS NULL) AND ((d.multishopID IS NULL OR d.multishopID=b.multishopID)) AND ((d.customergroupID IS NULL OR d.customergroupID=b.customergroupID)) AND (dk.dispatchID IS NULL) AND (d.type IN (0)) AND ((d.id != 9 OR (has_bulky_goods))) GROUP BY d.id ORDER BY d.position, d.name ASC' with params ("96fd5d1b10d15e6697d665d75bddf0e8", 0, 0):
SQLSTATE(42S22): Column not found: 1054 Unknown column 'has_bulky_goods' in 'where clause'
```
Hier die Screenshots:
Gemäss dieser Anleitung bis und mit Schritt 9:
> **[Eine Sperrgut-Versandart für bestimmte Artikel erzwingen (optional)](https://help-sw5.pickware.com/hc/de/articles/360007714218)**
>
> Da für Sperrgut beispielsweise von DHL und UPS ein nicht unerheblicher Aufschlag berechnet wird, ist es wünschenswert, für Bestellungen mit bestimmten Artikeln nur Sperrgut-Versandarten zu aktivier...
---
### Author:  [@sacrofano](https://forum.shopware.com/u/sacrofano)
#### Post date: [22. November 2023 um 09:50 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/5 "2023-11-22T09:50:21Z")
> [@muroshi](#):
>
> `has_bulky_goods`
Dann scheinst du einen Fehler in den Schritten 1-4 zu haben.
---
### Author:  [@muroshi](https://forum.shopware.com/u/muroshi)
#### Post date: [22. November 2023 um 11:09 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/6 "2023-11-22T11:09:57Z")
Habe ich eigentlich so angelegt:
---
### Author:  [@sacrofano](https://forum.shopware.com/u/sacrofano)
#### Post date: [22. November 2023 um 11:40 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/7 "2023-11-22T11:40:31Z")
Ich sehe auch keinen Fehler.
> Blockzitat
> An exception occurred while executing ‚SELECT d.id as `key`, d.id, d.name, d.description, d.calculation, d.status\_link, b.\* FROM s\_premium\_dispatch d INNER JOIN (SELECT ‚1‘ as `instock`,‚1‘ as `stockmin`,‚1‘ as `laststock`,‚0.050‘ as `weight`,‚1‘ as `count_article`,‚0‘ as `shippingfree`,‚16‘ as `amount`,‚14.86‘ as `amount_net`,‚16.00‘ as `amount_display`,‚8.000‘ as `length`,‚4.000‘ as `height`,‚4.000‘ as `width`,‘’ as `userID`,‚0‘ as `has_topseller`,‚‘ as `has_comment`,‚0‘ as `has_esd`
In deiner Fehlermeldung müsste dei Variable direkt hinter „has\_esd“ stehen. Hast du den Cache und auch die Shopware Konfiguration gelöscht?
Hier stehen genau die Variablen aus der erweiterten SQL Abfrage, wobei deine Erweiterung ‚has\_bulky\_goods‘ an derStelle fehlt.
---
### Author:  [@muroshi](https://forum.shopware.com/u/muroshi)
#### Post date: [22. November 2023 um 13:56 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/8 "2023-11-22T13:56:45Z")
> [@sacrofano](#):
>
> > ``
Ich habe den Verstandkosten „has\_bulky\_goods“ wieder entfernt. Ansonsten kann man man derzeit nicht bestellen. Was soll ich tun, um das Problem zu lösen? Der Eintrag im Versandkosten-Modul habe ich laut der Anleitung gemacht.
---
### Author:  [@sacrofano](https://forum.shopware.com/u/sacrofano)
#### Post date: [22. November 2023 um 18:56 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/9 "2023-11-22T18:56:59Z")
Abgesehen davon, dass es so im Normalfall funktioniert, könntest du auch die Gewichte der Sperrgutartikel z.B. auf 33,333 manuell anheben, damit andere Versandkosten berechnet werden. Dann brauchts du die Extravariable nicht.
---
### Author:  [@muroshi](https://forum.shopware.com/u/muroshi)
#### Post date: [18. Januar 2024 um 08:35 UTC](https://forum.shopware.com/t/errormeldungen-bulky-goods/101996/10 "2024-01-18T08:35:38Z")
> [@sacrofano](#):
>
> 33,333
Geht nicht, da ein Versandkostenfreibetrag existiert, den ich für Sperrgutartikel nicht möchte.