Beiträge von Marcel05

  • Mehrere Ranggrafiken Problem

    Update geht bei mir nicht durch - Fehler.

    Could not execute statement 'ALTER TABLE `wcf1_multirank` ADD CONSTRAINT `4a77c8d438cab1269d665c1de318d157_fk` FOREIGN KEY (`objectTypeID`) REFERENCES `wcf1_object_type` (`objectTypeID`) ON DELETE CASCADE'

    Mon, 21 Dec 2020 11:57:48 +0000

    Message: Could not execute statement 'ALTER TABLE `wcf1_multirank` ADD CONSTRAINT `4a77c8d438cab1269d665c1de318d157_fk` FOREIGN KEY (`objectTypeID`) REFERENCES `wcf1_object_type` (`objectTypeID`) ON DELETE CASCADE'

    PHP version: 7.3.19-1~deb10u1

    WoltLab Suite version: 5.3.1

    Request URI: POST /acp/index.php?install-package/&t=8468c9f713c23624a11d7110d61b6e224587f1b0

    Referrer: https://radio-butterfly.net/acp/index.php?…irm/&queueID=93

    User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:84.0) Gecko/20100101 Firefox/84.0

    Peak Memory Usage: 3104656/536870912

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'ALTER TABLE `wcf1_multirank` ADD CONSTRAINT `4a77c8d438cab1269d665c1de318d157_fk` FOREIGN KEY (`objectTypeID`) REFERENCES `wcf1_object_type` (`objectTypeID`) ON DELETE CASCADE'

    Error Code: HY000

    File: /var/www/html/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YTowOnt9

    Stack Trace: [{"file":"\/var\/www\/html\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":338,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":271,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":338,"function":"executeAddForeignKeyStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":128,"function":"executeAddForeignKeyStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["ALTER TABLE","ALTER TABLE wcf1_multirank\n ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID)\n ON DELETE CASCADE"]},{"file":"\/var\/www\/html\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":65,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":747,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["d2f4f649"]},{"file":"\/var\/www\/html\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[HY000]: General error: 1005 Can't create table `wcf`.`wcf1_multirank` (errno: 121 "Duplicate key on write or update")

    Error Code: HY000

    File: /var/www/html/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/var\/www\/html\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[[]]},{"file":"\/var\/www\/html\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":338,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":271,"function":"addForeignKey","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":338,"function":"executeAddForeignKeyStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":128,"function":"executeAddForeignKeyStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":["wcf1_multirank","4a77c8d438cab1269d665c1de318d157_fk",{"columns":"[redacted]","referencedTable":"[redacted]","referencedColumns":"[redacted]","ON DELETE":"[redacted]","ON UPDATE":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["ALTER TABLE","ALTER TABLE wcf1_multirank\n ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID)\n ON DELETE CASCADE"]},{"file":"\/var\/www\/html\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":65,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":747,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/var\/www\/html\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["d2f4f649"]},{"file":"\/var\/www\/html\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]