[Smitty]

Originally Posted by Ronin Six

Great work DWard!

Not sure if it's because I'm not logged in (do you have a test user I can log in as?), but I get errors when I try to sort by user.

I noticed that earlier today:

Database error in vBulletin 3.0.1:

Invalid SQL: 
	SELECT * FROM attachment AS attachment
	LEFT JOIN user AS user ON (user.userid = attachment.userid)
	INNER JOIN post AS post ON (attachment.postid = post.postid)
	INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
	INNER JOIN forum AS forum ON (thread.forumid = forum.forumid) WHERE filename LIKE '%.gif' OR filename LIKE '%.jpg' OR filename LIKE '%.jpe' OR filename LIKE '%.jpeg' OR filename LIKE '%.bmp' OR filename LIKE '%.png' OR filename LIKE '%.psd'
	ORDER BY username ASC
	LIMIT 0, 400
mysql error: Column: 'username' in order clause is ambiguous

mysql error number: 1052

Date: Monday 24th of May 2004 08:38:49 AM
Script: http://elsmar.com/Forums/fileslist.p...name&pageamt=4
Referer: http://elsmar.com/Forums/fileslist.p...name&pageamt=4
Username: Marc