2011-03-06, 08:39 PM
I tried to filter PM via PM Admin(mod) and got this error.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'pm.fromuid' in 'where clause'
Query:
SELECT pm.*, fu.username AS from_username, tu.username as to_username, fu.usergroup as from_usergroup, fu.displaygroup as from_displaygroup, tu.usergroup as to_usergroup, tu.displaygroup as to_displaygroup FROM mybb_privatemessages pm LEFT JOIN mybb_users fu ON (fu.uid=pm.fromid) LEFT JOIN mybb_users tu ON (tu.uid=pm.toid) WHERE 1=1 AND pm.folder = '2'AND pm.fromuid='17'AND pm.toid='1' ORDER BY pm.dateline DESC LIMIT 0, 20
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'pm.fromuid' in 'where clause'
Query:
SELECT pm.*, fu.username AS from_username, tu.username as to_username, fu.usergroup as from_usergroup, fu.displaygroup as from_displaygroup, tu.usergroup as to_usergroup, tu.displaygroup as to_displaygroup FROM mybb_privatemessages pm LEFT JOIN mybb_users fu ON (fu.uid=pm.fromid) LEFT JOIN mybb_users tu ON (tu.uid=pm.toid) WHERE 1=1 AND pm.folder = '2'AND pm.fromuid='17'AND pm.toid='1' ORDER BY pm.dateline DESC LIMIT 0, 20
