The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Advertising Banner System (http://www.thevbgeek.com/forumdisplay.php?f=28)
-   -   Database Errors (http://www.thevbgeek.com/showthread.php?t=1780)

Watson 07-19-2006 09:19 AM

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

The Geek 07-19-2006 10:53 AM

Youre using old files. Make sure you FTPed to the right place!

Watson 07-19-2006 12:49 PM

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

Watson 07-19-2006 03:31 PM

Really need help on this asap, can't get on my forums at all

The Geek 07-19-2006 03:58 PM

Youre using OLD physical files. Reupload the newest versions

Watson 07-20-2006 11:34 AM

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?

The Geek 07-20-2006 12:18 PM

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

Watson 07-20-2006 01:28 PM

thats exactly what it was mate. Thanks :)

Just re-installing it again

Watson 07-20-2006 01:55 PM

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


The Geek 07-20-2006 03:37 PM

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 :)


All times are GMT. The time now is 12:45 AM.

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