[wildweaselmi]

Just to let you know

I have an admin category that is only available for admins. So I have that category as exclude on all usergroups.

Suprisingly items uploaded to that admin category still show up in most popular and latest files to users with no access to include unregistered users.

If an unregistered user clicks on the file they get this nasty database error and I get emailed this:

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT vb_dl2_files.*, vb_dl2_extensions.mimetype, vb_dl2_extensions.newwindow
FROM vb_dl2_files
LEFT JOIN vb_dl2_extensions ON (vb_dl2_extensions.extension=vb_dl2_files.extensio n)
WHERE `files.category` NOT IN (1) AND
vb_dl2_files.id = 1;

MySQL Error : Unknown column 'files.category' in 'where clause'
Error Number : 1054
Request Date : Wednesday, December 30th 2009 @ 07:18:24 AM
Error Date : Wednesday, December 30th 2009 @ 07:18:25 AM
Script : http://www.mywiseguys.com/forums/dow...p?do=file&id=1
Referrer : http://www.mywiseguys.com/forums/downloads.php
IP Address : 24.11.27.21
Username : Unregistered
Classname : vB_Database
MySQL Version :