[Patrickftw]

Is there a fix for this? I'm not sure why I'm getting it, I'd really like to use this.

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT dsl.*,dsl.mc_gross-awc.mc_fee AS amount,user.userid,user.username,user.avatarid,user.avatarrevision,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline FROM lpawcl_payments AS dsl LEFT JOIN lpuser AS user ON(dsl.userid=user.userid) LEFT JOIN lpavatar AS avatar ON(avatar.avatarid=user.avatarid) LEFT JOIN lpcustomavatar AS customavatar ON(customavatar.userid=user.userid) WHERE payment_status='Completed' AND item_number=1 AND date_format(from_unixtime(payment_date),'%m%y')='0409' ORDER BY payment_date DESC LIMIT 0,10;

MySQL Error   : Unknown table 'awc' in field list
Error Number  : 1109
Request Date  : Friday, April 17th 2009 @ 01:02:26 PM
Error Date    : Friday, April 17th 2009 @ 01:02:26 PM
Script        : http://mysite.com/awcl_dsl.php?do=list
Referrer      : 
Classname     : vB_Database
MySQL Version : 4.1.20