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


		
			
Database error in vBulletin 4.2.0:



Invalid SQL:



            SELECT userid, award_id, award_cgroup

            FROM award_user

            WHERE (userid=4) AND (award_id=4) AND (award_cgroup='postcount');



MySQL Error   : Unknown column 'award_cgroup' in 'field list'

Error Number  : 1054

Request Date  : Thursday, February 14th 2013 @ 08:18:52 AM

Error Date    : Thursday, February 14th 2013 @ 08:18:53 AM

Script        : http://www.platboyonline.com/admincp/cronadmin.php?do=runcron&cronid=32

Referrer      : http://www.platboyonline.com/admincp/cronadmin.php?do=modify

IP Address    : -----------

Username      : Marccap

Classname     : vB_Database

MySQL Version : 5.5.28

letsjoy

02-14-2013 10:03 PM

Thanks squidsk for exploit fix :)

richardevans123

02-17-2013 05:38 PM

Is there a way to get the awards to show in the signature area?

Thanks

squidsk

02-17-2013 06:20 PM

Quote:

Originally Posted by richardevans123 (Post 2404800)

Is there a way to get the awards to show in the signature area?

Thanks

Yes in the awards settings where you choose where you want the awards to show, choose one of the signature options.

marccap

02-18-2013 09:18 AM

Quote:

Originally Posted by marccap (Post 2404189)

Here is the full error code when I run the schedule task but I've taken out my IP address

PHP Code:


		
			
Database error in vBulletin 4.2.0:



Invalid SQL:



            SELECT userid, award_id, award_cgroup

            FROM award_user

            WHERE (userid=4) AND (award_id=4) AND (award_cgroup='postcount');



MySQL Error   : Unknown column 'award_cgroup' in 'field list'

Error Number  : 1054

Request Date  : Thursday, February 14th 2013 @ 08:18:52 AM

Error Date    : Thursday, February 14th 2013 @ 08:18:53 AM

Script        : http://www.platboyonline.com/admincp/cronadmin.php?do=runcron&cronid=32

Referrer      : http://www.platboyonline.com/admincp/cronadmin.php?do=modify

IP Address    : -----------

Username      : Marccap

Classname     : vB_Database

MySQL Version : 5.5.28

Any ideas on this yet?

CharlieDelta

02-18-2013 02:01 PM

Is it possible to make the poll votes public?

CharlieDelta

02-18-2013 02:16 PM

I just "granted" an award and it was issued to the sender and not the recipient.

Edit:
I just noticed that there was no pm sent as I was using the "Give award to user" in the acp to fix my above issue.

squidsk

02-18-2013 06:33 PM

Quote:

Originally Posted by CharlieDelta (Post 2404984)

Is it possible to make the poll votes public?

If you mean to show who voted for which option, then no not currently aside from doing it manually.

Quote:

Originally Posted by CharlieDelta (Post 2404989)

I just "granted" an award and it was issued to the sender and not the recipient.

Known issue, it will be fixed in the next release.

Quote:

Edit:
I just noticed that there was no pm sent as I was using the "Give award to user" in the acp to fix my above issue.

I can't reproduce the problem as I get PMs if I issue an award from Award Manager -> Give Award to User in acp.

Quote:

Originally Posted by marccap (Post 2404936)

Any ideas on this yet?

I'd guess it had an error on installation because if it had installed correctly that field would be in the table.

CharlieDelta

02-18-2013 07:33 PM

Thank you squidsk.

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

Page 143 of 190

143

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04359 seconds Memory Usage 1,757KB 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_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: