Aehnliche Themen [mod by Flavius]

1:
2:

$auslesen= explode(" ",$threadtopic);
$similar = $db->query("SELECT t.threadid, t.boardid, x.title, x.boardid, t.prefix, t.topic, t.starttime, t.starterid, t.starter, t.lastposttime, t.lastposterid, t.lastposter, t.replycount, t.views, t.attachments, t.closed, t.important, t.pollid FROM bb".$n."_threads t, bb".$n."_boards x LEFT JOIN bb".$n."_boards b ON (t.boardid=b.boardid) WHERE t.visible='1' AND t.closed <> 3 AND t.threadid <> $threadid AND b.password='' AND t.boardid=x.boardid AND t.boardid IN (0".GetAccessableForums().") AND t.topic LIKE '%$auslesen[0]%' ORDER BY t.lastposttime DESC LIMIT 0, $similar_howmany;");

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

SQL-DATABASE ERROR

Database error in WoltLab Burning Board (2.3.5): Invalid SQL: SELECT t.threadid, t.boardid, x.title, x.boardid, t.prefix, t.topic, t.starttime, t.starterid, t.starter, t.lastposttime, t.lastposterid, t.lastposter, t.replycount, t.views, t.attachments, t.closed, t.important, t.pollid FROM bb1_threads t, bb1_boards x LEFT JOIN bb1_boards b ON (t.boardid=b.boardid) WHERE t.visible='1' AND t.closed <> 3 AND t.threadid <> 1767 AND b.password='' AND t.boardid=x.boardid AND t.boardid IN (0,54,1,6,9,12,17,22,27,31,34,5,2,4,3,36,38,39,40,41,42,43,44,7,8,47,10,11,45,46,13,14,15,16,48,18,19,20,21,49,23,24,25,26,28,29,30,32,53,33,50,52,35) AND t.topic LIKE '%Pw%' ORDER BY t.lastposttime DESC LIMIT 0, 5;
mysql error: Unbekanntes Tabellenfeld 't.boardid' in on clause
mysql error number: 1054
mysql version: 5.0.22-Debian_3-log
php version: 4.4.2-1.1
Date: 09.07.2006 @ 06:45
Script: /thread.php?postid=28818
Referer: http://forum.ageofchange.de/index.php?sid=

1:

<if($similar_status==1)><then>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

SQL-DATABASE ERROR

Database error in WoltLab Burning Board (2.3.6): Invalid SQL: SELECT t.threadid, t.boardid, x.title, x.boardid, t.prefix, t.topic, t.starttime, t.starterid, t.starter, t.lastposttime, t.lastposterid, t.lastposter, t.replycount, t.views, t.attachments, t.closed, t.important, t.pollid FROM bb1_threads t, bb1_boards x LEFT JOIN bb1_boards b ON (t.boardid=b.boardid) WHERE t.visible='1' AND t.closed <> 3 AND t.threadid <> 4 AND b.password='' AND t.boardid=x.boardid AND t.boardid IN (0,4,1,17,9,10,11,8,2,12,13,15,14,16,42,32,3,33,5,37,26,31,29,30,34,35,36,38,39,40,27,41,18,19,20,21,22,24,25) AND t.topic LIKE '%Wie habt ihr uns gefunden?%' ORDER BY t.lastposttime DESC LIMIT 0, ;
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql error number: 1064
mysql version: 4.1.13
php version: 4.4.0
Date: 17.11.2006 @ 06:19
Script: /thread.php?postid=6
Referer: http://extreme-gfx.ath.cx/index.php