Fehlermeldung Mannschaftsaufstellung 6.0.11

echtso · 16. April 2024

Hallo,

ich habe beim Plugin Mannschaftsaufstellung mehrmals folgende Fehlermeldung erhalten:

Code

Tue, 16 Apr 2024 16:28:02 +0000
Message: Could not execute statement 'INSERT INTO wcf1_team_lineup_user_player(lineupID,playerID,positionID,name,x,y,image) VALUES(?,?,?,?,?,?,?)'
PHP version: 8.3.4
WoltLab Suite version: 6.0.11
Request URI: POST /team-lineup-edit/1/ (0005-661EA711120453)
Referrer: https://www.xxx.de/team-lineup-edit/1/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36
Peak Memory Usage: 3564744/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_team_lineup_user_player(lineupID,playerID,positionID,name,x,y,image) VALUES(?,?,?,?,?,?,?)'
Error Code: 22001
File: /customer-rw/www/lib/system/database/statement/PreparedStatement.class.php (143)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MTE7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6NDt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7czo2OiInRGVobSciO31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjExO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjM1NDt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7czo3MTU3ODoiJ2lWQk9SdzBLR2dvQUFBQU5TVWhFVWdBQUFONEFBQURTQ0FZQUFBQWxwWDdNQUFBQUNYQklXWE1BQUE3RUFBQU94QUdWS3c0YkFBQUU3MmxVV0hSWVRVdzZZMjl0TG1Ga2IySmxMbmh0Y0FBQUFBQUFQSGc2ZUcxd2JXVjBZU0I0Yld4dWN6cDRQU2RoWkc5aVpUcHVjenB0WlhSaEx5YytDaUFnSUNBZ0lDQWdQSEprWmpwU1JFWWdlRzFzYm5NNmNtUm1QU2RvZEhSd09pOHZkM2QzTG5jekxtOXlaeTh4T1RrNUpemQvWHJYS1ZGNmk4Z0JCSnpsMXoyd1dPL2Q3RExQVXo5dC94alYycWx1L2Z3NVUvOUU5NTZtZi9OWGt5SlFsRnhyNXYvcVlFbll2dTBHZ2IyZWNWVzEzTnMzckRkZlN1dXBMcTBiOUlwSVAwaW51R1REaFUySmtRajNWYXJEUFV2T1RvNy80dUIxNzlLcHpZZWFSQ2lEUytwRGpmdHBrQUluaWUvZUNmOE9TNy93UFoxamI3N3YxMlhuYnZQMlJ5K2lTaGNRVG42Vit3bjRQZitxMnN2ZUlWQ2RhUDBWdzV6NUdISHNJK2U0VGVIWGR4MlhmZVIzYm9RRmV6SGYvZ242Q3FFZzRkNU1DdHQ4WDJnbXdsTGtJMEhZV2tYUkxIZUZvMGt4Q2lNcm5KMEhtR0tmSTRpdFJVdE5tSFVwR0twN1dKVEIyWDVPeWx3bnFCYXp6QmVGNndOVk5DR3FJT0NCZlEyQzYxYlFVRmcvZXNxSXhWbGVHRFp4NGNNMmRaQk0rY3dCaXd6WUo4b3JuKzZzdGpTOE41cEloOVBLRUV3VFdZWVIvZHp4Rkc0K3RHVU0yRFJ0eFFYbmdOZDc3NTVmek1JNS85R2pZZUlJSVFXVkdzOVhxOXNGRGJJdGVheGZhWXpSZlBNRmpieGZhWFhtQjN2MkRiYUxDV0xNRGVhTExGTnJBQXpsTGpYYUF2QzViSm1ZU1NlUXJycXdqT0VIZzZPQTZYRlRnb0tvM0pTZ0pSb2c4ZkluS1hhaFJYMS9SMnhaYUZyWm9JbkdpVnBNZmJuazVxSEJPUXp1SEc0N2hCWFN6Z1E1YlJCQW1qWlhaZmZDVTdZRHNzTnRkcHhoc1UrOVpvNFpsV3ZGWFA1eno1eTcvQzJ2WFhvNVoyeFhva0JQYmRkVHZybjdtSHlRYy9RQURVd1VQc3V2NzZEbk1JMXJJNGM1cFFSM2w0UXNBTHdlalFSV0F5RUFJOUhIRHdXKy9tcWNjZVpjYy9JYjRTQVNRSjBlNUVyQkJpMUJJaFVEMytCS2YrNGxQc3VmWE9McjF0RFZwYVpMYjlvVUJnNDhqVEhQbUZoK2hOeG5nUk9QZlJqL0hJSno2UmlxQTRyblREdTM2YWZkLzR6V1Q3VnJ0ckNTRkFaWmsyQWorWmt1OWVadlNLYXlQTUZBTGpvOGRZL00zZm9KVms5MjIzWW5hdFlsc0NjMXQzMmppMzJZMFdKWWRWa1dZdFRaNUgxNTVrbXl5a1I3Z21BakVwK2t2Y3pzOEVoeklxUmgwYkFielNXL3JPMGlOT0hVeUlJc2tEQkNhSTlrd0Q0amdXM3NZb0tBVExRckdpQ3p5dzFaUk04VGdDcFJKNGFXaXFLcXBHcC9Gc2xXZG9sWkd2cmFKSEJUSXZVRUVFWVRKTU1YaVp1KzIyM3AwMzNqam5IZS80R2piZUpaZmdEaDZVNnJsbkQvZEhvN0FsejZTVVJYRHUrSXVJZmF2MDk2OHhmZkVzYTZ2TG5ENjlqay9FMXIwb0Nqd2JCR1lFQWpYN2cyS2tjcHgxVk5TNDlNdjNJM2dHeHl1bWM1YjdrbkpSNC93MmVpbEdPTjg0NmtXTlRndXR0YjBLZ0M2eWFGNVNnV3ZLdUFGZElEU3gvaklLYkcxWmJLMTNKMm9JbnF1LzczdFFiM29UbzBNSE1YdFhFOERpVVVKeTlFTWZ3a3ltK0tidUFJNldsdVdDSjN6aEtiN3dubC9ubFQvK2s5aldxRUpMcnZyaEgrU1J2LzVyek5tVHJIN0RiZWpsbFVRUkMyd2ZlWksvZlB2YjBiTVp1RUIvYVlnem1xdmY5Yk9zdlNiV2dkNDdMbmpkYlh6cE55OUtxS2J2V0NPUTBrMENJY1RScUpBazVDSFdTV1pSODZYZitHL3N1L20xdUN6YkVTT1NBaWtqUXhHL1kzeHBKM05jMmJDUU9pN2d4a09RQkNXUldaRnNpUE1kRU9ZbEo0RkE3ZHVQMnppTUhFVmpqa0RzTng3LzFGL2lQRFREWlE2Ky9sdG9rZy9GK1J2WFZUWGR4R09Tc1pkS0pWUXpHYk9vaEZhN2hpQ2pJclJQRXdyZWVXU3dhYXhJb0xUQURQcElZUW16S1VvcFRnZlBpZUFaQUh1QkVZb3FSYjUyMDJsYWdBVjBPa1Jic3JWU0FpTVZxeUpqRFVtallIbTRSRFdkRVd3ZFUxOFhZYjg4MThqY3NOamFSbTV2SVpXZ210ZmtxMnVZSUdYK1A5K25lTzk3WDNJTC96OFhiRjJLSU9tWWxBQUFBQUJKUlU1RXJrSmdnZz09JyI7fX0=
Stack Trace: [{"file":"\/customer-rw\/www\/lib\/data\/team\/lineup\/user\/TeamLineupUserAction.class.php","line":92,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/customer-rw\/www\/lib\/data\/team\/lineup\/user\/TeamLineupUserAction.class.php","line":47,"function":"insertPositions","class":"wcf\\data\\team\\lineup\\user\\TeamLineupUserAction","type":"->","args":[1]},{"file":"\/customer-rw\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"update","class":"wcf\\data\\team\\lineup\\user\\TeamLineupUserAction","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupEditForm.class.php","line":99,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/AbstractForm.class.php","line":79,"function":"save","class":"wcf\\form\\TeamLineupEditForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/AbstractForm.class.php","line":151,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupEditForm.class.php","line":44,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/page\/AbstractPage.class.php","line":349,"function":"readData","class":"wcf\\form\\TeamLineupEditForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupAddForm.class.php","line":173,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/page\/AbstractPage.class.php","line":134,"function":"show","class":"wcf\\form\\TeamLineupAddForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/customer-rw\/www\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/customer-rw\/www\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'image' at row 1
Error Code: 22001
File: /customer-rw/www/lib/system/database/statement/PreparedStatement.class.php (125)
Extra Information: -
Stack Trace: [{"file":"\/customer-rw\/www\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":125,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/customer-rw\/www\/lib\/data\/team\/lineup\/user\/TeamLineupUserAction.class.php","line":92,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/customer-rw\/www\/lib\/data\/team\/lineup\/user\/TeamLineupUserAction.class.php","line":47,"function":"insertPositions","class":"wcf\\data\\team\\lineup\\user\\TeamLineupUserAction","type":"->","args":[1]},{"file":"\/customer-rw\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"update","class":"wcf\\data\\team\\lineup\\user\\TeamLineupUserAction","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupEditForm.class.php","line":99,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/AbstractForm.class.php","line":79,"function":"save","class":"wcf\\form\\TeamLineupEditForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/AbstractForm.class.php","line":151,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupEditForm.class.php","line":44,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/page\/AbstractPage.class.php","line":349,"function":"readData","class":"wcf\\form\\TeamLineupEditForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/form\/TeamLineupAddForm.class.php","line":173,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/page\/AbstractPage.class.php","line":134,"function":"show","class":"wcf\\form\\TeamLineupAddForm","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/customer-rw\/www\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/customer-rw\/www\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/customer-rw\/www\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Alles anzeigen

P.S. Das Plugin-Label ist hier falsch, da Plugin, um welches es sich hier handelt, nicht aufgelistet wird.

Cyperghost · 17. April 2024

Welche Version des Plugins ist installiert?

Edit:

So wie es aussieht überschreitet das gewählte Avatar Bild die maximale Größe von 65535 bytes, die ich für das Feld vorgesehen habe. Diese sollte auch für die meisten Bilder mehr als ausreichen. Was hast du für eine Dateiendung für den gewählten Benutzer hochgeladen, welches du bei den Medien auswählst?

echtso · 17. April 2024

Hallo,

es ist die aktuelle Version installiert: 6.0.0 RC1

Die Dateiendung von den Avataren der Spieler ist .png. Ein Bild hat die Größe von 52,5 kb.

Bei CSS habe ich lediglich folgende Änderungen vorgenommen

Code

.teamLineupPlayer>.name {
    background-color: var(--wcfHeaderMenuBackground);
    color: #fff;
    margin: auto;
    text-transform: uppercase;
    font-weight: 600;
    border-radius: 5px;
    width: 100%;
    text-align: center;
}

echtso · Samstag, 17:08

Hallo?

Cyperghost · Sonntag, 10:19

Aktuell kannst du lediglich ein kleines Bild hochladen und dies verwenden. Ich werde dazu ein Update hochladen wodurch in dieser Spalte mehr Text Zeichen möglich sind.

Cyperghost · Vor 16 Stunden

Ich habe eine Version 6.0.0 hochgeladen die noch bei WoltLab auf Freischaltung wartet, diese sollte das Probleme beheben.

Fehlermeldung Mannschaftsaufstellung 6.0.11

Cyperghost 16. April 2024

Dragosius 16. April 2024

Cyperghost Vor 16 Stunden

Teilen

2 Benutzer haben hier geschrieben

Informationen

Support

Über uns