Moin,
ich habe beim Update von 5.5.8 auf 5.5.9 folgenden Fehler bekommen:
Code
Mon, 19 Jun 2023 18:33:47 +0000
Message: Could not execute statement 'ALTER TABLE `wcf1_user_option_value` ADD COLUMN `userOption34` tinyint(1) NOT NULL DEFAULT 0'
PHP version: 8.1.16
WoltLab Suite version: 5.5.12
Request URI: POST /acp/index.php?install-package/&t=7849060ab8d0b4bc417d12caf580f9911f8c99a72fffe18bfb9230f1ee60c42c-zDZZ2NGacQkpYwW/Vwgb4g==
Referrer: https://{}/acp/index.php?package-update/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36
Peak Memory Usage: 6323632/1073741824
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'ALTER TABLE `wcf1_user_option_value` ADD COLUMN `userOption34` tinyint(1) NOT NULL DEFAULT 0'
Error Code: 42S21
File: /www/htdocs/{}/{}/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":270,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/data\/user\/option\/UserOptionEditor.class.php","line":41,"function":"addColumn","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_option_value","userOption34",{"autoIncrement":"[redacted]","key":"[redacted]","notNull":"[redacted]","type":"[redacted]","default":"[redacted]","length":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/UserOptionPackageInstallationPlugin.class.php","line":231,"function":"create","class":"wcf\\data\\user\\option\\UserOptionEditor","type":"::","args":[{"categoryName":"[redacted]","optionType":"[redacted]","defaultValue":"[redacted]","validationPattern":"[redacted]","selectOptions":"[redacted]","enableOptions":"[redacted]","required":"[redacted]","askDuringRegistration":"[redacted]","editable":"[redacted]","visible":"[redacted]","outputClass":"[redacted]","searchable":"[redacted]","showOrder":"[redacted]","permissions":"[redacted]","options":"[redacted]","additionalData":"[redacted]","originIsSystem":"[redacted]","optionName":"[redacted]","isDisabled":"[redacted]","packageID":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractOptionPackageInstallationPlugin.class.php","line":250,"function":"saveOption","class":"wcf\\system\\package\\plugin\\UserOptionPackageInstallationPlugin","type":"->","args":[{"categoryname":"[redacted]","optiontype":"[redacted]","editable":"[redacted]","defaultvalue":"[redacted]","name":"[redacted]"},"settings.general.interface"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractOptionPackageInstallationPlugin.class.php","line":105,"function":"importOptions","class":"wcf\\system\\package\\plugin\\AbstractOptionPackageInstallationPlugin","type":"->","args":["DOMXPath"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\AbstractOptionPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["b26e9688"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userOption34'
Error Code: 42S21
File: /www/htdocs/{}/{}/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[[]]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":270,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/data\/user\/option\/UserOptionEditor.class.php","line":41,"function":"addColumn","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_option_value","userOption34",{"autoIncrement":"[redacted]","key":"[redacted]","notNull":"[redacted]","type":"[redacted]","default":"[redacted]","length":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/UserOptionPackageInstallationPlugin.class.php","line":231,"function":"create","class":"wcf\\data\\user\\option\\UserOptionEditor","type":"::","args":[{"categoryName":"[redacted]","optionType":"[redacted]","defaultValue":"[redacted]","validationPattern":"[redacted]","selectOptions":"[redacted]","enableOptions":"[redacted]","required":"[redacted]","askDuringRegistration":"[redacted]","editable":"[redacted]","visible":"[redacted]","outputClass":"[redacted]","searchable":"[redacted]","showOrder":"[redacted]","permissions":"[redacted]","options":"[redacted]","additionalData":"[redacted]","originIsSystem":"[redacted]","optionName":"[redacted]","isDisabled":"[redacted]","packageID":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractOptionPackageInstallationPlugin.class.php","line":250,"function":"saveOption","class":"wcf\\system\\package\\plugin\\UserOptionPackageInstallationPlugin","type":"->","args":[{"categoryname":"[redacted]","optiontype":"[redacted]","editable":"[redacted]","defaultvalue":"[redacted]","name":"[redacted]"},"settings.general.interface"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractOptionPackageInstallationPlugin.class.php","line":105,"function":"importOptions","class":"wcf\\system\\package\\plugin\\AbstractOptionPackageInstallationPlugin","type":"->","args":["DOMXPath"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":76,"function":"install","class":"wcf\\system\\package\\plugin\\AbstractOptionPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["b26e9688"]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/{}\/{}\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
Alles anzeigen
Gruß Marvin Schrand
i. A. AStA-JadeHS