vb.org Archive

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)

CypherSTL 01-12-2010 05:09 AM

Quote:

Originally Posted by racingsolution (Post 1952385)
Well by deleting the function function construct_depth_mark from awards.php it fixes the problem.

Most likely, now if you have multiple category sections, some of the category names will be doubling up.

robdawg 01-12-2010 01:07 PM

Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

gunboard 01-12-2010 03:12 PM

Hi,

how i can delete the ascii 31 (_) between the award icons in postbit ?

Speysider 01-13-2010 06:46 PM

Quote:

Originally Posted by robdawg (Post 1953510)
Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

I'm having this problem as well.

Xanlamin 01-13-2010 07:02 PM

Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

DarkArmada 01-13-2010 07:23 PM

Stupid question, but what do the points actually do? I'm running vbExperience which manages my point system - is there a plugin available to add the points to vbE?

Xanlamin 01-13-2010 07:47 PM

You can assign a point value to the awards, once the user reaches a certain point structure they will receive the corresponding award.

Cars2007 01-13-2010 11:35 PM

Quote:

Originally Posted by Xanlamin (Post 1953153)
mySQL grouping erros resolved. Download newest zip and reimport the xml.

We are still having the same issue with the latest version of the plugin. Any ideas?

Downloaded YaAS-3.8.3.1.zip from the link above.

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

                                                SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                                                FROM award a, award_user au
                                                WHERE (au.userid = 4981) 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
Error Number  : 1140


CypherSTL 01-14-2010 03:48 AM

From looking at the database error, it would seem that it isn't using the new query.

Have you re-imported the XML?

It should be using this query:
Code:

SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM ' . TABLE_PREFIX . 'award a, ' . TABLE_PREFIX . 'award_user au
WHERE (au.userid = '.$this->profile->userinfo['userid'].') AND (a.award_id=au.award_id) AND (a.award_active = "1")
GROUP BY au.userid


gunboard 01-14-2010 05:27 AM

Quote:

Originally Posted by Xanlamin (Post 1954753)
Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

yes i have tried to reimport the Mod. Does not fix the problem. Sorry for my bad english :D


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01558 seconds
  • Memory Usage 1,739KB
  • 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
  • (4)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