# Error when updating from 6.5.8.12 to the latest version (v6.6.4.1)

**URL:** <https://forum.shopware.com/t/error-when-updating-from-6-5-8-12-to-the-latest-version-v6-6-4-1/104942>\
**Category:** Shopware 6 (English)\
**Created:** [23. August 2024 um 08:46 UTC](https://forum.shopware.com/t/error-when-updating-from-6-5-8-12-to-the-latest-version-v6-6-4-1/104942 "2024-08-23T08:46:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tecsee](https://avatars.discourse-cdn.com/v4/letter/t/a9adbd/32.png) [@Tecsee](https://forum.shopware.com/u/Tecsee)\
**Post date:** [23. August 2024 um 08:46 UTC](https://forum.shopware.com/t/error-when-updating-from-6-5-8-12-to-the-latest-version-v6-6-4-1/104942/1 "2024-08-23T08:46:41Z")

</div>

Hi everyone,

After updating from version 6.5.8.12 to the latest version (v6.6.4.1), I encountered an error message on the frontend. The error message displayed on the shop pages is:

```auto
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cart.payload' in 'field list'

```

 ![image-20240802-091002](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/3X/d/8/d878767151fc7549c936edacb9218dc8ecc50083.png)

Has anyone else faced this issue, or does anyone know how to resolve it? Any help would be appreciated!

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [26. August 2024 um 19:13 UTC](https://forum.shopware.com/t/error-when-updating-from-6-5-8-12-to-the-latest-version-v6-6-4-1/104942/2 "2024-08-26T19:13:35Z")

</div>

Looks like your database schema got corrupted.

Maybe this could help, never done it before. But create a backup first!

> **[Shopware 6 - Nutzung der CLI Befehle](https://docs.shopware.com/de/shopware-6-de/tutorials-und-faq/shopware-cli#datenbank)**
>
> Shopware 6 bietet einige nützliche Tools die über die Konsole ausgeführt werden können. Die sogenannten "CLI" Befehle können außerhalb von Skript-Limitierungen (Beispiel: Skriptlaufzeit des Servers) ausgeführt werden und sind daher bei der...

Else run the latest update again.

---

<div class="post-metadata">

**Author:** ![jan.mtsn](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/jan.mtsn/32/24943_2.png) [@jan.mtsn](https://forum.shopware.com/u/jan.mtsn)\
**Post date:** [29. Oktober 2024 um 15:22 UTC](https://forum.shopware.com/t/error-when-updating-from-6-5-8-12-to-the-latest-version-v6-6-4-1/104942/3 "2024-10-29T15:22:27Z")

</div>

We just ran into the same issue. The problem is caused by a wrongly implemented database migration (`\Shopware\Core\Migration\V6_4\Migration1648709176CartCompression`). I expect you didn’t run `bin/console system:update:prepare` and `bin/console system:update:finish` on your shop and just execute the database migrations via `bin/console database:migrate --all`. The missing `payload` column will be created in an updateDestructive method which will not be executed when you only run `bin/console database:migrate --all`. Like the documentation says only destructive database operations should be executed in the updateDestructive method, but shopware also creates the new column there and not in the `update` method.

> In the update() method you implement non-destructive changes which should always be reversible. The updateDestructive() method is the follow up step, that is run after update() and used for destructive none reversible changes, like dropping columns or tables. Destructive migrations are only executed explicitly.  
> [Database Migrations | Shopware Documentation](https://developer.shopware.com/docs/guides/plugins/plugins/plugin-fundamentals/database-migrations.html)