[bi11i]

Database error in vBulletin 3.5.0 Release Candidate 3:

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

MySQL Error : Unknown table 'opio_affiliates' in on clause
Error Number : 1109
Date : Wednesday, September 28th 2005 @ 11:45:15 AM
Script : http://forum.opiophile.org/affiliate...listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi

I'm still getting this error no matter which hack to the mod I try. Any definitive solution?