Supportnet / Forum / Skripte(PHP,ASP,Perl...)
database error
Frage
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