Datenbank fehlt brauche Hilfe

Backstor · 5. Juli 2009

Hallo,

ich habe das Security system in einem frischen wbb 3.0.9 installiert.

Habe nichts weiter eingestellt bekomme nun aber volgenden fehler:

Code

Fatal error: Invalid SQL: SELECT * FROM `wcf1_security_sessions` WHERE `sessionID`='d5961b2b8a5922ffd775dea3696841ad1d56b569' AND `ipAddress`='84.184.122.90' AND `validity` >= '1246808642' LIMIT 1
    You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146 Information:
  error message: Invalid SQL: SELECT * FROM `wcf1_security_sessions` WHERE `sessionID`='d5961b2b8a5922ffd775dea3696841ad1d56b569' AND `ipAddress`='84.184.122.90' AND `validity` >= '1246808642' LIMIT 1
 error code: 1146
 sql type: MySQLDatabase
sql error: Table 'db_80007_1.wcf1_security_sessions' doesn't exist
sql error number: 1146
sql version: 
file: /home/webpages/lima-city/backstor/html/wcf/lib/system/database/MySQLDatabase.class.php (116)
 php version: 5.2.10
 wcf version: 1.0.11 (Horizon)
 date: Sun, 05 Jul 2009 15:44:02 +0000
 request: /acp/index.php?form=Login&packageID=38&
 referer: 
   Stacktrace:
 #0 /home/webpages/lima-city/backstor/html/wcf/lib/system/database/Database.class.php(116): MySQLDatabase->sendQuery('SELECT * FROM `...', 1, 0)
#1 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(40): Database->getFirstRow('SELECT * FROM `...')
#2 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(30): SecurityLoginListener->checkSession()
#3 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/EventHandler.class.php(193): SecurityLoginListener->execute(Object(LoginForm), 'LoginForm', 'readParameters')
#4 /home/webpages/lima-city/backstor/html/wcf/lib/page/AbstractPage.class.php(44): EventHandler::fireAction(Object(LoginForm), 'readParameters')
#5 /home/webpages/lima-city/backstor/html/wcf/lib/acp/form/LoginForm.class.php(37): AbstractPage->readParameters()
#6 /home/webpages/lima-city/backstor/html/wcf/lib/page/AbstractPage.class.php(35): LoginForm->readParameters()
#7 /home/webpages/lima-city/backstor/html/wcf/lib/acp/form/LoginForm.class.php(30): AbstractPage->__construct()
#8 /home/webpages/lima-city/backstor/html/wcf/lib/util/RequestHandler.class.php(63): LoginForm->__construct()
#9 /home/webpages/lima-city/backstor/html/wcf/lib/util/RequestHandler.class.php(94): RequestHandler->__construct('Login', Array, 'form')
#10 /home/webpages/lima-city/backstor/html/acp/index.php(8): RequestHandler::handle(Array)
#11 {main}

Alles anzeigen

Bitte um Hilfe, wie kann ich das system manuell "rausfummeln" bzw die DB erstellen?

EDIT:: es ist die Lite version URL: http://www.wow-gameforum.de

Peter · 5. Juli 2009

Hast du an der Datenbank irgendetwas verändert? Wie lautet die WCF-Nummer (wurde bei der Installation gesetzt)?

Backstor · 5. Juli 2009

Hallo,

WCF Nummer: 1

Ich habe nichts geändert hab das wbb3 frisch aufgesetzt und das security system basic installiert dachte alles sei im Lot und dann der obige Fehler.

Peter · 5. Juli 2009

Interessant... Das dürfte auf keine Fall auftreten.

Bitte führe folgenden Befehl in der Datenbank aus:

SQL

