[winduff]

looks great, but I receive an mySQL Error when accessing the UserCP!

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT
modlog.moderatorlogid as id,
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
editlog.postid as editpostid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason,
editlog.reason as editreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (IF(modlog.forumid,forum.forumid = modlog.forumid,forum.forumid = thread.forumid))
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
LEFT JOIN editlog AS editlog ON (IF(modlog.postid OR modlog.type!=20,editlog.postid = modlog.postid,editlog.dateline = modlog.dateline AND editlog.userid = modlog.userid))
WHERE
IF(modlog.postid>0,post.userid=1,thread.postuserid =1) AND modtable.userid != 1 AND modlog.type NOT IN (11,12)
ORDER BY modlog.dateline DESC
LIMIT 10;

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, August 12th 2007 @ 08:24:39 AM
Script : .../usercp.php
Referrer : .../index.php
IP Address : 82.113.106.16
Username : Chris
Classname : vb_database