PDA

View Full Version : DB error while posting


zodehala
01-25-2006, 04:24 PM
when i set following permission


AdminCP > usergroup > Forum Viewing Permissions



Can View Forum: Yes



Can View Thread Content: No



Can View Others' Threads: Yes



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







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,145 9,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





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

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

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