The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Advertising Banner System (http://www.thevbgeek.com/forumdisplay.php?f=28)
-   -   GAB and 3.6 (http://www.thevbgeek.com/showthread.php?t=1730)

Brent 07-12-2006 07:03 AM

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

The Geek 07-12-2006 08:37 PM

Thanks. I know what the problem is. Ill release an update this weekend for 3.6

Brent 07-20-2006 04:28 AM

Did this release happen?

The Geek 07-20-2006 07:16 AM

No, not yet. Im looking at early next week :)

Brent 07-20-2006 07:25 AM

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.

The Geek 07-20-2006 08:52 AM

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.

atcNick 08-12-2006 07:13 PM

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

Thanks.

Nick

The Geek 08-13-2006 07:56 AM

rc3b is for vb3.6

atcNick 08-13-2006 09:43 PM

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

benj 08-13-2006 11:25 PM

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?


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

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