[bi11i]

Originally Posted by Impreza04

Everything is working on my test board apart from when trying to view affiliate.php

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error  : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date         : Monday, September 26th 2005 @ 04:22:45 PM 


EDIT: Actually I see the problem myself and its fixed..

PHP Code:

//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings"); 


Has a space..
Replace with

PHP Code:

//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings"); 


Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is

and

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,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
Error Number : 1109
Date         : Monday, September 26th 2005 @ 09:05:35 AM
Script       : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates 


thanks, that fixed my SQL error, also.

Are the General Settings optimally configured by default?