[Shepski]

installed and working fine but one problem is you try and goto the traderratings.php file directly, it comes up with a mysql error rather than display the stats page:

Database error in vBulletin 3.0.8:

Invalid SQL: SELECT user_rate_trade.userid, rateduser, userrating, userbuysell, a.username, a.ratetradetotal, b.username AS ratedusername, b.ratetradetotal AS ratedtradetotal FROM user_rate_trade LEFT JOIN user AS a ON a.userid = user_rate_trade.userid LEFT JOIN user AS b ON b.userid = user_rate_trade.rateduser ORDER BY userdate DESC LIMIT 15
mysql error: Column: 'userrating' in field list is ambiguous

mysql error number: 1052

Date: Friday 12th of August 2005 10:39:36 AM
Script: http://forums.dvd-swaps.com/traderratings.php

Any ideas on this one?