vb.org Archive - Major Additions - Yet Another Awards System

Database error in vBulletin 3.8.6:

Invalid SQL:

UPDATE award
SET award_name = 'Spotlight Published Award',
award_desc = 'This medal is awarded to Members who have had their poetic works published on JPiC Spotlighted Artist Showcase.',
award_icon_url = 'images/medals/published-icon.gif',
award_img_url = 'images/medals/published.gif',
award_cat_id = '1',
award_displayorder = '2',
award_allowrequest = '1',
award_allowrecommend = '1',
award_active = '1',
award_pointvalue = '0'
WHERE award_id = 9;

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054

MySQL Version : 5.0.91-community

This happens when trying to update settings via AdminCP. Is there a fix for this? Is there perhaps a query I can run to create the table/column so that the error no longer occurs?

Thanks,

Jacquii.

btw - I've upgraded from a previous version YAAS.

masterross

12-06-2010 10:31 AM

Probably you dont have award_pointvalue too, so just run this in phpmyadmin:

Code:

ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

mgurain

12-06-2010 05:12 PM

Is this hack an upgrade of 3.8.4 one here ?
I were using that one, and I need to upgrade for vb 4.x now.

Thanks,,

masterross

12-06-2010 06:13 PM

Cant you read?

Quote:

vBulletin 4 version can be found here: https://vborg.vbsupport.ru/showt...highlight=YAAS

nacaruncr

12-07-2010 05:07 AM

excuse me for my english... i learning :P
is it possible when you recive one award that you have this new award don't show in the postbit_legacy only in your profile???

in others words, if you have the award "winer" and you win again, this award don't show in the postbit_legacy but when you go at the user cpanel, there are those....... is it possible??

;)

MarceloS

12-16-2010 05:01 PM

Is there any way to display the award icons elsewhere in the postbit aside from the default locations that you can choose from ACP?

I know that the vb3 version of this plugin had it, and I don't know how to do it on the new version.

Please can someone help me on this?

icekola

12-19-2010 08:05 PM

I am running vb 4.1.0 PL2.

I am getting header/footer issue with themes other then the default.

I tried adding the following code at the bottom of each below template as directed on https://vborg.vbsupport.ru/showthread.php?t=255356

Code:

{vb:cssfile additional.css}

Custom templates
AWARDS - Code worked so were good here.
awards_request_form - Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 3391
awards_showcase - Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 3391
awards_viewaward - Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 3391

Is there a fix for this? Your help is appreciated. Thx.

sadiq6210

12-20-2010 03:55 AM

CypherSTL :)

Is there any update for 4.1 ? :)

Mobo	12-21-2010 11:51 AM

Yep, wanting 4.1.0 PL2 version for my site as well!!

All times are GMT. The time now is 07:35 PM.

Page 63 of 190

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02419 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: