Habe hier auch ein Problem, nach dem Upgrade von der alten auf die neue Version (und Forensoftware) gab es einen Fehler. Grund ist wohl, dass die Datenbank von all-inklusive ein bisschen anders konfiguriert ist und daher kein Update sauber durchgeführt wurde, was ich erst später (bei Anzeige aktualisieren) gemerkt habe. Mein Supporter meinte
Zitat von SupporterBei der Fehlermeldung liegt ein Problem beim Plugin der Klan-Verwaltung vor in Verbindung mit der (nicht unüblichen) Datenbank-Konfiguration deines Hosters vor. Da müsstest du dich an den Plugin-Autor wenden, dass er das korrigiert.
Hier die Fehlermeldung im Detail:
Fehlermeldung
Could not execute statement 'ALTER TABLE clan1_group_option CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci'
Stacktrace:
#0 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(56): wcf\system\database\statement\PreparedStatement->execute()
#1 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/acp/ac…n.class.php(92): wcf\system\worker\DatabaseConvertEncodingWorker->execute()
#2 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(47): wcf\acp\action\WorkerProxyAction->execute()
#3 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(63): wcf\action\AbstractAction->__run()
#4 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(83): wcf\action\AJAXInvokeAction->__run()
#5 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(96): wcf\system\request\Request->execute()
#6 /www/htdocs/w013b734/http://smashlabs.de/wcf/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)
#7 {main}
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Stacktrace
#0 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(93): PDOStatement->execute(Array)
#1 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(56): wcf\system\database\statement\PreparedStatement->execute()
#2 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/acp/ac…n.class.php(92): wcf\system\worker\DatabaseConvertEncodingWorker->execute()
#3 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(47): wcf\acp\action\WorkerProxyAction->execute()
#4 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(63): wcf\action\AbstractAction->__run()
#5 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(83): wcf\action\AJAXInvokeAction->__run()
#6 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(96): wcf\system\request\Request->execute()
#7 /www/htdocs/w013b734/http://smashlabs.de/wcf/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)
#8 {main}
Nachtrag:
Weitere Tests haben ergeben, das die Letzte Aktivitäten Seite aufgrund dieses Plugins nicht mehr funktioniert. Gerne kann ich dir das Protokoll dafür schicken.
Als ich auch die Clan Kommentare aktualisieren wollte bei "Anzeige aktuallisieren" habe ich folgende Fehlermeldung erhalten:
Spoiler anzeigen
Could not execute statement 'INSERT INTO wcf1_user_activity_point
(userID, objectTypeID, activityPoints, items) VALUES (?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?,
?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?, ?),(?, ?, ?,
?) ON DUPLICATE KEY UPDATE activityPoints = activityPoints +
VALUES(activityPoints), items = items + VALUES(items)'
Stacktrace:
#0
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system….class.php(139):
wcf\system\database\statement\PreparedStatement->execute(Array)
#1
/www/htdocs/w013b734/http://smashlabs.de/clans/lib/syst…r.class.php(92):
wcf\system\user\activity\point\UserActivityPointHandler->fireEvents('de.yourecom.cla...',
Array, false)
#2
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/acp/ac…n.class.php(92):
clan\system\worker\CommentRebuildDataWorker->execute()
#3 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(47): wcf\acp\action\WorkerProxyAction->execute()
#4 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(63): wcf\action\AbstractAction->__run()
#5 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(83): wcf\action\AJAXInvokeAction->__run()
#6
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(96):
wcf\system\request\Request->execute()
#7 /www/htdocs/w013b734/http://smashlabs.de/wcf/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)
#8 {main}
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'userID' at row 14
Stacktrace
#0
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(93):
PDOStatement->execute(Array)
#1
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system….class.php(139):
wcf\system\database\statement\PreparedStatement->execute(Array)
#2
/www/htdocs/w013b734/http://smashlabs.de/clans/lib/syst…r.class.php(92):
wcf\system\user\activity\point\UserActivityPointHandler->fireEvents('de.yourecom.cla...',
Array, false)
#3
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/acp/ac…n.class.php(92):
clan\system\worker\CommentRebuildDataWorker->execute()
#4 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(47): wcf\acp\action\WorkerProxyAction->execute()
#5 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/action…n.class.php(63): wcf\action\AbstractAction->__run()
#6 /www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…t.class.php(83): wcf\action\AJAXInvokeAction->__run()
#7
/www/htdocs/w013b734/http://smashlabs.de/wcf/lib/system…r.class.php(96):
wcf\system\request\Request->execute()
#8 /www/htdocs/w013b734/http://smashlabs.de/wcf/acp/index.php(9): wcf\system\request\RequestHandler->handle('wcf', true)
#9 {main}
Zusätzlich wurde beim Upgrade auch der geschrieben Inhalt gelöscht
Weiß einfach nicht, was da schief gelaufen sein soll.