SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOption95' at row 1

MasterShadow · May 21st 2020

Hallo alle miteinander.

Von heute auf Morgen können sich meine neu registrierten User nicht mehr einloggen.

Genauso kann ich auch keine User die sich aktuell registriert haben mehr bearbeiten.

Es ist auch so wenn ich einen User über ACP anlege bekomm ich folgende Meldung unten angezeigt und kann diesen auch nicht bearbeiten.

Dort kommt immer ich habe dafür keine Rechte diese zu bearbeiten.

Folgender Fehlercode wird mir angezeigt

Requested URL: /wcf/acp/index.php?user-add/

Referrer: https://www.lionskings.de/wcf/acp/index.php?user-add/

Error Message: Could not execute statement 'INSERT INTO wcf1_user_option_value (userID, userOption3, userOption15, userOption17, userOption20, userOption21, userOption22, userOption23, userOption29, userOption34, userOption35, userOption85, userOption86, userOption92, userOption95, userOption96) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /var/www/html/wcf/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: 29

Query Parameter 2: '1'

Query Parameter 3: '1'

Query Parameter 4: '1'

Query Parameter 5: '3'

Query Parameter 6: '1'

Query Parameter 7: '1'

Query Parameter 8: '1'

Query Parameter 9: '1'

Query Parameter 10: '86400'

Query Parameter 11: 'everyone'

Query Parameter 12: '1'

Query Parameter 13: '1'

Query Parameter 14: '1'

Query Parameter 15: '01.Jan.2020'

Query Parameter 16: '1'

Stacktrace

