MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

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 srv_sessions s LEFT JOIN srv_users u ON (s.uid = u.uid) WHERE s.time > 1710838045 ) s WHERE row_num = 1 ORDER BY u.username ASC, s.time DESC LIMIT 0, 20