[xtreme-mobile]

when i click view current affiliates it shows following error:


Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM vb3_8affiliates AS affiliates_types
LEFT JOIN vb3_8affiliates_types AS affiliates_type
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown table 'affiliates' in on clause
Error Number : 1109
Date : Friday, September 30th 2005 @ 03:58:53 PM
Script : http://www.talk-365.com/forum/affili...listaffiliates
Referrer : http://www.talk-365.com/forum/affiliate.php
IP Address : xx.xxxx.xxx.xxx
Username : Dean
Classname : vb_database

any ideas?