Hallo,
Das rückwirkende Bewerten funktioniert. Nur nicht beim „ersten Spiel“ (21. November 2023). Da erscheint folgender Fehler:
System Information
- PHP Version:
8.1.27
- WoltLab Suite Core:
6.0.12
- Peak Memory Usage:
2.185/256 MiB
- Request URI:
POST /index.php?team-lineup-game-rating/1/
- Referrer:
https://www.brustring-forum.de/index.php?team…-game-rating/1/
- User Agent:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15
Original Error
- Error Message:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'playerID' cannot be null
- Error Type:
PDOException (23000)
*/lib/system/database/statement/PreparedStatement.class.php:125
Stack Trace
- #0 PDOStatement->execute([ 0 => , 1 => ])
- */lib/system/database/statement/PreparedStatement.class.php:125
- #1 wcf\system\database\statement\PreparedStatement->execute([ 0 => , 1 => ])
- */lib/data/team/lineup/game/TeamLineupGameAction.class.php:81
- #2 wcf\data\team\lineup\game\TeamLineupGameAction->updatePlayerRatings()
- */lib/data/AbstractDatabaseObjectAction.class.php:215
- #3 wcf\data\AbstractDatabaseObjectAction->executeAction()
- */lib/form/TeamLineupGameRatingForm.class.php:190
- #4 wcf\form\TeamLineupGameRatingForm->save()
- */lib/form/AbstractForm.class.php:79
- #5 wcf\form\AbstractForm->submit()
- */lib/form/AbstractForm.class.php:151
- #6 wcf\form\AbstractForm->readData()
- */lib/form/TeamLineupGameRatingForm.class.php:88
- #7 wcf\form\TeamLineupGameRatingForm->readData()
- */lib/page/AbstractPage.class.php:349
- #8 wcf\page\AbstractPage->show()
- */lib/form/TeamLineupGameRatingForm.class.php:206
- #9 wcf\form\TeamLineupGameRatingForm->show()
- */lib/page/AbstractPage.class.php:134
- #10 wcf\page\AbstractPage->__run()
- */lib/system/request/Request.class.php:57
- #12 wcf\http\Pipeline->process(Laminas\Diactoros\ServerRequest, wcf\http\RequestHandlerMiddleware)
- */lib/system/request/RequestHandler.class.php:147
- #13 wcf\system\request\RequestHandler->handle('wcf')
- */index.php:10
Final Error
- Error Message:
Could not execute statement 'INSERT INTO wcf1_team_lineup_player_game_rating(gameID, playerID, rating, ratings) SELECT ?, playerID, AVG(rating), COUNT(*) FROM wcf1_team_lineup_player_rating player_rating INNER JOIN wcf1_team_lineup_rating rating ON(rating.isArchived = 0 AND rating.ratingID = player_rating.ratingID) WHERE rating.gameID = ? GROUP BY player_rating.playerID'
- Error Type:
wcf\system\database\exception\DatabaseQueryExecutionException (23000)
*/lib/system/database/statement/PreparedStatement.class.php:143
- Query Parameter 1:
1
- Query Parameter 2:
1
Stack Trace
- #0 wcf\system\database\statement\PreparedStatement->execute([ 0 => , 1 => ])
- */lib/data/team/lineup/game/TeamLineupGameAction.class.php:81
- #1 wcf\data\team\lineup\game\TeamLineupGameAction->updatePlayerRatings()
- */lib/data/AbstractDatabaseObjectAction.class.php:215
- #2 wcf\data\AbstractDatabaseObjectAction->executeAction()
- */lib/form/TeamLineupGameRatingForm.class.php:190
- #3 wcf\form\TeamLineupGameRatingForm->save()
- */lib/form/AbstractForm.class.php:79
- #4 wcf\form\AbstractForm->submit()
- */lib/form/AbstractForm.class.php:151
- #5 wcf\form\AbstractForm->readData()
- */lib/form/TeamLineupGameRatingForm.class.php:88
- #6 wcf\form\TeamLineupGameRatingForm->readData()
- */lib/page/AbstractPage.class.php:349
- #7 wcf\page\AbstractPage->show()
- */lib/form/TeamLineupGameRatingForm.class.php:206
- #8 wcf\form\TeamLineupGameRatingForm->show()
- */lib/page/AbstractPage.class.php:134
- #9 wcf\page\AbstractPage->__run()
- */lib/system/request/Request.class.php:57
- #10 wcf\system\request\Request->handle(Laminas\Diactoros\ServerRequest)
- */lib/http/middleware/HandleValinorMappingErrors.class.php:35
- #11 wcf\http\Pipeline->process(Laminas\Diactoros\ServerRequest, wcf\http\RequestHandlerMiddleware)
- */lib/system/request/RequestHandler.class.php:147
- #12 wcf\system\request\RequestHandler->handle('wcf')
- */index.php:10
Viele Grüße
bulinews
