#105004PHP Warning: Array to string conversion when persisting JSON data (persists "Array" if warnings are silenced)
Description
Version: 13.3.0
Steps to reproduce:
composer create-project typo3/cms-base-distribution project-name ^13
Install via vendor/bin/typo3 setup
Database: sqlite
Module: Webhooks > Create new record
Select trigger “typo3/file-added“
Add name: foobar,
URL: http://127.0.0.1/
Secret: press dice-button
Press Save
Exception/Warning:
PHP Warning: Array to string conversion in […]/vendor/doctrine/dbal/src/Driver/PDO/Statement.php line 26
(1/1) #1476107295 TYPO3\CMS\Core\Error\Exception
PHP Warning: Array to string conversion in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Driver/PDO/Statement.php line 26
in /home/ben/src/test-13-3/vendor/typo3/cms-core/Classes/Error/ErrorHandler.php line 138
}
$message = self::ERROR_LEVEL_LABELS[$errorLevel] . ': ' . $errorMessage . ' in ' . $errorFile . ' line ' . $errorLine;
if ($errorLevel & $this->exceptionalErrors) {
throw new Exception($message, 1476107295);
}
$message = $this->getFormattedLogMessage($message);
at TYPO3\CMS\Core\Error\ErrorHandler->handleError()
at PDOStatement->bindValue()
in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Driver/PDO/Statement.php line 26
{
$pdoType = $this->convertParamType($type);
try {
$this->stmt->bindValue($param, $value, $pdoType);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
}
at Doctrine\DBAL\Driver\PDO\Statement->bindValue()
in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php line 19
}
public function bindValue(int|string $param, mixed $value, ParameterType $type): void
{
$this->wrappedStatement->bindValue($param, $value, $type);
}
public function execute(): Result
{
at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->bindValue()
in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Connection.php line 1243
} else {
$bindingType = ParameterType::STRING;
}
$stmt->bindValue($bindIndex, $value, $bindingType);
++$bindIndex;
}
} else {
at Doctrine\DBAL\Connection->bindParameters()
in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Connection.php line 865
[$sql, $params, $types] = $this->expandArrayParameters($sql, $params, $types);
$stmt = $connection->prepare($sql);
$this->bindParameters($stmt, $params, $types);
return $stmt->execute()
->rowCount();
}
at Doctrine\DBAL\Connection->executeStatement()
in /home/ben/src/test-13-3/vendor/doctrine/dbal/src/Connection.php line 510
$values[] = $value;
$set[] = '?';
}
return $this->executeStatement(
'INSERT INTO ' . $table . ' (' . implode(', ', $columns) . ')' .
' VALUES (' . implode(', ', $set) . ')',
$values,
is_string(key($types)) ? $this->extractTypeValues($columns, $types) : $types,
at Doctrine\DBAL\Connection->insert()
in /home/ben/src/test-13-3/vendor/typo3/cms-core/Classes/Database/Connection.php line 192
*/
public function insert(string $tableName, array $data, array $types = []): int
{
$this->ensureDatabaseValueTypes($tableName, $data, $types);
return parent::insert(
$this->quoteIdentifier($tableName),
$this->quoteColumnValuePairs($data),
$this->quoteColumnTypes($types)
);
at TYPO3\CMS\Core\Database\Connection->insert()
in /home/ben/src/test-13-3/vendor/typo3/cms-core/Classes/DataHandling/DataHandler.php line 7721
$connection = $this->connectionPool->getConnectionForTable($table);
$insertErrorMessage = '';
try {
// Execute the INSERT query:
$connection->insert($table, $fieldArray);
} catch (DBALException $e) {
$insertErrorMessage = $e->getPrevious()->getMessage();
}
// If succees, do...:
at TYPO3\CMS\Core\DataHandling\DataHandler->insertDB()
in /home/ben/src/test-13-3/vendor/typo3/cms-core/Classes/DataHandling/DataHandler.php line 1080
$this->insertDB($table, $id, $fieldArray, true, (int)($incomingFieldArray['uid'] ?? 0));
// Hold auto-versionized ids of placeholders
$this->autoVersionIdMap[$table][$this->substNEWwithIDs[$id]] = $this->substNEWwithIDs[$id];
} else {
$this->insertDB($table, $id, $fieldArray, false, (int)($incomingFieldArray['uid'] ?? 0));
}
} else {
if ($table === 'pages') {
// Only a certain number of fields needs to be checked for updates,
at TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap()
in /home/ben/src/test-13-3/vendor/typo3/cms-backend/Classes/Controller/EditDocumentController.php line 554
}
// Perform the saving operation with DataHandler:
if ($this->doSave === true) {
$tce->process_datamap();
$tce->process_cmdmap();
// Update the module menu for the current backend user, as they updated their UI language
$currentUserId = $beUser->getUserId();