Error message when you block an avatar, signature o cover photo and do not set an 'unblocking' date

When you block an avatar, signature or cover photo and the 'Unblocking' date box is blank, this message is generated after pressing the submit button.

Reproduced in a demo installation. You can check the error log.

Quote

An error has occurred

Internal error code: 7d5900f0a714c0b15523ce9f21b3d8d956395235/0004-648CFDE617704

What happened?

An error has occurred while trying to handle your request and execution has been terminated. Please forward the above error code to the site administrator.

The error code can be used by an administrator to lookup the full error message in the Administration Control Panel via “Logs » Errors”. In addition the error has been written to the log file located at */log/2023-06-17.txt and can be accessed with an FTP program or similar.

Notice: The error code was randomly generated and has no use beyond looking up the full message.

System Information

PHP Version:

8.0.29

WoltLab Suite Core:

5.5.12

Peak Memory Usage:

4.15/256 MiB

Request URI:

POST /acp/index.php?user-edit/3/

Referrer:

https://5276bb63.woltlab-demo.com/acp/index.php?user-edit/3/

User Agent:

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

Original Error

Error Type:

PDOException

Error Message:

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'disableSignatureExpires' at row 1

Error Code:

HY000

File:

*/lib/system/database/statement/PreparedStatement.class.php (126)

Stack Trace:

#0 */lib/system/database/statement/PreparedStatement.class.php (126):

PDOStatement->execute([ 21 items ])

#1 */lib/data/DatabaseObjectEditor.class.php (55):

wcf\system\database\statement\PreparedStatement->execute([ 21 items ])

#2 */lib/data/user/UserEditor.class.php (117):

wcf\data\DatabaseObjectEditor->update([ 20 items ])

#3 */lib/data/AbstractDatabaseObjectAction.class.php (388):

wcf\data\user\UserEditor->update([ 20 items ])

#4 */lib/data/user/UserAction.class.php (333):

wcf\data\AbstractDatabaseObjectAction->update()

#5 */lib/data/AbstractDatabaseObjectAction.class.php (216):

wcf\data\user\UserAction->update()

#6 */lib/acp/form/UserEditForm.class.php (496):

wcf\data\AbstractDatabaseObjectAction->executeAction()

#7 */lib/form/AbstractForm.class.php (80):

wcf\acp\form\UserEditForm->save()

#8 */lib/form/AbstractForm.class.php (152):

wcf\form\AbstractForm->submit()

#9 */lib/acp/form/AbstractOptionListForm.class.php (111):

wcf\form\AbstractForm->readData()

#10 */lib/acp/form/UserAddForm.class.php (403):

wcf\acp\form\AbstractOptionListForm->readData()

#11 */lib/acp/form/UserEditForm.class.php (284):

wcf\acp\form\UserAddForm->readData()

#12 */lib/page/AbstractPage.class.php (353):

wcf\acp\form\UserEditForm->readData()

#13 */lib/acp/form/UserAddForm.class.php (454):

wcf\page\AbstractPage->show()

#14 */lib/page/AbstractPage.class.php (135):

wcf\acp\form\UserAddForm->show()

#15 */lib/system/request/Request.class.php (90):

wcf\page\AbstractPage->__run()

#16 */lib/system/request/RequestHandler.class.php (107):

wcf\system\request\Request->execute()

#17 */acp/index.php (11):

wcf\system\request\RequestHandler->handle('wcf', true)

Final Error

Error Type:

wcf\system\database\exception\DatabaseQueryExecutionException

Error Message:

Could not execute statement 'UPDATE wcf1_user SET avatarID = ?, enableGravatar = ?, username = ?, email = ?, languageID = ?, userTitle = ?, signature = ?, styleID = ?, banned = ?, banReason = ?, banExpires = ?, disableSignature = ?, disableSignatureReason = ?, disableSignatureExpires = ?, disableAvatar = ?, disableAvatarReason = ?, disableAvatarExpires = ?, disableCoverPhoto = ?, disableCoverPhotoReason = ?, disableCoverPhotoExpires = ? WHERE userID = ?'

Error Code:

HY000

File:

*/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1:

null

Query Parameter 2:

0

Query Parameter 3:

'test'

Query Parameter 4:

'test@example.com'

Query Parameter 5:

2

Query Parameter 6:

''

Query Parameter 7:

''

Query Parameter 8:

0

Query Parameter 9:

0

Query Parameter 10:

''

Query Parameter 11:

0

Query Parameter 12:

1

Query Parameter 13:

''

Query Parameter 14:

false

Query Parameter 15:

1

Query Parameter 16:

''

Query Parameter 17:

false

Query Parameter 18:

0

Query Parameter 19:

''

Query Parameter 20:

0

Query Parameter 21:

3

Stack Trace:

#0 */lib/data/DatabaseObjectEditor.class.php (55):

wcf\system\database\statement\PreparedStatement->execute([ 21 items ])

#1 */lib/data/user/UserEditor.class.php (117):

wcf\data\DatabaseObjectEditor->update([ 20 items ])

#2 */lib/data/AbstractDatabaseObjectAction.class.php (388):

wcf\data\user\UserEditor->update([ 20 items ])

#3 */lib/data/user/UserAction.class.php (333):

wcf\data\AbstractDatabaseObjectAction->update()

#4 */lib/data/AbstractDatabaseObjectAction.class.php (216):

wcf\data\user\UserAction->update()

#5 */lib/acp/form/UserEditForm.class.php (496):

wcf\data\AbstractDatabaseObjectAction->executeAction()

#6 */lib/form/AbstractForm.class.php (80):

wcf\acp\form\UserEditForm->save()

#7 */lib/form/AbstractForm.class.php (152):

wcf\form\AbstractForm->submit()

#8 */lib/acp/form/AbstractOptionListForm.class.php (111):

wcf\form\AbstractForm->readData()

#9 */lib/acp/form/UserAddForm.class.php (403):

wcf\acp\form\AbstractOptionListForm->readData()

#10 */lib/acp/form/UserEditForm.class.php (284):

wcf\acp\form\UserAddForm->readData()

#11 */lib/page/AbstractPage.class.php (353):

wcf\acp\form\UserEditForm->readData()

#12 */lib/acp/form/UserAddForm.class.php (454):

wcf\page\AbstractPage->show()

#13 */lib/page/AbstractPage.class.php (135):

wcf\acp\form\UserAddForm->show()

#14 */lib/system/request/Request.class.php (90):

wcf\page\AbstractPage->__run()

#15 */lib/system/request/RequestHandler.class.php (107):

wcf\system\request\Request->execute()

#16 */acp/index.php (11):

wcf\system\request\RequestHandler->handle('wcf', true)

Display More