2018-12-07, 09:37 PM
We are getting the following error message. Could any advise the problem and cure please.
Using version 1.8.19
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'r.username' in 'order clause'QueryELECT r.*, u.username, u.usergroup, u.displaygroup FROM mybb_threadsread r LEFT JOIN mybb_users u ON (u.uid = r.uid) WHERE r.tid = '2028' AND u.uid != '0' ORDER BY r.username ASC LIMIT 100
Using version 1.8.19
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'r.username' in 'order clause'QueryELECT r.*, u.username, u.usergroup, u.displaygroup FROM mybb_threadsread r LEFT JOIN mybb_users u ON (u.uid = r.uid) WHERE r.tid = '2028' AND u.uid != '0' ORDER BY r.username ASC LIMIT 100