Bug SQL error

[Jem]

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT commandlog.*, commandlog.username AS cmdusername, user.username

FROM dbtech_vbshout_log AS commandlog
LEFT JOIN user AS user ON (user.userid = commandlog.userid)
When viewing the command log, if I click on the username header to sort by name, I get the following databsse error:



ORDER BY username ASC, dateline DESC
LIMIT 0, 15;

MySQL Error : Column 'username' in order clause is ambiguous
Error Number : 1052
Request Date : Wednesday, August 31st 2011 @ 12:17:18 AM
Error Date : Wednesday, August 31st 2011 @ 12:17:18 AM
Script : http://forum.sadaar.com/admincp/vbs...view&modaction=&u=0&pp=15&orderby=user&page=1
Referrer : http://forum.sadaar.com/admincp/vbshout.php?do=commandlog
IP Address : xx.xx.xx.xx
Username : Sadxxx
Classname : vB_Database
MySQL Version : 5.5.14

Please advise

 

[Fillip H.]

I believe that should fix it, re-download and re-upload the files and it should be fixed

 

[Jem]

Re-upload and import worked. Thank you for your assistance