Hallo,

Das rückwirkende Bewerten funktioniert. Nur nicht beim „ersten Spiel“ (21. November 2023). Da erscheint folgender Fehler:

Zitat

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…eam-lineup-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

Alles anzeigen

Zitat

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

Zitat

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

Zitat

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

Alles anzeigen

Zitat

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