Coder Forum

Source code

Fatal error: Invalid SQL: CREATE TABLE wcf3_taggingreloaded ( taggingID int(10) unsigned NOT NULL, userID int(10) unsigned NOT NULL, tag varchar(96) collate utf8_bin NOT NULL DEFAULT '', weight smallint(2) unsigned NOT NULL, PRIMARY KEY (taggingID, userID, tag), INDEX tag (tag) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE utf8_bin

You will get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1253
Information:

error message: Invalid SQL: CREATE TABLE wcf3_taggingreloaded ( taggingID int(10) unsigned NOT NULL, userID int(10) unsigned NOT NULL, tag varchar(96) collate utf8_bin NOT NULL DEFAULT '', weight smallint(2) unsigned NOT NULL, PRIMARY KEY (taggingID, userID, tag), INDEX tag (tag) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE utf8_bin
sql error: COLLATION 'utf8_bin' ist für CHARACTER SET 'latin1' ungültig
sql error number: 1253
sql version:
php version: 5.2.6
wcf version: 1.0.8
file: /home/www/p1815/html/wbb3/wcf/lib/system/database/MySQLDatabase.class.php (116)
error code: 1253
date: 08/01/2008 02:05pm
request: /wbb3/acp/index.php?page=Package&step=SqlPackageInstallationPlugin&queueID=143&action=install&packageID=38&
referer:
Stacktrace:

#0 /home/www/p1815/html/wbb3/wcf/lib/system/database/QueryParser.class.php(68): MySQLDatabase->sendQuery('CREATE TABLE wc...')
#1 /home/www/p1815/html/wbb3/wcf/lib/acp/package/plugin/SqlPackageInstallationPlugin.class.php(104): QueryParser::sendQueries('DROP TABLE IF E...', '104')
#2 /home/www/p1815/html/wbb3/wcf/lib/acp/package/PackageInstallationQueue.class.php(141): SqlPackageInstallationPlugin->install()
#3 /home/www/p1815/html/wbb3/wcf/lib/acp/package/PackageInstallation.class.php(319): PackageInstallationQueue->executePackageInstallationPlugin('SqlPackageInsta...')
#4 /home/www/p1815/html/wbb3/wcf/lib/acp/package/PackageInstallation.class.php(52): PackageInstallation->install()
#5 /home/www/p1815/html/wbb3/wcf/lib/acp/page/PackagePage.class.php(42): PackageInstallation->__construct(143)
#6 /home/www/p1815/html/wbb3/wcf/lib/page/AbstractPage.class.php(36): PackagePage->show()
#7 /home/www/p1815/html/wbb3/wcf/lib/util/RequestHandler.class.php(63): AbstractPage->__construct()
#8 /home/www/p1815/html/wbb3/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('Package', Array, 'page')
#9 /home/www/p1815/html/wbb3/acp/index.php(8): RequestHandler::handle(Array)
#10 {main}

Click the button below to undo the installation that lead to this error and to clean up your system.