I get this syntax error whenever I try to update from 4.0.10 to 4.1.11. Tried both the automatic update and uploading the update package manually.
Code
Fatal error: Could not execute prepared statement: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'authData'
Information:
id: d7e4ddf153dd234a966af883c43d71a244c79ec3
error message: Could not execute prepared statement: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'authData'
error code: 42000
sql type: wcf\system\database\MySQLDatabase
sql error: Duplicate key name 'authData'
sql error number: 42000
sql version: 5.5.41-log
sql query: ALTER TABLE `wcf1_user` ADD KEY `authData` (`authData`)
file: /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/database/statement/PreparedStatement.class.php (97)
php version: 5.5.32-1+deb.sury.org~precise+1
wcf version: 2.1.11 (Typhoon)
date: Mon, 25 Jul 2016 19:30:29 +0000
request: /acp/index.php?install-package/&&
referer: http://forum.euro-farm.eu/acp/index.php?package-installation-confirm/&queueID=73&
Stacktrace:
#0 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/database/editor/MySQLDatabaseEditor.class.php(144): wcf\system\database\statement\PreparedStatement->execute()
#1 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/database/util/SQLParser.class.php(257): wcf\system\database\editor\MySQLDatabaseEditor->addIndex('wcf1_user', 'authData', Array)
#2 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/package/PackageInstallationSQLParser.class.php(329): wcf\system\database\util\SQLParser->executeAddIndexStatement('wcf1_user', 'authData', Array)
#3 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/database/util/SQLParser.class.php(120): wcf\system\package\PackageInstallationSQLParser->executeAddIndexStatement('wcf1_user', 'authData', Array)
#4 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/database/util/SQLParser.class.php(49): wcf\system\database\util\SQLParser->executeStatement('ALTER TABLE', 'ALTER TABLE wcf...')
#5 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php(78): wcf\system\database\util\SQLParser->execute()
#6 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php(72): wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
#7 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/package/PackageInstallationDispatcher.class.php(571): wcf\system\package\plugin\AbstractPackageInstallationPlugin->update()
#8 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/package/PackageInstallationDispatcher.class.php(139): wcf\system\package\PackageInstallationDispatcher->executePIP(Array)
#9 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/acp/action/InstallPackageAction.class.php(73): wcf\system\package\PackageInstallationDispatcher->install('125839ac')
#10 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/action/AbstractDialogAction.class.php(70): wcf\acp\action\InstallPackageAction->stepInstall()
#11 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AbstractDialogAction->execute()
#12 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/request/Request.class.php(58): wcf\action\AbstractAction->__run()
#13 /storage/content/44/106744/forum.euro-farm.eu/public_html/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#14 /storage/content/44/106744/forum.euro-farm.eu/public_html/acp/index.php(10): wcf\system\request\RequestHandler->handle('wbb', true)
#15 {main}
