Discuz! info: MySQL Query Error
Time: 2009-1-9 3:39pm
Script: /space.php
SQL: SELECT t.tid, t.subject, t.special, t.price, t.fid, t.views, t.replies, t.author, t.authorid, t.lastpost, t.lastposter, t.attachment, p.pid, p.message FROM [Table]mythreads m INNER JOIN [Table]posts p ON p.tid=m.tid AND p.first='1'
INNER JOIN [Table]threads t ON t.blog='0' AND t.authorid='114613' AND t.author!='' AND t.price='0' AND t.fid IN (0,1,2,3,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,53,55,57,58,59,60,62,63,64,67,68,69,70,71,72,73,75,76,77) AND t.displayorder>='0' AND t.readperm<='10'
WHERE m.uid='114613' AND m.tid=t.tid ORDER BY t.lastpost DESC LIMIT 5
Error: Unknown column 't.blog' in 'on clause'
Errno.: 1054
Similar error report has beed dispatched to administrator before.