The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Advertising Banner System

Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2006, 09:19 AM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default Database Errors

I have just updated my GAB , as I was using an old 1 that didnt allow for Adsense. But now for some reason I am getting a DB error when I try and add a new banner

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
DELETE FROM GAB_listing;

MySQL Error  : Table 'bootleg.GAB_listing' doesn't exist
Error Number : 1146
Date         : Wednesday, July 19th 2006 @ 06:30:24 PM
Script       : http://forums.bootleg.org.uk/xxxxxx/GAB_admin.php
Referrer     : http://forums.bootleg.org.uk/xxxxxx/GAB_admin.php?do=editad
IP Address   : xx.xxx.xxx.xx
Username     : Watson
Classname    : vb_database
Also after I get this error it no longer gives me the option to add new banners, and this appears

Code:
Fatal error: Call to undefined function: fetch_percent() in /home/bootleg/forums/xxxxxx/GAB_admin.php on line 193
Reply With Quote
  #2  
Old 07-19-2006, 10:53 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Youre using old files. Make sure you FTPed to the right place!
Reply With Quote
  #3  
Old 07-19-2006, 12:49 PM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default

Can't get on my site now

Fatal error: Call to undefined function: fetch_ads() in /home/bootleg/forums/global.php(359) : eval()'d code on line 3


Can't even log into admin cp, get the same error

Last edited by Watson; 07-19-2006 at 12:59 PM..
Reply With Quote
  #4  
Old 07-19-2006, 03:31 PM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default

Really need help on this asap, can't get on my forums at all
Reply With Quote
  #5  
Old 07-19-2006, 03:58 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Youre using OLD physical files. Reupload the newest versions
Reply With Quote
  #6  
Old 07-20-2006, 11:34 AM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default

ok done that, and still nothing, same error. I can get to my admin CP, but as soon as I log in, the same happens. I have downloaded the latest version of GAB , and uploaded it.

I am using vb 3.5.3 if that will cause problems?
Reply With Quote
  #7  
Old 07-20-2006, 12:18 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

If youre getting an error like the indefined function AND you are getting the GAB_listing DB error, your geek/ gab /includes files are old ones.

Ive had this happen to me when trying to ftp files up before. They look like they uploaded but due to file permissions or what have you, they didnt upload. Please double check those files again.

HTHs
Reply With Quote
  #8  
Old 07-20-2006, 01:28 PM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default

thats exactly what it was mate. Thanks

Just re-installing it again
Reply With Quote
  #9  
Old 07-20-2006, 01:55 PM
Watson Watson is offline
Junior Member
 
Join Date: Nov 2005
Location: Scotland
Posts: 14
Geek Advertising Banner License Holder 
Default

Ok got it all working, but now my ad sense banners aint showing up at all

Tried to put em in the navbar and the header, but nowt

Here is my debug

PHP Code:
>> START SETTINGS ------- 

