Invalid datetime format: 1292 Incorrect datetime value

[xXSchrandXx]

SQL Version: ???

System Information

PHP Version:

8.2.9

WoltLab Suite Core:

6.0.2

Peak Memory Usage:

15.282/256 MiB

Request URI:

POST /assets-management/asset-add/

Referrer:

https://domain.xy/assets-management/asset-add/

User Agent:

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36

Original Error

Error Message:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2023-11-21T05:37:33+01:00' for column `xxxxxx`.`assets1_asset`.`lastModification` at row 1

Error Type:

PDOException (22007)

*/lib/system/database/statement/PreparedStatement.class.php:125

Stack Trace

#0 PDOStatement->execute([ 9 items ])
*/lib/system/database/statement/PreparedStatement.class.php:125
#1 wcf\system\database\statement\PreparedStatement->execute([ 9 items ])
*/lib/data/TFastCreate.class.php:43
#2 wcf\data\DatabaseObjectEditor::dboEditorCreateBase([ 9 items ])
*/lib/data/DatabaseObjectEditor.class.php:27
#3 wcf\data\DatabaseObjectEditor::create([ 9 items ])
*/assets-management/lib/data/asset/AssetEditor.class.php:45
#4 assets\data\asset\AssetEditor::create([ 9 items ])
*/lib/data/AbstractDatabaseObjectAction.class.php:354
#5 wcf\data\AbstractDatabaseObjectAction->create()
*/assets-management/lib/data/asset/AssetAction.class.php:65
#6 assets\data\asset\AssetAction->create()
*/lib/data/AbstractDatabaseObjectAction.class.php:215
#7 wcf\data\AbstractDatabaseObjectAction->executeAction()
*/lib/form/AbstractFormBuilderForm.class.php:187
#8 wcf\form\AbstractFormBuilderForm->save()
*/lib/form/AbstractForm.class.php:79
#9 wcf\form\AbstractForm->submit()
*/lib/form/AbstractForm.class.php:151
#10 wcf\form\AbstractForm->readData()
*/lib/form/AbstractFormBuilderForm.class.php:146
#11 wcf\form\AbstractFormBuilderForm->readData()
*/lib/page/AbstractPage.class.php:349
#12 wcf\page\AbstractPage->show()
*/lib/page/AbstractPage.class.php:134
#13 wcf\page\AbstractPage->__run()
*/lib/system/request/Request.class.php:57
#15 wcf\http\Pipeline->process(Laminas\Diactoros\ServerRequest, wcf\http\RequestHandlerMiddleware)
*/lib/system/request/RequestHandler.class.php:147
#16 wcf\system\request\RequestHandler->handle('assets')
*/assets-management/index.php:4
Final Error

Error Message:

Could not execute statement 'INSERT INTO assets1_asset (title,categoryID,amount,locationID,description,lastModification,lastAudit,time,nextAudit) VALUES (?,?,?,?,?,?,?,?,?)'

Error Type:

wcf\system\database\exception\DatabaseQueryExecutionException (22007)

*/lib/system/database/statement/PreparedStatement.class.php:143

Query Parameter 1:

'AssetTitle'

Query Parameter 2:

'78'

Query Parameter 3:

1

Query Parameter 4:

'79'

Query Parameter 5:

'AssetDescription'

Query Parameter 6:

'2023-11-21T05:37:33+01:00'

Query Parameter 7:

'2023-11-21T05:37:33+01:00'

Query Parameter 8:

'2023-11-21T05:37:33+01:00'

Query Parameter 9:

'2024-02-21'

Stack Trace

#0 wcf\system\database\statement\PreparedStatement->execute([ 9 items ])
*/lib/data/TFastCreate.class.php:43
#1 wcf\data\DatabaseObjectEditor::dboEditorCreateBase([ 9 items ])
*/lib/data/DatabaseObjectEditor.class.php:27
#2 wcf\data\DatabaseObjectEditor::create([ 9 items ])
*/assets-management/lib/data/asset/AssetEditor.class.php:45
#3 assets\data\asset\AssetEditor::create([ 9 items ])
*/lib/data/AbstractDatabaseObjectAction.class.php:354
#4 wcf\data\AbstractDatabaseObjectAction->create()
*/assets-management/lib/data/asset/AssetAction.class.php:65
#5 assets\data\asset\AssetAction->create()
*/lib/data/AbstractDatabaseObjectAction.class.php:215
#6 wcf\data\AbstractDatabaseObjectAction->executeAction()
*/lib/form/AbstractFormBuilderForm.class.php:187
#7 wcf\form\AbstractFormBuilderForm->save()
*/lib/form/AbstractForm.class.php:79
#8 wcf\form\AbstractForm->submit()
*/lib/form/AbstractForm.class.php:151
#9 wcf\form\AbstractForm->readData()
*/lib/form/AbstractFormBuilderForm.class.php:146
#10 wcf\form\AbstractFormBuilderForm->readData()
*/lib/page/AbstractPage.class.php:349
#11 wcf\page\AbstractPage->show()
*/lib/page/AbstractPage.class.php:134
#12 wcf\page\AbstractPage->__run()
*/lib/system/request/Request.class.php:57
#13 wcf\system\request\Request->handle(Laminas\Diactoros\ServerRequest)
*/lib/http/middleware/HandleValinorMappingErrors.class.php:35
#14 wcf\http\Pipeline->process(Laminas\Diactoros\ServerRequest, wcf\http\RequestHandlerMiddleware)
*/lib/system/request/RequestHandler.class.php:147
#15 wcf\system\request\RequestHandler->handle('assets')
*/assets-management/index.php:4