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-12-2006, 07:03 AM
Brent's Avatar
Brent Brent is offline
Member
 
Join Date: Oct 2005
Posts: 95
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default GAB and 3.6

I get this error when I click on the Settings in ADMINCP

Quote:
Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

SELECT profilefieldid, title
FROM profilefield;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Wednesday, July 12th 2006 @ 03:00:41 AM
Script : http://www.mustangevolution.com/foru...hp?do=settings
Referrer : http://www.mustangevolution.com/foru...dex.php?do=nav
IP Address : 24.214.88.63
Username : Brent
Classname : vb_database
Reply With Quote
  #2  
Old 07-12-2006, 08: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

Thanks. I know what the problem is. Ill release an update this weekend for 3.6
Reply With Quote
  #3  
Old 07-20-2006, 04:28 AM
Brent's Avatar
Brent Brent is offline
Member
 
Join Date: Oct 2005
Posts: 95
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Did this release happen?
Reply With Quote
  #4  
Old 07-20-2006, 07:16 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

No, not yet. Im looking at early next week
Reply With Quote
  #5  
Old 07-20-2006, 07:25 AM
Brent's Avatar
Brent Brent is offline
Member
 
Join Date: Oct 2005
Posts: 95
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Alright.

Can you please tell me where in the database this is stored:

Server path to banners folder e.g. /home/evo/public_html/forum/geek/ gab /images

I changed servers and my server path changed but I can not update it because I get that database error on the setting page. None of my banners show up right now.
Reply With Quote
  #6  
Old 07-20-2006, 08:52 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

Its stroed in the datastore, however trying to edit that row could cause problems as its a serialized array. Ill see if I can come up with a solution for you tonight.
Reply With Quote
  #7  
Old 08-12-2006, 07:13 PM
atcNick atcNick is offline
Junior Member
 
Join Date: Jul 2006
Posts: 17
Geek Advertising Banner License Holder 
Default

Anything new with this issue? Im receiving the same database error and Im also unable to display banners on my forum.

Thanks.

Nick
Reply With Quote
  #8  
Old 08-13-2006, 07:56 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

rc3b is for vb3.6
Reply With Quote
  #9  
Old 08-13-2006, 09:43 PM
atcNick atcNick is offline
Junior Member
 
Join Date: Jul 2006
Posts: 17
Geek Advertising Banner License Holder 
Default

Hi Geek,

I installed rc3b and no longer getting the database error. But Im still not able to display ads. Everything looks like its set up right.

The only things I wasnt able to do on setup was set up the cron job. I try to do it and I keep getting "invaled filename specified". Not sure if this is my problem or not.

I followed your trouble shooting instructions thats included in the readme file. I wasnt able to find "Blocks" in my admincp so I didnt do that. And I wasnt able to do this step because I have no iea how to do this:

"Make sure that have $GAB_ads[x] somewhere in your templates (i.e. your navbar) "

Here is the debug info:

>> START SETTINGS -------

$results = array(
'usergroups' => array(
),
'usergroups_view' => array(
'0' =>'4',
'1' =>'6',
'2' =>'8',
'3' =>'24',
'4' =>'7',
'5' =>'2',
'6' =>'5',
'7' =>'1',
'8' =>'3',
),
'fieldtotoggle' =>'1',
'field_value_yes' =>'',
'max_width' =>'',
'max_height' =>'',
'server_path_to_banners' =>'/home/copagsco/public_html/easttexaspoker/forum/geek/ gab /images',
'media_extensions' =>'',
'url_to_banners' =>'http://www.easttexaspoker.net/forum/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' =>'1',
),
),
'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' =>'BetHoldem.com banner ',
'startdate' =>'1155362400',
'enddate' =>'1167548400',
'img' =>'http://content.sininter.com/bannerad/betwwts/468x60.gif',
'hits' =>'0',
'views' =>'0',
'url' =>'https://secure.sininter.com/redir/redir.aspx?action=campaign&campaignID=26205& Banner ID=155&SiteID=1492',
'userid' =>'2147483647',
'max_views' =>'2147483647',
'max_hits' =>'2147483647',
'isactive' =>'1',
'height' =>'60',
'width' =>'468',
'frequency' =>'3',
'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[x] in them:
gab folder check
GAB directory looks valid and I can write to it!


Any suggestions would be appreciated.

Thanks, nick
Reply With Quote
  #10  
Old 08-13-2006, 11:25 PM
benj benj is offline
Senior Member
 
Join Date: Sep 2005
Posts: 166
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Quote:
>> START SETTINGS -------

$results = array(
'usergroups' => array(
),
'usergroups_view' => array(
'0' =>'4',
'1' =>'6',
'2' =>'8',
'3' =>'7',
'4' =>'2',
'5' =>'5',
'6' =>'1',
'7' =>'3',
),
'fieldtotoggle' =>'1',
'field_value_yes' =>'',
'max_width' =>'',
'max_height' =>'',
'server_path_to_banners' =>'/home/plugged/public_html/upload/geek/ gab /images',
'media_extensions' =>'',
'url_to_banners' =>'http://www.plugged.co.uk/upload/geek/ gab /images/',
'url_advertising' =>'advertising.php',
'url_turn_off_ads' =>'turnoff.php',
'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' =>'0',
'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(
'name' =>'',
'description' =>'',
'usemaster' =>'1',
'blocks' => array(
'0' =>'1',
),
),
),
'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' =>' test ',
'startdate' =>'0',
'enddate' =>'0',
'img' =>'http://www.plugged.co.uk/upload/geek/ gab /images/0/adimage.gif',
'hits' =>'0',
'views' =>'0',
'url' =>'http://www.plugged.co.uk',
'userid' =>'0',
'max_views' =>'0',
'max_hits' =>'0',
'isactive' =>'1',
'height' =>'0',
'width' =>'0',
'frequency' =>'3',
'type' =>'1',
'template' =>'0',
'catid' =>'4',
'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[x] in them:
Styleid 11 Title footer contains $GAB_ads[1]
gab folder check
GAB directory looks valid and I can write to it!
mine isnt working, im new to this script tho any ideas?
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
GAB and GAB Stats for vB4 have been released Morgan Announcements 0 05-19-2010 01:58 AM
GAB 2.x >>> GAB beta versions Tigratrus Geek Advertising Banner System 3 04-01-2008 05:59 AM
TRying to download GAB, but it is downloading it as GAB read on LincolnForums Geek Advertising Banner System 5 06-07-2006 06:29 PM


All times are GMT. The time now is 03:21 PM.


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