Issue Bug Under Review Stale

#105005Webhooks Exception if invalid JSON in database field additional_headers

Benjamin Franzke 09/17/24, 12:34 updated 08/15/26, 23:17

Description

Given the following data in sys_webhook an exception is thrown upon opening the webhooks backend module:

| uid | pid | updatedon  | createdon  | deleted | disabled | starttime | endtime | description | name       | url                                     | method | secret                                                                                            | webhook_type                               | identifier                           | verify_ssl | additional_headers |

|   4 |   0 | 1707312708 | 1707312708 |       0 |        0 |         0 |       0 |             |            |                                         | POST   |                                                                                                   | typo3/redirect-was-hit                     | 012207ce-c08b-4c67-9455-1e233efbe87d |          1 | Array              |

webhooks-exception-invalid-json.png

(1/2) Doctrine\DBAL\Types\Exception\ValueNotConvertible
Could not convert database value to "json" as an error was triggered by the unserialization: Syntax error

in /var/www/html/TYPO3.CMS/vendor/doctrine/dbal/src/Types/Exception/ValueNotConvertible.php line 42

Reviews 2

History 413

  1. Stefan Bürk commented <span data-processor="relativetime" data-value="2024-09-17T15:48:47+00:00" > 09/17/24, 15:48 </span>

    I would love to know how this value ended up in the database at all.
    Reading should be fixed, but also the writing if we find out how that
    happend.

  2. Stefan Bürk commented <span data-processor="relativetime" data-value="2024-09-17T15:50:16+00:00" > 09/17/24, 15:50 </span>

    Stefan Bürk wrote in #note-1:
    > I would love to know how this value ended up in the database at all.
    > Reading should be fixed, but also the writing if we find out how that
    > happend.

    I guess that happend because of Bug #105004