15.01.2020, 13:17
Ich bekomme momentan öfter eine Mail mit folgender Fehlermeldung...
...wo soll ich mit der Suche beginnen?
Code:
Your copy of MyBB running on xxx (...) 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 > 1579036741
) s
WHERE row_num = 1
ORDER BY u.username ASC, s.time DESC
LIMIT 0, 40
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 > 1579036741
) s
WHERE row_num = 1
ORDER BY u.username ASC, s.time DESC
LIMIT 0, 40
, , 0) called at [/var/customers/webs/forum/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 > 1579036741
) s
WHERE row_num = 1
ORDER BY u.username ASC, s.time DESC
LIMIT 0, 40
)) called at [/var/customers/webs/forum/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 > 1579036741
) s
WHERE row_num = 1
ORDER BY u.username ASC, s.time DESC
LIMIT 0, 40
) called at [/var/customers/webs/forum/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 > 1579036741
) s
WHERE row_num = 1
ORDER BY u.username ASC, s.time DESC
LIMIT 0, 40
) called at [/var/customers/webs/forum/online.php:223]...wo soll ich mit der Suche beginnen?
