YourWBB

SQL-DATABASE ERRORDatabase error in WoltLab Burning Board (2.1.6): Invalid SQL: SELECT MIN(p.postid) AS minpost, MAX(p.postid) AS maxpost, t.threadid, MIN(p.posttime) AS starttime, MAX(p.posttime) AS lastposttime,
  (COUNT(*)-1) AS posts, COUNT(a.attachmentid) AS attachments
  FROM bb2_posts p, bb2_threads t
  LEFT JOIN bb2_attachments a ON (a.attachmentid=p.attachmentid)
  WHERE t.threadid=p.threadid
  GROUP BY t.threadid LIMIT 0, 500
mysql error: Unknown column 'p.attachmentid' in 'on clause'
mysql error number: 1054
mysql version: 5.1.41-3ubuntu12.10
php version: 5.3.2-1ubuntu4.14
Date: 18.02.2012 @ 09:34
Script: /acp/otherstuff.php?sid=&action=threads&perpage=500

 if($page<=$pages) {
  refresh_start();
  $result=$db->query("SELECT MIN(p.postid) AS minpost, MAX(p.postid) AS maxpost, t.threadid, MIN(p.posttime) AS starttime, MAX(p.posttime) AS lastposttime,
  (COUNT(*)-1) AS posts, COUNT(a.attachmentid) AS attachments
  FROM bb".$n."_posts p, bb".$n."_threads t
  LEFT JOIN bb".$n."_attachments a ON (a.attachmentid=p.attachmentid)
  WHERE t.threadid=p.threadid
  GROUP BY t.threadid",$perpage,$perpage*($page-1));

 if($page<=$pages) {
  refresh_start();
  $result=$db->query("SELECT MIN(p.postid) AS minpost, MAX(p.postid) AS maxpost, t.threadid, MIN(p.posttime) AS starttime, MAX(p.posttime) AS lastposttime,
  (COUNT(*)-1) AS posts, COUNT(a.attachmentid) AS attachments
  FROM (((bb".$n."_posts p, bb".$n."_threads t)
  LEFT JOIN bb".$n."_attachments a ON (a.attachmentid=p.attachmentid)))
  WHERE t.threadid=p.threadid
  GROUP BY t.threadid",$perpage,$perpage*($page-1));