Hallo, Gast! (Registrieren)

Wir wünschen allen Besuchern frohe Ostern!

Letzte Ankündigung: MyBB 1.8.37 veröffentlicht (04.11.23)


Benutzer, die gerade dieses Thema anschauen: 1 Gast/Gäste
Username = Datenbank
#1
Moinsen,

in unregelmäßigen Abständen erhalte ich per E-Mail folgenden Text:

Code:
Your copy of MyBB running on Garden Forum (https://garden-forum.de) has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
SQL Error: 1054 - Unknown column 'u.username' in 'order clause'
Query:
            SELECT * FROM (
                SELECT
                    s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
                    row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num
                FROM
                    mybb_sessions s
                    LEFT JOIN mybb_users u ON (s.uid = u.uid)
                WHERE s.time > 1589945740
            ) s
            WHERE row_num = 1
            ORDER BY u.username ASC, s.time DESC
            LIMIT 0, 20
        
Back Trace: #0  errorHandler->email_error(20, SQL Error: 1054 - Unknown column 'u.username' in 'order clause'
Query:
            SELECT * FROM (
                SELECT
                    s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
                    row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num
                FROM
                    mybb_sessions s
                    LEFT JOIN mybb_users u ON (s.uid = u.uid)
                WHERE s.time > 1589945740
            ) s
            WHERE row_num = 1
            ORDER BY u.username ASC, s.time DESC
            LIMIT 0, 20
        , , 0) called at [/home/users/garden/www/inc/class_error.php:195]
#1  errorHandler->error(20, Array ([error_no] => 1054,[error] => Unknown column 'u.username' in 'order clause',[query] =>
            SELECT * FROM (
                SELECT
                    s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
                    row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num
                FROM
                    mybb_sessions s
                    LEFT JOIN mybb_users u ON (s.uid = u.uid)
                WHERE s.time > 1589945740
            ) s
            WHERE row_num = 1
            ORDER BY u.username ASC, s.time DESC
            LIMIT 0, 20
        )) called at [/home/users/garden/www/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(
            SELECT * FROM (
                SELECT
                    s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
                    row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num
                FROM
                    mybb_sessions s
                    LEFT JOIN mybb_users u ON (s.uid = u.uid)
                WHERE s.time > 1589945740
            ) s
            WHERE row_num = 1
            ORDER BY u.username ASC, s.time DESC
            LIMIT 0, 20
        ) called at [/home/users/garden/www/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(
            SELECT * FROM (
                SELECT
                    s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
                    row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num
                FROM
                    mybb_sessions s
                    LEFT JOIN mybb_users u ON (s.uid = u.uid)
                WHERE s.time > 1589945740
            ) s
            WHERE row_num = 1
            ORDER BY u.username ASC, s.time DESC
            LIMIT 0, 20
        ) called at [/home/users/garden/www/online.php:223]

Ich verstehe ehrlich gesagt nicht das Problem. Kann es an einem Plugin liegen ?
 Diese Plugins sind aktiv:

Cookie Law (1.0.0)
Yet Another Sitemap (YASM) (1.2)


Gruß
Dennis
Zitieren
#2
Sufu benutzt?? Rolleyes 

Sicher nicht, denn sonst hättest Du dies gefunden.
Zitieren


Möglicherweise verwandte Themen…
Thema Verfasser Antworten Ansichten Letzter Beitrag
  Datenbankname, Username (Datenbank) spezii 2 1.076 02.09.2020, 11:15
Letzter Beitrag: spezii