Fehler beim Upgrade

SoftCreatR · Jul 4th 2022

Requested URL: POST /acp/index.php?install-package/&t=1b900d50aff9a8718962d07f4edfb693243ee99c10467735ebcedc3b1429934b-+hWkc8hEYlKoNPJtBriPRA==

Referrer: acp/index.php?package-update/

Error Message: Could not execute statement 'INSERT INTO wbb222020_board_user_status (userID, boardID, status) SELECT userID, objectID, 'threadsOnly' FROM wcf222020_user_object_watch WHERE objectTypeID = ? AND objectID IN ( SELECT boardID FROM wbb222020_board )'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 325

Stacktrace

/forum/acp/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php (46): wcf\system\database\statement\PreparedStatement->execute(…)
/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (84): include(…)
/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (59): wcf\system\package\plugin\ScriptPackageInstallationPlugin->run(…)
/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\ScriptPackageInstallationPlugin->install(…)
/lib/system/package/PackageInstallationDispatcher.class.php (807): wcf\system\package\plugin\AbstractPackageInstallationPlugin->update(…)
/lib/system/package/PackageInstallationDispatcher.class.php (155): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
/lib/acp/action/InstallPackageAction.class.php (82): wcf\system\package\PackageInstallationDispatcher->install(…)
/lib/action/AbstractDialogAction.class.php (73): wcf\acp\action\InstallPackageAction->stepInstall(…)
/lib/action/AbstractAction.class.php (57): wcf\action\AbstractDialogAction->execute(…)
/lib/system/request/Request.class.php (90): wcf\action\AbstractAction->__run(…)
/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/acp/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '75882-13' for key 'wbb222020_board_user_status.PRIMARY'

Type: PDOException

File (Line): /lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/forum/acp/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php (46): wcf\system\database\statement\PreparedStatement->execute(…)
/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (84): include(…)
/lib/system/package/plugin/ScriptPackageInstallationPlugin.class.php (59): wcf\system\package\plugin\ScriptPackageInstallationPlugin->run(…)
/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\ScriptPackageInstallationPlugin->install(…)
/lib/system/package/PackageInstallationDispatcher.class.php (807): wcf\system\package\plugin\AbstractPackageInstallationPlugin->update(…)
/lib/system/package/PackageInstallationDispatcher.class.php (155): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
/lib/acp/action/InstallPackageAction.class.php (82): wcf\system\package\PackageInstallationDispatcher->install(…)
/lib/action/AbstractDialogAction.class.php (73): wcf\acp\action\InstallPackageAction->stepInstall(…)
/lib/action/AbstractAction.class.php (57): wcf\action\AbstractDialogAction->execute(…)
/lib/system/request/Request.class.php (90): wcf\action\AbstractAction->__run(…)
/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/acp/index.php (11): wcf\system\request\RequestHandler->handle(…)

<<<<<<<<736e38b37d3e1291a3024051f14e32f50c5903a0<<<<
Sun, 03 Jul 2022 22:10:36 +0000
Message: Could not execute statement 'INSERT INTO wbb222020_board_user_status                         (userID, boardID, status)             SELECT      userID, objectID, 'threadsOnly'             FROM        wcf222020_user_object_watch             WHERE       objectTypeID = ?                     AND objectID IN (                         SELECT  boardID                         FROM    wbb222020_board                     )'
PHP version: 8.0.20
WoltLab Suite version: 5.5.0 RC 3
Request URI: POST /acp/index.php?install-package/&t=1b900d50aff9a8718962d07f4edfb693243ee99c10467735ebcedc3b1429934b-+hWkc8hEYlKoNPJtBriPRA==
Referrer: acp/index.php?package-update/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
Peak Memory Usage: 8581304/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wbb222020_board_user_status                         (userID, boardID, status)             SELECT      userID, objectID, 'threadsOnly'             FROM        wcf222020_user_object_watch             WHERE       objectTypeID = ?                     AND objectID IN (                         SELECT  boardID                         FROM    wbb222020_board                     )'
Error Code: 23000
File: /lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YToxOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMyNTt9fQ==
Stack Trace: [{"file":"\/forum\/acp\/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php","line":46,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":84,"args":["\/forum\/acp\/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php"],"function":"include","class":"","type":""},{"file":"\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":59,"function":"run","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '75882-13' for key 'wbb222020_board_user_status.PRIMARY'
Error Code: 23000
File: /lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/forum\/acp\/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php","line":46,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":84,"args":["\/forum\/acp\/update_com.woltlab.wbb_5.5_updateSubscribedBoards.php"],"function":"include","class":"","type":""},{"file":"\/lib\/system\/package\/plugin\/ScriptPackageInstallationPlugin.class.php","line":59,"function":"run","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\ScriptPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
<<<<

An den Daten liegt es meiner Ansicht nach nicht:

watchID	objectTypeID	objectID	userID	notification
615914	325	106	75882	0
622084	325	13	75882	0

**Tim Düsterhus** · Jul 4th 2022

Hallo,

kannst du die 2022-07-xx-update-*.txt-Dateien zur Verfügung stellen (gerne auch per Ticket)?

SoftCreatR · Jul 4th 2022

Darauf habe ich leider keinen Zugriff mehr in den nächsten Wochen. Ich hatte gestern einfach die object-watch-Tabelle geleert, daraufhin funktionierte das Upgrade.

SoftCreatR · Jul 4th 2022

Ich schaue, dass ich die Informationen bis Freitag bekomme.

**Tim Düsterhus** · Jul 4th 2022

Hallo,

danke. Gerne nehme ich auch Infos von einem anderen Nutzer, falls jemand über die selbe Problematik stolpert.

Ich konnte nach Prüfung des Upgrade-Skriptes keine Fehler erkennen (unter der Annahme, dass der Datenbankzustand vor dem Upgrade konsistent ist).

**Alexander Ebert** · Jul 6th 2022

Ich habe das Problem lokalisiert, verursacht wird es durch Benutzer, die ein Forum sowohl abonniert als auch ignoriert haben. In früheren Versionen war dieser Zustand theoretisch möglich, aber das Update ist darauf nicht vorbereitet.

Ich arbeite an einer kurzfristigen Korrektur.

**Alexander Ebert** · Jul 6th 2022

Ein korrigiertes Update ist verfügbar. Für Betroffene ist es ausreichend, einfach erneut nach Updates suchen zu lassen und dann diese zu installieren, es wird dann automatisch die korrigierte Fassung verwendet.

itsmeJAY · Jul 6th 2022

Ich habe das Backup eingespielt und mache es die Tage noch einmal. Ich hoffe dann läuft es korrekt durch

Fehler beim Upgrade

Participate now!

Share

Similar Threads

'WSC52ThumbnailRebuildDataWorker' does not implement interface 'IWorker'

Update geht nicht