hallo,

kann mir jemand sagen was dieser fehler bedeutet und wie ich diesen beheben kann.

DATABASE ERROR

SQL error: Column 'nUsrId' in from clause is ambiguous
SQL error number: 1052
Script: /brdIndex.php?action=board&nId=17

Please contact system administrator.

Full query:

SELECT t.*, MAX(p.uPosttime) AS nLastpost, COUNT(p.nPstId) -1 AS nReplies,
p.sNameUser AS sNameUserDeleted, u.sNameUser, u.nUsrId FROM cn1_brd_thread t
INNER JOIN cn1_brd_board b USING (nBrdId)
INNER JOIN cn1_brd_post p ON (t.nThrId = p.nThrId)
LEFT JOIN cn1_sys_user u USING (nUsrId)
WHERE b.nBrdId = '17'
GROUP BY t.nThrId
ORDER BY nLastpost DESC
LIMIT 0, 10