# Updatefehler 6.4.20 --\> 6.5.1: SQLSTATE\[HY000\]: General error: 1901

**URL:** <https://forum.shopware.com/t/updatefehler-6-4-20-6-5-1-sqlstate-hy000-general-error-1901/101197>\
**Category:** Shopware 6 (German)\
**Created:** [9. September 2023 um 10:07 UTC](https://forum.shopware.com/t/updatefehler-6-4-20-6-5-1-sqlstate-hy000-general-error-1901/101197 "2023-09-09T10:07:42Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Kai\_Becker](https://avatars.discourse-cdn.com/v4/letter/k/67e7ee/32.png) [@Kai\_Becker](https://forum.shopware.com/u/Kai_Becker)\
**Post date:** [12. März 2024 um 10:28 UTC](https://forum.shopware.com/t/updatefehler-6-4-20-6-5-1-sqlstate-hy000-general-error-1901/101197/7 "2024-03-12T10:28:02Z")

</div>

Version 6.4.14.0 auf 6.4.20

Guten Morgen zusammen - wir haben jetzt MariaDB 10.11.7 im Einsatz und der Shop läuft immer noch auf diese Fehlermeldung:

Received the following error message:  
An exception occurred while executing ‚ALTER TABLE `product` ADD COLUMN `variant_listing_config` JSON GENERATED ALWAYS AS (CASE WHEN `display_parent` IS NOT NULL OR `main_variant_id` IS NOT NULL OR `configurator_group_config` IS NOT NULL THEN (JSON\_OBJECT( ‚displayParent‘, `display_parent`, ‚mainVariantId‘, LOWER(HEX(`main_variant_id`)) ,‚configuratorGroupConfig‘, JSON\_EXTRACT(`configurator_group_config`, ‚$‘))) END) VIRTUAL‘: SQLSTATE[HY000]: General error: 1901 Function or expression ‚variant\_listing\_config‘ cannot be used in the CHECK clause of `variant_listing_config`

Please try to fix this error and restart the update.  
Response  
{„valid“:false,„errorMsg“:"An exception occurred while executing 'ALTER TABLE `product` ADD COLUMN `variant_listing_config` JSON\n GENERATED ALWAYS AS (CASE WHEN `display_parent` IS NOT NULL OR `main_variant_id` IS NOT NULL OR `configurator_group_config` IS NOT NULL\n

---

_[View the full topic](https://forum.shopware.com/t/updatefehler-6-4-20-6-5-1-sqlstate-hy000-general-error-1901/101197)._