Fatal error: Illegal statement 'CREATE TABLE IF NOT EXISTS `wcf1_samp_record` (
`recordID` int(11) NOT NULL auto_increment,
`userOnline` int(11) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`recordID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;'. If creating an existing table make sure you are dropping it before.
You will get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=13018
Information:
error message: Illegal statement 'CREATE TABLE IF NOT EXISTS `wcf1_samp_record` (
`recordID` int(11) NOT NULL auto_increment,
`userOnline` int(11) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`recordID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;'. If creating an existing table make sure you are dropping it before.
php version: 5.3.3-7+squeeze13
wcf version: 1.1.9 (Tempest)
file:
/var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/plugin/SqlPackageInstallationPlugin.class.php
(430)
error code: 13018
date: 10/03/2012 05:12pm
request:
/acp/index.php?page=Package&step=SqlPackageInstallationPlugin&queueID=110&action=install&packageID=27&
referer:
http://smoke-reallife.de/acp/i…ion=install&packageID=27&
Stacktrace:
#0 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/plugin/SqlPackageInstallationPlugin.class.php(229): SqlPackageInstallationPlugin->checkCreateTables('75', 'install')
#1 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/plugin/SqlPackageInstallationPlugin.class.php(85): SqlPackageInstallationPlugin->checkSQL('75', 'install')
#2 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/PackageInstallationQueue.class.php(146): SqlPackageInstallationPlugin->install()
#3 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/PackageInstallation.class.php(328): PackageInstallationQueue->executePackageInstallationPlugin('SqlPackageInsta...')
#4 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/package/PackageInstallation.class.php(52): PackageInstallation->install()
#5 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/acp/page/PackagePage.class.php(49): PackageInstallation->__construct(110)
#6 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/page/AbstractPage.class.php(46): PackagePage->show()
#7 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#8 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Package', Array, 'page')
#9 /var/www/virtual/german-ibiza-rl.de/smoke-reallife.de/htdocs/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.