Datenbank fehlt brauche Hilfe

Backstor

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

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

Backstor

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

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

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

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

Vielen Herzlichen Dank, genau das wars funzt einwandfrei jetzt.

Datenbank fehlt brauche Hilfe

Tags

Benutzer online in diesem Thema