Probleme beim Einloggen

  • Hallo,
    ich habe die kostenlose Version vom Sicherheitssystem, nun habe ich folgendes problem.
    Immer wenn ich mich einlogge passiert einfach nichts. Es leitet mich nicht weiter in mein ACP, sondern bleibt einfach so.


    MFG Henry

    • Official Post

    Führe bitte folgende Queries in der Datenbank aus. Das behebt den Fehler.

    SQL
    ALTER TABLE  `wcf1_security_accounts` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_accounts_errors` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_acp_session` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x'
    ALTER TABLE  `wcf1_security_adminsessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x'
    ALTER TABLE  `wcf1_security_attacks` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_flood` CHANGE  `ip`  `ip` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
    ALTER TABLE  `wcf1_security_honeypot` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_sessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_user_history` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
    ALTER TABLE  `wcf1_security_user_login` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0'
  • Danke, aber diese Meldung kommt dann.
    Habe die aber einzeln durchgegangen

    Quote

    ALTER TABLE `wcf1_security_honeypot` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    ALTER TABLE `wcf1_security_sessions` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    ALTER TABLE `wcf1_security_user_history` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    ALTER TABLE `wcf1_security_user_login` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'

    Die macht er nicht.


    Es geht immernoch nicht.

  • Aufgrund seines Zitas vermute ich diese hier:

    SQL
    ALTER TABLE `wcf1_security_honeypot` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    
    
    ALTER TABLE `wcf1_security_sessions` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    
    
    ALTER TABLE `wcf1_security_user_history` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    
    
    ALTER TABLE `wcf1_security_user_login` CHANGE `ipAddress` `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0'
    • Official Post

    Probier mal folgende Queries

    SQL
    ALTER TABLE  `wcf1_security_accounts` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_accounts_errors` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_acp_session` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_adminsessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_attacks` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_flood` CHANGE  `ip`  `ip` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    ALTER TABLE  `wcf1_security_honeypot` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_sessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_user_history` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_user_login` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    • Official Post

    Probier mal folgende Queries.


    SQL
    ALTER TABLE  `wcf1_security_accounts` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_accounts_errors` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_acp_session` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_adminsessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_attacks` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_flood` CHANGE  `ip`  `ip` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    ALTER TABLE  `wcf1_security_sessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_user_history` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_user_login` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    • Official Post

    Ok, danke.. für andere sollten diese Abfragen helfen:


    SQL
    ALTER TABLE  `wcf1_security_accounts` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_accounts_errors` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_acp_session` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_adminsessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'x.x.x.x';
    ALTER TABLE  `wcf1_security_attacks` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_flood` CHANGE  `ip`  `ip` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
    ALTER TABLE  `wcf1_security_sessions` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';
    ALTER TABLE  `wcf1_security_user_login` CHANGE  `ipAddress`  `ipAddress` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '0.0.0.0';