# Column temporaryID cannot be null

**URL:** <https://forum.shopware.com/t/column-temporaryid-cannot-be-null/87599>\
**Category:** Shopware 5\
**Created:** [11. Mai 2021 um 12:30 UTC](https://forum.shopware.com/t/column-temporaryid-cannot-be-null/87599 "2021-05-11T12:30:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\
**Post date:** [11. Mai 2021 um 12:30 UTC](https://forum.shopware.com/t/column-temporaryid-cannot-be-null/87599/1 "2021-05-11T12:30:57Z")

</div>

Bei einem Kundenshop von uns tauchte bei einer Bestellung plötzlich diese Fehlermeldung auf:

> core.ERROR: PDOException: SQLSTATE[23000]:  
> Integrity constraint violation: 1048 Column ‚temporaryID‘ cannot be null in /var/…/engine/Library/Zend/Db/Statement/Pdo.php:219

Welche Ursachen könnten sein, wenn „temporaryID“ keinen Wert hat? Session-Problem? Proxy-Problem?

---

<div class="post-metadata">

**Author:** ![Andy453](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Andy453](https://forum.shopware.com/u/Andy453)\
**Post date:** [12. Mai 2021 um 17:27 UTC](https://forum.shopware.com/t/column-temporaryid-cannot-be-null/87599/2 "2021-05-12T17:27:25Z")

</div>

Replace 0 with any value you want[.](https://www.prepaidgiftbalance.vip/)

```auto
insert into TABLE1 (id,table2id)
values
(
    1,
    COALESCE((SELECT DISTINCT id FROM TABLE2 as table2 WHERE table2.data = 'ABC'),0))
);

```