SQL-DATABASE ERROR
Database error in WoltLab Burning Board (2.3.6): Invalid SQL: SELECT
t.*,
p.*,
i.*,
n.id AS newscat_id, n.title AS newscat_title, n.grafikfile, n.position,
b.title AS b_title, b.hotthread_reply AS b_hotthread_reply, b.hotthread_view AS b_hotthread_view, b.postsperpage AS b_postsperpage, b.lastposttime AS b_lastposttime
FROM bb1_threads t
LEFT JOIN bb1_posts p ON (t.threadid=p.threadid && t.starttime=p.posttime)
LEFT JOIN bb1_icons i USING (iconid)
LEFT JOIN bb1_boards b ON (b.boardid=t.boardid)
LEFT JOIN bb1_portal_newscat n ON (t.newscatid=n.id)
WHERE t.visible = 1 AND p.visible = 1 AND t.boardid IN (0,5,11,74,98,6,4,95,99,15,17,16,8,109,19,20,63,103,93,96,72,59,53,56,80,102,36,65,66,69,70,71,73,75,76,77,78,79,94,104,97,22,23,24,25,26,27,28,29,30,110,31,32) AND t.boardid IN (0)
ORDER BY t.starttime DESC
LIMIT 0,20
mysql error: Column 'iconid' in from clause is ambiguous
mysql error number: 1052
mysql version: 5.1.41-community-log
php version: 5.2.5 (x64)
Date: 06.09.2010 @ 14:05
Script:
Referer: