Probleme beim Einloggen

    • Offizieller Beitrag

    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

    Zitat

    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'
    • Offizieller Beitrag

    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';
    • Offizieller Beitrag

    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';
    • Offizieller Beitrag

    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';