Forum

Kann mich nach dem update auf 2.3.6 nicht mehr anmelden, weder als Admin noch als anderer Benutzer.
Hier die Fehlermeldungen.
Kann mir einer helfen

Dies wird auf der Startseite angezeigt:
SQL-ERROR [256] mysql error: [1054: Unknown column 'uxl.user_skype' in 'field list'] in EXECUTE("SELECT u.uid AS uid, u.uname AS uname, u.email AS email, u.user_regdate AS user_regdate, u.user_xt_option AS user_xt_option, u.user_debug AS user_debug, u.pass AS pass, u.storynum AS storynum, u.umode AS umode, u.uorder AS uorder, u.thold AS thold, u.noscore AS noscore, u.ublockon AS ublockon, u.ublock AS ublock, u.theme AS theme, u.commentmax AS commentmax, u.counter AS counter, u.rights AS rights, u.user_group AS user_group, us.rank AS rank, us.posts AS posts, us.specialrang AS specialrang, us.level1 AS level1, us.warning AS warning, us.wertung AS wertung,ustg.user_theme_group AS user_theme_group,uadr.firstname AS firstname, uadr.lastname AS lastname, uadr.street AS street, uadr.state_prov AS state_prov, uadr.zip AS zip, uadr.city AS city, uadr.phone AS phone, uadr.facsimile AS facsimile, uadr.secid AS secid, uadr.user_checked AS user_checked, uadr.mobilephone AS mobilephone,ubir.monthbirth AS monthbirth, ubir.daybirth AS dayb
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 208

und dieser Fehler wird bei der Anmeldung als Admin angezeigt

SQL-ERROR [256] mysql error: [1054: Unknown column 'uxl.user_skype' in 'field list'] in EXECUTE("SELECT u.uid AS uid, u.uname AS uname, u.email AS email, u.user_regdate AS user_regdate, u.user_xt_option AS user_xt_option, u.user_debug AS user_debug, u.pass AS pass, u.storynum AS storynum, u.umode AS umode, u.uorder AS uorder, u.thold AS thold, u.noscore AS noscore, u.ublockon AS ublockon, u.ublock AS ublock, u.theme AS theme, u.commentmax AS commentmax, u.counter AS counter, u.rights AS rights, u.user_group AS user_group, us.rank AS rank, us.posts AS posts, us.specialrang AS specialrang, us.level1 AS level1, us.warning AS warning, us.wertung AS wertung,ustg.user_theme_group AS user_theme_group,uadr.firstname AS firstname, uadr.lastname AS lastname, uadr.street AS street, uadr.state_prov AS state_prov, uadr.zip AS zip, uadr.city AS city, uadr.phone AS phone, uadr.facsimile AS facsimile, uadr.secid AS secid, uadr.user_checked AS user_checked, uadr.mobilephone AS mobilephone,ubir.monthbirth AS monthbirth, ubir.daybirth AS dayb
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 208

WARNING [8] Undefined index: level1
FOUND IN [system/user/index.php]
FOUND AT 540

mfg
Michael

da fehlt in der Tabelle eine Spalte (je nachdem von welcher version du hochgezogen hast vielleicht auch noch mehr). Der einfachste Weg das zu lösen ist der manuelle Eingriff in die Tabelle und das FEld entsprechend "von Hand" anzulegen.

Alex

Hallo

habe den update von 2.3.5 gemacht.
Welche Spalte felt in welcher Tabelle?

Michael

Unknown column 'uxl.user_skype'

Das habe ich jetzt leider nicht verstanden.

in welcher tabelle soll welche spalte?

das fehlt in der Tabelle präfix__user_infos_xl

`user_skype` varchar(25) collate latin1_german1_ci NOT NULL default '',


Flash

Hallo an alle in diesem Team

Prima. vielen Dank für eure Hilfe.

Jetzt geht es wieder.