Hallo Betatester...
--------------------------------------------------------------------------------------------------------------------
Mein lauffähiges PROD-System ist 1.5.40 JTL und Shopware 5.xxx ( eine der letzten Verisonen )
--------------------------------------------------------------------------------------------------------------------
ich habe gestern folgendes gemacht, um Shopware 6 und JTL WaWi zu testen:
Shopware 6 komplett leer installiert...
in JTL einen neuen TEST-Mandanten angelegt...
den aktuellen PROD-Mandanten exportiert und in den TEST-Mandanten importiert
den neuen Beta- Connector eingerichtet.
und dann so ca. 50 Artikel in den neuen TEST- Shop innerhalb der WaWi ( Artikel -> rechte Maustaste -> Onlineshop aktivieren, sodaß die grün werden )
Komplettabgleich Onlineshop...
und da kommen viele Constraint - Errors... und ganz am Anfang hat er einen NOT NULL- Error ... Kann mir jemand erklären, was ich in der WAWI ändern muß?
Es können ja nur MEDIA_ID oder COLRO_HEX_CODE sein.. Aber was muß ich in der WAWI ändern, wenn das der Auslöser für die folgenden Constraint-Error ist ?
Viele Grüße
Tino
-------------------------------------------------------------------------------------
Abgleich-Protokoll:
Bitte beachten Sie, dass JTL-Wawi federführend ist!
Im Shop-Backend vorgenommene Änderungen können nicht mehr automatisiert abgeglichen werden und führen somit zu Datenverlust.
Prüfe Endpointkonfiguration.
Abgleich gestartet für 'Goldriesling'.
Gesendet: Hersteller (9 Stück)
Onlineshop-Abgleich beendet für 'Goldriesling'.
Fehler:
Exception: Controller = Specific | Action = push | JTL-Wawi PK = 2 | Name = Alkoholgehalt | [b62b0cee-6d0b-48fa-8bc6-7e940c5d965e] The Shopware 6 Admin API responded with errors:
Code = c1051bb4-d103-4f74-8988-acbcafc7fdc3 | Status = 400 | Detail = Dieser Wert sollte nicht leer sein. | Pointer = /0/options/37/translations/2fbb5fe2e29a4d70aa5854ce7ce3e20b/name
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xa2\xcb\xeb\xaa\x1a\x35\x47\x19\x9d\xb0\x92\xa1\xfa\x1e\xc8\x68", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.327"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xdc\xb2\x38\x2e\x7e\xa8\x41\x6b\xa1\xfe\xfe\x02\xde\xd4\xac\xba", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.340"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xdd\xe3\x1d\xd0\x76\x52\x40\x9c\x81\x7d\xcb\xf1\x32\x3e\x6b\x57", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.342"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xb3\xd7\x1f\x47\xc6\xcd\x4f\xd1\x88\xff\x36\x1c\x4d\x74\x04\x74", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.344"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x6e\x67\xcd\x75\xee\xbc\x4a\x57\x9f\xe0\x63\x6b\xa6\x40\x36\xc7", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.345"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x34\x90\x02\x6b\x95\x0f\x47\xaa\x81\x5d\x33\x08\x3f\x55\xaf\x49", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.347"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x3d\x5f\x2b\x77\xb3\x17\x48\xae\x89\xfd\xb5\xd1\x76\x9d\x43\xf2", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.349"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xec\x91\xa5\xd9\xff\xef\x4d\x04\x95\x4f\xdf\x20\x6a\xa5\x67\x91", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.351"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xcf\xce\x71\xfa\x24\xb1\x42\x86\xb0\x58\x5a\xca\x8f\xcf\x09\x6a", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.353"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x3a\x59\x3f\xfd\x08\x8f\x4d\xc5\xbe\x61\x48\xa4\xc6\xdd\xb7\x10", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.354"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x66\x07\x71\x80\x1d\xd4\x4c\x1f\xad\x4c\xcb\xb2\x0f\x87\x1e\xb2", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.360"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x55\x14\xa4\xc7\x08\x4a\x49\xb0\xa6\x3e\xd0\xba\x06\x7d\x82\x95", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.361"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xb4\x5d\xe1\xd8\xb3\xf3\x4a\x42\x9a\xca\x30\xe8\xb4\x4f\x09\xa7", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.364"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exc
--------------------------------------------------------------------------------------------------------------------
Mein lauffähiges PROD-System ist 1.5.40 JTL und Shopware 5.xxx ( eine der letzten Verisonen )
--------------------------------------------------------------------------------------------------------------------
ich habe gestern folgendes gemacht, um Shopware 6 und JTL WaWi zu testen:
Shopware 6 komplett leer installiert...
in JTL einen neuen TEST-Mandanten angelegt...
den aktuellen PROD-Mandanten exportiert und in den TEST-Mandanten importiert
den neuen Beta- Connector eingerichtet.
und dann so ca. 50 Artikel in den neuen TEST- Shop innerhalb der WaWi ( Artikel -> rechte Maustaste -> Onlineshop aktivieren, sodaß die grün werden )
Komplettabgleich Onlineshop...
und da kommen viele Constraint - Errors... und ganz am Anfang hat er einen NOT NULL- Error ... Kann mir jemand erklären, was ich in der WAWI ändern muß?
Es können ja nur MEDIA_ID oder COLRO_HEX_CODE sein.. Aber was muß ich in der WAWI ändern, wenn das der Auslöser für die folgenden Constraint-Error ist ?
Viele Grüße
Tino
-------------------------------------------------------------------------------------
Abgleich-Protokoll:
Bitte beachten Sie, dass JTL-Wawi federführend ist!
Im Shop-Backend vorgenommene Änderungen können nicht mehr automatisiert abgeglichen werden und führen somit zu Datenverlust.
Prüfe Endpointkonfiguration.
Abgleich gestartet für 'Goldriesling'.
Gesendet: Hersteller (9 Stück)
Onlineshop-Abgleich beendet für 'Goldriesling'.
Fehler:
Exception: Controller = Specific | Action = push | JTL-Wawi PK = 2 | Name = Alkoholgehalt | [b62b0cee-6d0b-48fa-8bc6-7e940c5d965e] The Shopware 6 Admin API responded with errors:
Code = c1051bb4-d103-4f74-8988-acbcafc7fdc3 | Status = 400 | Detail = Dieser Wert sollte nicht leer sein. | Pointer = /0/options/37/translations/2fbb5fe2e29a4d70aa5854ce7ce3e20b/name
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xa2\xcb\xeb\xaa\x1a\x35\x47\x19\x9d\xb0\x92\xa1\xfa\x1e\xc8\x68", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.327"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xdc\xb2\x38\x2e\x7e\xa8\x41\x6b\xa1\xfe\xfe\x02\xde\xd4\xac\xba", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.340"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xdd\xe3\x1d\xd0\x76\x52\x40\x9c\x81\x7d\xcb\xf1\x32\x3e\x6b\x57", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.342"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xb3\xd7\x1f\x47\xc6\xcd\x4f\xd1\x88\xff\x36\x1c\x4d\x74\x04\x74", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.344"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x6e\x67\xcd\x75\xee\xbc\x4a\x57\x9f\xe0\x63\x6b\xa6\x40\x36\xc7", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.345"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x34\x90\x02\x6b\x95\x0f\x47\xaa\x81\x5d\x33\x08\x3f\x55\xaf\x49", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.347"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x3d\x5f\x2b\x77\xb3\x17\x48\xae\x89\xfd\xb5\xd1\x76\x9d\x43\xf2", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.349"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xec\x91\xa5\xd9\xff\xef\x4d\x04\x95\x4f\xdf\x20\x6a\xa5\x67\x91", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.351"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xcf\xce\x71\xfa\x24\xb1\x42\x86\xb0\x58\x5a\xca\x8f\xcf\x09\x6a", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.353"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x3a\x59\x3f\xfd\x08\x8f\x4d\xc5\xbe\x61\x48\xa4\xc6\xdd\xb7\x10", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.354"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x66\x07\x71\x80\x1d\xd4\x4c\x1f\xad\x4c\xcb\xb2\x0f\x87\x1e\xb2", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.360"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\x55\x14\xa4\xc7\x08\x4a\x49\xb0\xa6\x3e\xd0\xba\x06\x7d\x82\x95", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.361"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exception occurred while executing 'INSERT INTO `property_group_option` (`id`, `property_group_id`, `media_id`, `color_hex_code`, `created_at`) VALUES (?, ?, ?, ?, ?)' with params ["\xb4\x5d\xe1\xd8\xb3\xf3\x4a\x42\x9a\xca\x30\xe8\xb4\x4f\x09\xa7", "\xae\xfc\x86\xab\x8f\x3d\x4f\x9f\xbb\x17\x29\x20\xa1\x3d\xc3\x01", null, null, "2021-03-11 14:14:20.364"]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`goldriesling`.`property_group_option`, CONSTRAINT `fk.property_group_option.property_group_id` FOREIGN KEY (`property_group_id`) REFERENCES `property_group` (`id`) ON DELETE CASCADE ON UPDATE)
Code = 0 | Status = 500 | Detail = An exc