[ThePartyBorg]

Saw somebody posting this same question a page ago, but I'm also having this problem, and the answer there was to just create the table, nonsense ofcourse. Anyway, the problem:

Invalid SQL: SELECT displayads FROM usergroup WHERE usergroupid='2'
mysql error: Table 'jnfn.usergroup' doesn't exist

mysql error number: 1146

So there is still a prefix missing in the code. So in functions_bannerads.php change line 34 to:

PHP Code:

$GetUsergroup = $DB_site->query_first("SELECT displayads FROM ".TABLE_PREFIX."usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'"); 


Solved the errors for me.

Edit:

Noticed another one missing in the code which has to be added to profile.php

Find the following in profile.php

PHP Code:

$getBanners = $DB_site->query("SELECT * FROM dhc_ads WHERE userid='$bbuserinfo[userid]'"); 


And replace this with:

PHP Code:

$getBanners = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."dhc_ads WHERE userid='$bbuserinfo[userid]'");