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:
Code
Tue, 31 Jan 2017 18:11:33 +0000
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'
File: /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/statement/PreparedStatement.class.php (97)
PHP version: 7.0.13-0ubuntu0.16.04.1
WCF version: 2.1.12 (Typhoon)
Request URI: /acp/index.php?install-package/&&
Referrer: https://tos-xbox.net/acp/index.php?plugin-store-purchased-items/&
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
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 \/>"
Stacktrace:
#0 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/database/editor/MySQLDatabaseEditor.class.php(171): wcf\system\database\statement\PreparedStatement->execute()
#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)
#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)
#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)
#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...')
#5 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php(78): wcf\system\database\util\SQLParser->execute()
#6 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(571): wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
#7 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(139): wcf\system\package\PackageInstallationDispatcher->executePIP(Array)
#8 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/acp/action/InstallPackageAction.class.php(73): wcf\system\package\PackageInstallationDispatcher->install('b51b577a')
#9 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractDialogAction.class.php(70): wcf\acp\action\InstallPackageAction->stepInstall()
#10 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AbstractDialogAction->execute()
#11 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/Request.class.php(58): wcf\action\AbstractAction->__run()
#12 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#13 /var/www/vhosts/tos-xbox.net/httpdocs/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#14 {main}
Alles anzeigen
Jetz wollte ich das Plugin neu installieren, deinstallieren kein Problem, beim installiern bekam ich folgenden Fehler:
Code
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'
Information:
id: 83e1efd89b45528556f707e94c33750e526842ad
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'
error code: 0
file: /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (74)
php version: 7.0.13-0ubuntu0.16.04.1
wcf version: 2.1.12 (Typhoon)
date: Tue, 31 Jan 2017 18:21:27 +0000
request: /acp/index.php?install-package/&&
referer: https://tos-xbox.net/acp/index.php?plugin-store-purchased-items/&
Stacktrace:
#0 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(571): wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
#1 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/package/PackageInstallationDispatcher.class.php(139): wcf\system\package\PackageInstallationDispatcher->executePIP(Array)
#2 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/acp/action/InstallPackageAction.class.php(73): wcf\system\package\PackageInstallationDispatcher->install('b2117e91')
#3 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractDialogAction.class.php(70): wcf\acp\action\InstallPackageAction->stepInstall()
#4 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AbstractDialogAction->execute()
#5 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/Request.class.php(58): wcf\action\AbstractAction->__run()
#6 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#7 /var/www/vhosts/tos-xbox.net/httpdocs/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#8 {main}
Alles anzeigen
Bitte um Hilfe!
LG
LatroX