[Hawkbizkit]

Originally Posted by loneranger

 Database error in vBulletin 3.5.0 Release Candidate 3: 

Invalid SQL: 
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota  lrating,totalvotes  
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types  
                                        ON affiliates.type = affiliates_types.id  
                                        WHERE active='1' AND approved='1'  
                                        ORDER BY sitename DESC  
                                        LIMIT 0,20; 

MySQL Error  : Unknown table 'affiliates' in on clause

i am getting this error too is there a solution yet as i need this

very simple fix on line 309 in the affiliate.php change this

PHP Code:

                                        ON affiliates.type = affiliates_types.id 


with this

PHP Code:

                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id