Probleme beim Einloggen

Henry10222

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

Peter

Nutzt du zufälligerweise IPv6?

Henry10222

Ja, hab auch eine IPv6 Adresse.

Also, wenn ich das einloggen durchgeführt habe, ändert sich nur oben in der Adresszeile der Link.

Peter

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'

Henry10222

Zitat

Fehler

SQL-Befehl:

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( [...]

MySQL meldet: [Blockierte Grafik: https://zauberflausch-community.de/sqladmin/themes/original/img/b_help.png]

#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ALTER TABLE `wcf1_security_accounts_errors`
CHANGE `ipAddress` `ipAddress` VA' at line 2

Alles anzeigen

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.

Peter

Welche Zeilen haben genau nicht funktioniert?

[FFW] Patric

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'

Peter

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

dannyfilth

Habe das gleiche Problem, bei der Passwortabfrage zum Security System passiert nichts beim einloggen, gebe ich falsches PW ein, meldet das System daß PW falsch ist.

Peter

Hast du die Queries ausgeführt?

dannyfilth

Ja, ändert sich gar nichts, bei der Abfrage wird mir mitgeteilt, daß diese "
wcf1_security_honeypot" nicht existiert.

Peter

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

dannyfilth

Danke Peter, das funktioniert, auch mit der Fehlermeldung die nach der Abfrage kam:

SQL

#1146 - Table 'db295720_6.wcf1_security_user_history' doesn't exist

Aber ich komm wieder rein

Peter

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

Probleme beim Einloggen

Tags

Benutzer online in diesem Thema