$results = array(
      
'usergroups' => array(
      ),
      
'usergroups_view' => array(
         
'0'            =>'4',
         
'1'            =>'6',
         
'2'            =>'13',
         
'3'            =>'15',
         
'4'            =>'17',
         
'5'            =>'7',
         
'6'            =>'16',
         
'7'            =>'2',
         
'8'            =>'20',
         
'9'            =>'5',
         
'10'            =>'1',
         
'11'            =>'3',
      ),
      
'fieldtotoggle'            =>'2',
      
'field_value_yes'            =>'',
      
'max_width'            =>'',
      
'max_height'            =>'',
      
'server_path_to_banners'            =>'/home/bootleg/forums/geek/gab/images',
      
'media_extensions'            =>'',
      
'url_to_banners'            =>'http://forums.bootleg.org.uk/geek/gab/images/',
      
'url_advertising'            =>'',
      
'url_turn_off_ads'            =>'',
      
'redirectpage'            =>'gab_redirect.php',
      
'cyclerate'            =>'4300',
      
'persist_throttle'            =>'',
      
'htmltemplates'            =>'',
      
'defaulthtml'            =>'',
      
'blocks' => array(
         
'1' => array(
            
'title'            =>'Default',
            
'wrapper'            =>'1',
            
'method'            =>'1',
            
'ads' => array(
               
'0' => array(
                  
'adtype'            =>'1',
                  
'number'            =>'1',
                  
'cat_option'            =>'1',
                  
'cats'            =>'',
               ),
            ),
         ),
      ),
      
'scripts' => array(
         
'MASTER' => array(
            
'name'            =>'MASTER',
            
'description'            =>'',
            
'usemaster'            =>'',
            
'blocks' => array(
               
'0'            =>'1',
            ),
         ),
         
'forumdisplay' => array(
            
'name'            =>'forumdisplay',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'showthread' => array(
            
'name'            =>'showthread',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'index' => array(
            
'name'            =>'index',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'editpost' => array(
            
'name'            =>'editpost',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'newthread' => array(
            
'name'            =>'newthread',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'calendar' => array(
            
'name'            =>'calendar',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'online' => array(
            
'name'            =>'online',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'printthread' => array(
            
'name'            =>'printthread',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'profile' => array(
            
'name'            =>'profile',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'search' => array(
            
'name'            =>'search',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'usercp' => array(
            
'name'            =>'usercp',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'adv_index' => array(
            
'name'            =>'adv_index',
            
'description'            =>'',
            
'usemaster'            =>'1',
            
'blocks' => array(
            ),
         ),
         
'THIS_SCRIPT' => array(
            
'usemaster'            =>'',
         ),
      ),
      
'frequency' => array(
         
'0' => array(
            
'description'            =>'Low',
            
'value'            =>'1',
         ),
         
'1' => array(
            
'description'            =>'Medium',
            
'value'            =>'2',
         ),
         
'2' => array(
            
'description'            =>'High',
            
'value'            =>'3',
         ),
         
'3' => array(
            
'description'            =>'Mega High',
            
'value'            =>'4',
         ),
      ),
);>> 
END SETTINGS ------- 

Categories
>> START CATS ------- 

$results = array(
         
'1' => array(
            
'id'            =>'1',
            
'title'            =>'Header Banners',
            
'ordinal'            =>'5',
         ),
         
'2' => array(
            
'id'            =>'2',
            
'title'            =>'Sky Scraper',
            
'ordinal'            =>'20',
         ),
         
'3' => array(
            
'id'            =>'3',
            
'title'            =>'Footer Banners',
            
'ordinal'            =>'10',
         ),
         
'4' => array(
            
'id'            =>'4',
            
'title'            =>'Other',
            
'ordinal'            =>'30',
         ),
         
'5' => array(
            
'id'            =>'5',
            
'title'            =>'Unknown items',
            
'ordinal'            =>'1',
         ),
);>> 
END CATS ------- 
>> 
START ADS ------- 

$results = array(
            
'1' => array(
               
'id'            =>'1',
               
'title'            =>'Google Ad Sense',
               
'startdate'            =>'0',
               
'enddate'            =>'0',
               
'img'            =>'',
               
'hits'            =>'0',
               
'views'            =>'0',
               
'url'            =>'',
               
'userid'            =>'0',
               
'max_views'            =>'0',
               
'max_hits'            =>'0',
               
'isactive'            =>'1',
               
'height'            =>'0',
               
'width'            =>'0',
               
'frequency'            =>'3',
               
'type'            =>'3',
               
'template'            =>'0',
               
'catid'            =>'1',
               
'trackviews'            =>'1',
               
'trackhits'            =>'1',
               
'scriptoption'            =>'1',
               
'forumoption'            =>'1',
               
'scripts'            =>'',
               
'forums'            =>'',
               
'html'            =>'<script type="text/javascript"><!--
google_ad_client = "pub-6856577779223308";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_color_border = "66B5FF";
google_color_bg = "FFFFFF";
google_color_link = "333333";
google_color_text = "000000";
google_color_url = "008000";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>'
,
               
'templatetype'            =>'0',
               
'suspended'            =>'0',
               
'editimage'            =>'0',
               
'editfrequency'            =>'0',
               
'editbanner'            =>'0',
            ),
            
'2' => array(
               
'id'            =>'2',
               
'title'            =>'Bootleg Torrents',
               
'startdate'            =>'0',
               
'enddate'            =>'0',
               
'img'            =>'http://forums.bootleg.org.uk/geek/gab/images/0/2bootleg_link_banner.gif',
               
'hits'            =>'0',
               
'views'            =>'0',
               
'url'            =>'',
               
'userid'            =>'0',
               
'max_views'            =>'0',
               
'max_hits'            =>'0',
               
'isactive'            =>'0',
               
'height'            =>'0',
               
'width'            =>'0',
               
'frequency'            =>'1',
               
'type'            =>'1',
               
'template'            =>'0',
               
'catid'            =>'1',
               
'trackviews'            =>'1',
               
'trackhits'            =>'1',
               
'scriptoption'            =>'1',
               
'forumoption'            =>'1',
               
'scripts'            =>'',
               
'forums'            =>'',
               
'html'            =>'',
               
'templatetype'            =>'0',
               
'suspended'            =>'0',
               
'editimage'            =>'0',
               
'editfrequency'            =>'0',
               
'editbanner'            =>'0',
            ),
);>> 
END ADS ------- 

Templates with $GAB_ads[xin them:
Styleid 6 Title navbar contains $GAB_ads[0]
Styleid 6 Title header contains $GAB_ads[0]
gab  folder check
GAB directory looks valid 
and I can write to it
Reply With Quote
  #10  
Old 07-20-2006, 03:37 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

First, it looks like you have $GAB_ads[0] in your templates, but in your master script, the only billboard that is assigned is to $GAB_ads[1]. Edit your Master Script and set $GAB_ads[0] to the default billboard and $GAB_ads[1] to nothing.

Then it looks like the ad in the default billboard is set to pick and Image banner .

Edit your default billboard and change that to hatml/adsense and you should be good to go
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB 3.8 errors please help Yago Geek Article and Review System 1 02-28-2009 03:33 PM
few errors Hornstar6969 Geek Gazette 5 06-20-2007 05:53 AM
Anyone having empty errors? The Geek Geek Auto-Linker 0 11-30-2006 12:13 PM
I get the following errors Itworx4me Geek Advertising Banner System 9 11-21-2005 10:03 AM
vB Errors after I purchased TheComputerGuy Lizard Lounge 2 09-25-2005 08:31 AM


All times are GMT. The time now is 02:15 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.