CREATE TABLE `wcf1_security_sessions` (
  `id` int(20) NOT NULL auto_increment,
  `sessionID` char(40) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default '0.0.0.0',
  `validity` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

Backstor · 5. Juli 2009

Huhu,

vielen Dank das scheint etwas bewirkt zu haben, die DB des gesammten Security Sys scheint nicht vorhanden zu sein, denn jetzt kommt folgender Fehler:

PHP

Fatal error: Invalid SQL: INSERT INTO `wcf1_security_tokens` (`id`, `token`, `page`,`validity`) VALUES (NULL , '58516677d116551e14649e8c784aa55f', 'LoginForm', '1246818369')
    You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146 Information:
 error message: Invalid SQL: INSERT INTO `wcf1_security_tokens` (`id`, `token`, `page`,`validity`) VALUES (NULL , '58516677d116551e14649e8c784aa55f', 'LoginForm', '1246818369')
 error code: 1146
 sql type: MySQLDatabase
sql error: Table 'db_80007_1.wcf1_security_tokens' doesn't exist
sql error number: 1146
sql version: 
file: /home/webpages/lima-city/backstor/html/wcf/lib/system/database/MySQLDatabase.class.php (116)
 php version: 5.2.10
 wcf version: 1.0.11 (Horizon)
 date: Sun, 05 Jul 2009 17:26:09 +0000
 request: /acp/index.php?form=Login&packageID=38&
 referer: http://www.wow-gameforum.de/index.php?page=Index
   Stacktrace:
 #0 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(54): MySQLDatabase->sendQuery('INSERT INTO `wc...')
#1 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(47): SecurityLoginListener->saveToken('58516677d116551...')
#2 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(64): SecurityLoginListener->generateToken()
#3 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/listener/SecurityLoginListener.class.php(31): SecurityLoginListener->showLogin()
#4 /home/webpages/lima-city/backstor/html/wcf/lib/system/event/EventHandler.class.php(193): SecurityLoginListener->execute(Object(LoginForm), 'LoginForm', 'readParameters')
#5 /home/webpages/lima-city/backstor/html/wcf/lib/page/AbstractPage.class.php(44): EventHandler::fireAction(Object(LoginForm), 'readParameters')
#6 /home/webpages/lima-city/backstor/html/wcf/lib/acp/form/LoginForm.class.php(37): AbstractPage->readParameters()
#7 /home/webpages/lima-city/backstor/html/wcf/lib/page/AbstractPage.class.php(35): LoginForm->readParameters()
#8 /home/webpages/lima-city/backstor/html/wcf/lib/acp/form/LoginForm.class.php(30): AbstractPage->__construct()
#9 /home/webpages/lima-city/backstor/html/wcf/lib/util/RequestHandler.class.php(63): LoginForm->__construct()
#10 /home/webpages/lima-city/backstor/html/wcf/lib/util/RequestHandler.class.php(94): RequestHandler->__construct('Login', Array, 'form')
#11 /home/webpages/lima-city/backstor/html/acp/index.php(8): RequestHandler::handle(Array)
#12 {main}

Alles anzeigen

Peter · 5. Juli 2009

Dann führe bitte folgenden Befehl aus:

SQL

CREATE TABLE `wcf1_security_accounts` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `password` varchar(50) NOT NULL,
  `checksum` varchar(50) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default '0.0.0.0',
  `host` varchar(255) NOT NULL,
  `accessErrors` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


INSERT INTO `wcf1_security_accounts` (`id`, `username`, `password`, `checksum`, `ipAddress`, `host`, `accessErrors`) VALUES (1, 'Administrator', 'ea9b7b642e903971265725b299035aa9', 's82kso04js', '', '', 0);


CREATE TABLE `wcf1_security_accounts_errors` (
  `id` int(20) NOT NULL auto_increment,
  `account` int(5) NOT NULL,
  `time` int(5) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default '0.0.0.0',
  `host` varchar(255) NOT NULL,
  `browser` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_acp_session` (
  `id` int(20) NOT NULL auto_increment,
  `sessionID` char(40) NOT NULL,
  `userID` int(20) NOT NULL,
  `username` varchar(255) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default 'x.x.x.x',
  `host` varchar(255) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `time` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_acp_session_data` (
  `sessionID` int(20) NOT NULL,
  `requestMethod` varchar(4) NOT NULL default 'GET',
  `class` varchar(255) NOT NULL,
  `data` longtext NOT NULL,
  `time` int(5) NOT NULL,
  KEY `sessionID` (`sessionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `wcf1_security_adminsessions` (
  `id` int(20) NOT NULL auto_increment,
  `sessionID` varchar(255) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default 'x.x.x.x',
  `host` varchar(255) NOT NULL,
  `time` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_adminsessions_input` (
  `id` int(20) NOT NULL auto_increment,
  `sid` char(40) NOT NULL,
  `input` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_attacks` (
  `id` int(20) NOT NULL auto_increment,
  `type` enum('unknown','blacklist','honeypot','xss','flood','spyware','sqlInjection','access') NOT NULL default 'unknown',
  `time` int(5) NOT NULL,
  `ipAddress` varchar(15) NOT NULL default '0.0.0.0',
  `host` varchar(255) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `journal` longtext NOT NULL,
  `new` tinyint(1) NOT NULL default '1',
  `hidden` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;




CREATE TABLE `wcf1_security_blacklist` (
  `id` int(50) NOT NULL auto_increment,
  `object` enum('ip','browser','host') NOT NULL default 'ip',
  `value` varchar(255) NOT NULL,
  `status` enum('block','flood','ignore') NOT NULL default 'block',
  `validity` int(5) NOT NULL default '-1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_definitions` (
  `id` int(20) NOT NULL auto_increment,
  `string` varchar(255) NOT NULL,
  `object` enum('browser','ip') NOT NULL default 'browser',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;


INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(1, '8484 Boston Project', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(2, 'atSpider', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(3, 'autoemailspider', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(4, 'China Local Browse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(5, 'ContactBot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(6, 'ContentSmartz', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(7, 'DataCha0s', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(66, '82.208.139.1?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(9, 'DBrowse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(10, 'Browse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(11, 'Demo Bot DOT', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(12, 'Demo Bot Z', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(13, 'DSurf15a', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(14, 'EBrowse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(15, 'Educate Search VxB', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(16, 'EmailSiphon', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(17, 'EmailWolf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(18, 'ESurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(19, 'ExtractorPro', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(20, 'FSurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(21, 'Full Web Bot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(22, 'infoConveraCrawler', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(23, 'ISC Systems iRc Search', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(24, 'LARBIN-EXPERIMENTAL', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(25, 'LetsCrawl.com', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(26, 'Lincoln State Web Browser', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(27, 'LMQueueBot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(28, 'LWP::Simple', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(29, 'Mac Finder', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(30, 'MFC Foundation Class Library', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(31, 'Microsoft URL Control', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(32, 'Missauga Locate', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(33, 'Missigua Locator', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(34, 'Missouri College Browse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(35, 'Mizzu Labs', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(36, 'Mo College', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(37, 'Mozilla/4.0 (compatible; Advanced Email Extractor', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(38, 'Mozilla/4.0 (compatible; Iplexx Spider/1.0 http://www.iplexx.at)', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(39, 'DTS Agent', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(40, 'Fetch API Request', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(41, '[email protected]', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(42, 'MVAClient', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(43, 'NASA Search', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(44, 'Nsauditor', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(45, 'PBrowse', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(46, 'PEval', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(47, 'Poirot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(48, 'Port Huron Labs', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(49, 'Production Bot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(50, 'Program Shareware', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(51, 'PSurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(52, 'psycheclone', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(53, 'RSurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(54, 'searchbot [email protected]', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(55, 'Snapbot', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(56, 'snap.com', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(57, 'sogou spider', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(58, 'Sogou web spider', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(59, 'sohu agent', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(60, 'SSurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(61, 'TSurf', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(62, 'Under the Rainbow', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(63, 'WebVulnCrawl', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(64, 'Wells Search', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(65, 'WEP Search', 'browser');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(67, '86.123.65.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(68, '208.35.1?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(69, '62.163.?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(70, '62.194.?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(71, '218.111.83.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(72, '218.149.129.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(73, '67.112.?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(74, '217.34.59.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(75, '68.154.96.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(76, '65.66.?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(77, '68.4.?.?', 'ip');
INSERT INTO `wcf1_security_definitions` (`id`, `string`, `object`) VALUES(78, '66.230.140.?', 'ip');


CREATE TABLE `wcf1_security_errors` (
  `id` int(20) NOT NULL auto_increment,
  `userData` int(20) NOT NULL,
  `type` enum('blacklist','honeypot','access','flood','xss') NOT NULL,
  `time` int(5) NOT NULL,
  `data` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;




CREATE TABLE `wcf1_security_help` (
  `id` int(20) NOT NULL auto_increment,
  `lang` varchar(10) NOT NULL default 'de',
  `lft` int(20) NOT NULL,
  `rgt` int(20) NOT NULL,
  `page` varchar(255) NOT NULL,
  `isIndex` tinyint(1) NOT NULL default '0',
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `file` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;


INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(1, 'de', 1, 24, 'index', 1, 'Startseite', '', 'lib/system/security/storage/documentation/de.index.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(2, 'de', 2, 9, 'info', 1, '1. Allgemeine Informationen', '', '');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(3, 'de', 3, 4, 'info.about', 0, '1.1 Was ist das SecuritySystem premium?', '', 'lib/system/security/storage/documentation/de.info.about.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(4, 'de', 5, 6, 'info.protection', 0, '1.2 Warum soll ich mein Forum sch&uuml;tzen?', '', 'lib/system/security/storage/documentation/de.info.protection.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(5, 'de', 7, 8, 'info.license', 0, '1.3 Lizenzbestimmungen', '', 'lib/system/security/storage/system/licenseFile.inc.php');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(6, 'de', 10, 23, 'attackInfo', 1, '2. Angriffsinformationen', '', '');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(7, 'de', 11, 12, 'attackInfo.bruteForce', 0, '2.1 BruteForce Methode', '', 'lib/system/security/storage/documentation/de.attackInfo.bruteForce.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(8, 'de', 13, 14, 'attackInfo.xss', 0, '2.2 Cross-Site Scripting (XSS)', '', 'lib/system/security/storage/documentation/de.attackInfo.xss.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(9, 'de', 15, 16, 'attackInfo.sqlInjection', 0, '2.3 SQL Injection', '', 'lib/system/security/storage/documentation/de.attackInfo.sqlInjection.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(10, 'de', 17, 18, 'attackInfo.parameter', 0, '2.4 Parametermanipulation', '', 'lib/system/security/storage/documentation/de.attackInfo.parameter.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(11, 'de', 19, 20, 'attackInfo.upload', 0, '2.5  Angriffe &uuml;ber Uploadfunktionen', '', 'lib/system/security/storage/documentation/de.attackInfo.upload.txt');
INSERT INTO `wcf1_security_help` (`id`, `lang`, `lft`, `rgt`, `page`, `isIndex`, `title`, `content`, `file`) VALUES(12, 'de', 21, 22, 'attackInfo.DoS', 0, '2.6  Floodangriffe und Denial of Service (DoS)', '', 'lib/system/security/storage/documentation/de.attackInfo.DoS.txt');


CREATE TABLE `wcf1_security_income` (
  `id` int(20) NOT NULL auto_increment,
  `referer` varchar(255) NOT NULL,
  `request` varchar(255) NOT NULL,
  `time` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_liveupdate_backup` (
  `id` int(20) NOT NULL auto_increment,
  `time` int(5) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `cmd` enum('deleteFile','updateFile','createFile') NOT NULL,
  `version` varchar(20) NOT NULL default 'x.x.x',
  `storageFile` varchar(255) NOT NULL,
  `rollback` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_places` (
  `placeID` bigint(20) NOT NULL auto_increment,
  `place` varchar(255) NOT NULL,
  `package` int(20) NOT NULL,
  PRIMARY KEY  (`placeID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_queue` (
  `id` int(10) NOT NULL auto_increment,
  `classPath` varchar(255) NOT NULL,
  `startExec` int(10) NOT NULL,
  `type` enum('db','ftp','system','syslog','unknown') NOT NULL default 'unknown',
  `page` int(10) NOT NULL,
  `nextPage` INT(5) NOT NULL,
  `visibleTask` tinyint(1) NOT NULL default '1',
  `error` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_releases` (
  `id` int(5) NOT NULL auto_increment,
  `version` varchar(255) NOT NULL,
  `time` int(5) NOT NULL,
  `changes` longtext NOT NULL,
  `file` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_tokens` (
  `id` int(20) NOT NULL auto_increment,
  `token` varchar(255) NOT NULL,
  `page` varchar(255) NOT NULL,
  `validity` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;




CREATE TABLE `wcf1_security_user_access_activation` (
  `id` int(20) NOT NULL auto_increment,
  `userID` int(20) NOT NULL,
  `activationCode` varchar(50) NOT NULL,
  `expiry` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `wcf1_security_flood` (
  `id` int(20) NOT NULL auto_increment,
  `ip` char(15) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Alles anzeigen

Backstor · 5. Juli 2009

Vielen Herzlichen Dank, genau das wars funzt einwandfrei jetzt.

Tags