Quote:
Originally Posted by Zachery
What mod, and its not possible for a stock feature like that to normally generate database errors, if it is generating them please post them so we can take a look and fix it.
|
The 3.5.4 version of the mod (does not work after I upgraded to 3.6.2) is called [vB 3.5.4] Allow Guests to view thread titles only... [v.1.00]
Here is the error it gives me via email when a guest tries to view when I have your suggestion set
atabase error in vBulletin 3.6.2:
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, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
,post.pagetext
FROM thread AS thread
WHERE thread.threadid IN (0)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Thursday, November 2nd 2006 @ 04:17:30 PM
Script :
http://www.xxxxxxxx.net/forumdisplay.php?f=2
Referrer :
http://www.xxxxxxxx.net/
IP Address : 12.345.678.901
Username : Unregistered
Classname : vb_database