[zodehala]

when i set following permission


AdminCP > usergroup > Forum Viewing Permissions

PHP Code:

Can View Forum: Yes 



Can View Thread Content: No 



Can View Others' Threads: Yes 


following dB error is occured (error source code is following)

PHP Code:

Invalid SQL:



SELECT 

IF(votenum >= 1, votenum, 0) AS votenum,

IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,



thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,

thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,

hiddencount





,post.pagetext

FROM thread AS thread













WHERE thread.threadid IN (0,4567,4314,517,3841,3760,3750,3655,3576,3531,1459,2465,3389,3280,3171,2096,2754,2748,2958,764,527) 

ORDER BY sticky DESC, thread.lastpost DESC;



MySQL Error : Unknown table 'post' in field list

Error Number : 1109

Date : Tuesday, January 24th 2006 @ 12:20:56 PM

Script : http://xxx.com/forumdisplay.php?f=22

Referrer : http://xxx.com/

Username : Guest

Classname : vb_database 


PHP Code:

 // ****** TABLE PREFIX ******

// Prefix that your vBulletin tables have in the database.

$config['Database']['tableprefix'] = '';