/var/www/html/wcf/lib/data/user/UserEditor.class.php (133): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/html/wcf/lib/data/user/UserEditor.class.php (60): wcf\data\user\UserEditor::createUserOptions(…)
[internal function] (?): wcf\data\user\UserEditor::create(…)
/var/www/html/wcf/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
/var/www/html/wcf/lib/data/user/UserAction.class.php (267): wcf\data\AbstractDatabaseObjectAction->create(…)
[internal function] (?): wcf\data\user\UserAction->create(…)
/var/www/html/wcf/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (272): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/html/wcf/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserAddForm->save(…)
/var/www/html/wcf/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/var/www/html/wcf/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (362): wcf\acp\form\AbstractOptionListForm->readData(…)
/var/www/html/wcf/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserAddForm->readData(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (410): wcf\page\AbstractPage->show(…)
/var/www/html/wcf/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserAddForm->show(…)
/var/www/html/wcf/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/html/wcf/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/html/wcf/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOption95' at row 1

Type: PDOException

File (Line): /var/www/html/wcf/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/var/www/html/wcf/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/var/www/html/wcf/lib/data/user/UserEditor.class.php (133): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/html/wcf/lib/data/user/UserEditor.class.php (60): wcf\data\user\UserEditor::createUserOptions(…)
[internal function] (?): wcf\data\user\UserEditor::create(…)
/var/www/html/wcf/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
/var/www/html/wcf/lib/data/user/UserAction.class.php (267): wcf\data\AbstractDatabaseObjectAction->create(…)
[internal function] (?): wcf\data\user\UserAction->create(…)
/var/www/html/wcf/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (272): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/html/wcf/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserAddForm->save(…)
/var/www/html/wcf/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/var/www/html/wcf/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (362): wcf\acp\form\AbstractOptionListForm->readData(…)
/var/www/html/wcf/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserAddForm->readData(…)
/var/www/html/wcf/lib/acp/form/UserAddForm.class.php (410): wcf\page\AbstractPage->show(…)
/var/www/html/wcf/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserAddForm->show(…)
/var/www/html/wcf/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/html/wcf/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/html/wcf/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 21 May 2020 15:34:10 +0000
Message: Could not execute statement 'INSERT INTO    wcf1_user_option_value                     (userID, userOption3, userOption15, userOption17, userOption20, userOption21, userOption22, userOption23, userOption29, userOption34, userOption35, userOption85, userOption86, userOption92, userOption95, userOption96)             VALUES        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
PHP version: 7.2.30-1+0~20200419.40+debian9~1.gbpb1b799
WoltLab Suite version: 5.2.6
Request URI: /wcf/acp/index.php?user-add/
Referrer: https://www.lionskings.de/wcf/acp/index.php?user-add/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36
Peak Memory Usage: 7231080/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO    wcf1_user_option_value                     (userID, userOption3, userOption15, userOption17, userOption20, userOption21, userOption22, userOption23, userOption29, userOption34, userOption35, userOption85, userOption86, userOption92, userOption95, userOption96)             VALUES        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
Error Code: 22001
File: /var/www/html/wcf/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YToxNjp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToyOTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7czozOiInMSciO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtzOjM6IicxJyI7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO3M6MzoiJzEnIjt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7czozOiInMyciO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtzOjM6IicxJyI7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO3M6MzoiJzEnIjt9aTo3O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA4IjtpOjE7czozOiInMSciO31pOjg7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDkiO2k6MTtzOjM6IicxJyI7fWk6OTthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTAiO2k6MTtzOjc6Iic4NjQwMCciO31pOjEwO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMSI7aToxO3M6MTA6IidldmVyeW9uZSciO31pOjExO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMiI7aToxO3M6MzoiJzEnIjt9aToxMjthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTMiO2k6MTtzOjM6IicxJyI7fWk6MTM7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDE0IjtpOjE7czozOiInMSciO31pOjE0O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNSI7aToxO3M6MTM6IicwMS5KYW4uMjAyMCciO31pOjE1O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNiI7aToxO3M6MzoiJzEnIjt9fQ==
Stack Trace: [{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserEditor.class.php","line":133,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserEditor.class.php","line":60,"function":"createUserOptions","class":"wcf\\data\\user\\UserEditor","type":"::","args":[29]},{"function":"create","class":"wcf\\data\\user\\UserEditor","type":"::","args":[{"languageID":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","userTitle":"[redacted]","signature":"[redacted]","signatureEnableHtml":"[redacted]","disableSignature":"[redacted]","disableSignatureReason":"[redacted]","disableSignatureExpires":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"languageID":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","userTitle":"[redacted]","signature":"[redacted]","signatureEnableHtml":"[redacted]","disableSignature":"[redacted]","disableSignatureReason":"[redacted]","disableSignatureExpires":"[redacted]"}],"class":"","type":""},{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserAction.class.php","line":267,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"function":"create","class":"wcf\\data\\user\\UserAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":272,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":99,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":362,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":410,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOption95' at row 1
Error Code: 22001
File: /var/www/html/wcf/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/html\/wcf\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserEditor.class.php","line":133,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserEditor.class.php","line":60,"function":"createUserOptions","class":"wcf\\data\\user\\UserEditor","type":"::","args":[29]},{"function":"create","class":"wcf\\data\\user\\UserEditor","type":"::","args":[{"languageID":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","userTitle":"[redacted]","signature":"[redacted]","signatureEnableHtml":"[redacted]","disableSignature":"[redacted]","disableSignatureReason":"[redacted]","disableSignatureExpires":"[redacted]","accessToken":"[redacted]","registrationDate":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"languageID":"[redacted]","username":"[redacted]","email":"[redacted]","password":"[redacted]","userTitle":"[redacted]","signature":"[redacted]","signatureEnableHtml":"[redacted]","disableSignature":"[redacted]","disableSignatureReason":"[redacted]","disableSignatureExpires":"[redacted]"}],"class":"","type":""},{"file":"\/var\/www\/html\/wcf\/lib\/data\/user\/UserAction.class.php","line":267,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"function":"create","class":"wcf\\data\\user\\UserAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/wcf\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":272,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":99,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":362,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/acp\/form\/UserAddForm.class.php","line":410,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\acp\\form\\UserAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/wcf\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Vielleicht kann mir ja einer sagen an was es genau liegt.

Für Rückfragen stehe ich gerne zur Verfügung.

Krymonota · May 21st 2020

Könntest du mal folgenden SQL-Befehl ausführen und die Ausgabe davon hier posten?

SQL

SELECT * FROM wcf1_user_option WHERE optionID = 95;

MasterShadow · May 21st 2020

Also das ist was er mir dann ausgibt

MasterShadow · May 21st 2020

Also ich hab den Fehler gefunden und möchte es natürlich hier auch bekannt geben.

Es ist folgendes ich hab in diesem Profilfeld ein Standarddatum eingeben wollen was er immer auswählt was man im Screenshot von mir auch sieht mit dem 01.Jan.2020

Das hat zu diesem Fehler geführt. Wir haben das Profilefeld jetzt wieder auf null gesetzt bzw entfernt und jetzt funktioniert wieder alles.

Bin trotzdem dankbar für die schnelle Hilfe.

einen schönen restlichen Feiertag noch wünsche ich allen.

**Marcel Werk** · May 26th 2020

Für Felder vom Typ "date" muss der Standardwert im Format "yyyy-mm-tt" angegeben werden.

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOption95' at row 1

Marcel Werk May 26th 2020

Marcel Werk May 26th 2020

Alexander Ebert Jun 2nd 2020

Participate now!

Share

Similar Threads

Maximale Länge von userOnlineMarking wird in UserGroupAddForm/UserGroupEditForm nicht überprüft

Fehlermeldung bei Zeichenüberschreitung (Medien-Metadaten)