The Arcive of vBulletin Modifications Site.

zodehala · #1 01-25-2006, 04:24 PM

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 &gt;= 1, votenum, 0) AS votenum,

IF(votenum &gt;= 1 AND votenum &gt; 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&lt;=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'] = '';