[RogerA]

Originally Posted by RogerA

Hi:

I'm getting the following error message

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT dl2_files.*, dl2_extensions.mimetype, dl2_extensions.newwindow
FROM dl2_files
LEFT JOIN dl2_extensions ON (dl2_extensions.extension=dl2_files.extension)
WHERE `files.category` NOT IN (4) AND
dl2_files.id = 1;

MySQL Error : Unknown column 'files.category' in 'where clause'
Error Number : 1054

When I download files (as Admin) I don;t have any problems at all. The error message is being generated by normal registered users.

Any idea what might be going on?

Thanks

Roger

OK - answered my own question, this was caused by trying to exclude a download section

I know, I should have read the first post
"•Exclude files/categories not working good. Could throw a database error."

It does.

Roger