[Ross L]

You could create a user group for new users that doesn't have download permissions and then use the promotion system to move them to the registered user group after X posts to allow downloads.

Originally Posted by Ross L

Hopefully someone can point me in the right direction with this.

When the search function is used on downloadsII, I get this database error emailed to me:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT dl_files.*,  dl_cats.name catname FROM dl_files, dl_cats WHERE  (CT title,dateline_from,eventid FROM event WHERE dateline_from BETWEEN 1230814892 AND 1231419692 OR 1230814892 BETWEEN dateline_from AND dateline_to ORDER BY dateline_from OR dl_files.author LIKE '%test%' OR dl_files.name LIKE '%test%' OR dl_files.description LIKE '%test%') 
									AND dl_files.category = dl_cats.id
									ORDER BY catname, dl_files.name;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title,dateline_from,eventid FROM event WHERE dateline_from BETWEEN 1230814892 AN' at line 1
Error Number  : 1064
Request Date  : Thursday, January 1st 2009 @ 01:01:32 PM
Error Date    : Thursday, January 1st 2009 @ 01:01:32 PM

Any ideas on how to fix this?

Many thanks.

Any ideas on this?