vb.org Archive - Add-On Releases - Yet Another Awards System

Page 43 of 69

« First

Last »

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

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=196244)

racingsolution

01-11-2010 03:21 AM

Cool :) Thanks for supporting your mod.. My members really enjoy it

xorex

01-11-2010 09:03 AM

Thanks

Charles_1

01-11-2010 09:08 AM

I am using YAAS for long time already and becouse I have vBulletin v3.8.3 and the idea of points for awards is great, I just installed YAAS v3.8.3 (downloaded 30 minutes ago). But now I have these database errors caused by users with some awards from earlier:

Code:

Database error in vBulletin 3.8.3:



Invalid SQL:



                                                SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints

                                                FROM award a, award_user au

                                                WHERE (au.userid = 46060) AND (a.award_id=au.award_id);



MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

CypherSTL

01-11-2010 01:10 PM

Quote:

Originally Posted by Charles_1 (Post 1952576)

Code:

Database error in vBulletin 3.8.3:



Invalid SQL:



                        SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints

                        FROM award a, award_user au

                        WHERE (au.userid = 46060) AND (a.award_id=au.award_id);



MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

Running into this problem on the 4.0 release as well. All I can recommend until I can get a fix, is to Disable the point system.

CypherSTL

01-11-2010 01:24 PM

Just curious Charles, what version of MySQL are you running?

Charles_1

01-11-2010 02:58 PM

Quote:

Originally Posted by CypherSTL (Post 1952729)

Just curious Charles, what version of MySQL are you running?

MySQL Version 4.1.20

NachoTPAO

01-11-2010 04:05 PM

Awesome mod, could you make it possible that some awards are automatically given upon meeting some value such as having registered 2 years ago or having 1000 posts or being promoted to moderator and so? It would be very useful for medium-big forums like mine (15.000 members,800k Posts) so that the mod team doesnt have to give them manually. Bye!

racingsolution

01-11-2010 04:11 PM

Quote:

Originally Posted by NachoTPAO (Post 1952860)

Hm I like this.. it could be incorporated into a cron job to update members daily

gunboard

01-11-2010 04:30 PM

Hi,

sinse i have updated i have "_" between the award icons in postbit. else there is a blank line in
the admincp > setup menu.

Xanlamin

01-11-2010 11:51 PM

mySQL grouping erros resolved. Download newest zip and reimport the xml.

All times are GMT. The time now is 05:08 PM.

Page 43 of 69

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01463 seconds Memory Usage 1,740KB 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 (2)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: