Installations Problem

    • No error

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Installations Problem

      Hallo!

      Ich verwalte das Forum eines Kumpels, dort ging seit einiger Zeit das Clan Verwaltungs Plugin nicht mehr richtig.
      Es hing extrem oder funktionierte nicht wenn man einen Clan aufrufen wollte.

      Folge Fehlermeldung erschien wenn man "Clan Kommentare aktualisieren" ausführte:

      Source Code

      1. Tue, 31 Jan 2017 18:11:33 +0000
      2. Message: Could not execute prepared statement: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'tos'@'localhost' for table 'wcf1_user'
      3. File: /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/statement/PreparedStatement.class.php (97)
      4. PHP version: 7.0.13-0ubuntu0.16.04.1
      5. WCF version: 2.1.12 (Typhoon)
      6. Request URI: /acp/index.php?install-package/&&
      7. Referrer: https://tos-xbox.net/acp/index.php?plugin-store-purchased-items/&
      8. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
      9. Information: "<b>sql type:<\/b> wcf\\system\\database\\MySQLDatabase<br \/><b>sql error:<\/b> REFERENCES command denied to user 'tos'@'localhost' for table 'wcf1_user'<br \/><b>sql error number:<\/b> 42000<br \/><b>sql version:<\/b> 5.7.17-0ubuntu0.16.04.1<br \/><b>sql query:<\/b> ALTER TABLE `clan1_clan` ADD CONSTRAINT `07ea806fd7b33c94d8397e9953845302_fk` FOREIGN KEY (`userID`) REFERENCES `wcf1_user` (`userID`) ON DELETE SET NULL<br \/>"
      10. Stacktrace:
      11. #0 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/editor/MySQLDatabaseEditor.class.php(171): wcf\system\database\statement\PreparedStatement->execute()
      12. #1 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/util/SQLParser.class.php(272): wcf\system\database\editor\MySQLDatabaseEditor->addForeignKey('clan1_clan', '07ea806fd7b33c9...', Array)
      13. #2 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationSQLParser.class.php(342): wcf\system\database\util\SQLParser->executeAddForeignKeyStatement('clan1_clan', '07ea806fd7b33c9...', Array)
      14. #3 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/util/SQLParser.class.php(129): wcf\system\package\PackageInstallationSQLParser->executeAddForeignKeyStatement('clan1_clan', '07ea806fd7b33c9...', Array)
      15. #4 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/util/SQLParser.class.php(49): wcf\system\database\util\SQLParser->executeStatement('ALTER TABLE', 'ALTER TABLE cla...')
      16. #5 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php(78): wcf\system\database\util\SQLParser->execute()
      17. #6 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(571): wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
      18. #7 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(139): wcf\system\package\PackageInstallationDispatcher->executePIP(Array)
      19. #8 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/acp/action/InstallPackageAction.class.php(73): wcf\system\package\PackageInstallationDispatcher->install('b51b577a')
      20. #9 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractDialogAction.class.php(70): wcf\acp\action\InstallPackageAction->stepInstall()
      21. #10 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AbstractDialogAction->execute()
      22. #11 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/Request.class.php(58): wcf\action\AbstractAction->__run()
      23. #12 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
      24. #13 /var/www/vhosts/tos-xbox.net/httpdocs/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
      25. #14 {main}
      Display All

      Jetz wollte ich das Plugin neu installieren, deinstallieren kein Problem, beim installiern bekam ich folgenden Fehler:

      Source Code

      1. Fatal error: Can't overwrite unknown tables 'clan1_clan', 'clan1_group', 'clan1_user_to_group', 'clan1_group_option', 'clan1_group_option_value', 'clan1_clan_application', 'clan1_clan_invites', 'clan1_option', 'clan1_option_value', 'clan1_last_activities', 'clan1_pages', 'clan1_clan_visitor'
      2. Information:
      3. id: 83e1efd89b45528556f707e94c33750e526842ad
      4. error message: Can't overwrite unknown tables 'clan1_clan', 'clan1_group', 'clan1_user_to_group', 'clan1_group_option', 'clan1_group_option_value', 'clan1_clan_application', 'clan1_clan_invites', 'clan1_option', 'clan1_option_value', 'clan1_last_activities', 'clan1_pages', 'clan1_clan_visitor'
      5. error code: 0
      6. file: /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (74)
      7. php version: 7.0.13-0ubuntu0.16.04.1
      8. wcf version: 2.1.12 (Typhoon)
      9. date: Tue, 31 Jan 2017 18:21:27 +0000
      10. request: /acp/index.php?install-package/&&
      11. referer: https://tos-xbox.net/acp/index.php?plugin-store-purchased-items/&
      12. Stacktrace:
      13. #0 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(571): wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
      14. #1 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(139): wcf\system\package\PackageInstallationDispatcher->executePIP(Array)
      15. #2 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/acp/action/InstallPackageAction.class.php(73): wcf\system\package\PackageInstallationDispatcher->install('b2117e91')
      16. #3 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractDialogAction.class.php(70): wcf\acp\action\InstallPackageAction->stepInstall()
      17. #4 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AbstractDialogAction->execute()
      18. #5 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/Request.class.php(58): wcf\action\AbstractAction->__run()
      19. #6 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
      20. #7 /var/www/vhosts/tos-xbox.net/httpdocs/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
      21. #8 {main}
      Display All


      Bitte um Hilfe!

      LG
      LatroX