Major Additions - Yet Another Awards System

*** CREATE A BACKUP OF YOUR FORUM AND DATABASE BEFORE INSTALLING ***

DESCRIPTION:
This is a Medals/Awards system. Admin can give members awards, and award icons will be displayed in member's profile, posts, as well as in a award list.

FEATURES:
In AdminCP
- Can Create/Edit/Delete/Reorder categories/sub-categories in ACP (with category name and description)
- Can Create/Edit/Delete awards in ACP (with Award Name, Description, Icon URL, Image URL)
- Can Move one (or all) award(s) from one category to another
- Can set some awards un-classified (not displayed for public)
- Can re-order awards in awards showcase
- Issue awards to members, based on username or userid, with Issue Reason
- Remove awards from members
+ Writes granting/removing awards to the log

In ModCP
- Issue awards to members, based on username or userid, with Issue Reason
- Remove awards from members
+ Writes granting/removing award to the log

Front page
- Display awards list in with: Award Name, Description, Icon, Image, and Members who get each award.
- Display awards showcase in profile, with Award information, Issue time and reason
- Display award icons in postbit (showthread, showpost, announcement, private)

New Features/Additions since 3.8
- Points System
- Separate Award Request/Recommendation Forms
- CSS Customizable

Current Release Version 4.0.9

• Added - Handling of user merges
• Added - Handling of user deletes
• Added - Manage awards on per user basis
• Added - Extra info to the logs for mass removal and editing of issued awards
• Added - Ability to collapse categories on awards.php
• Added - Checksum file for checking for suspect file versions
• Added - Various missing phrases
• Fixed - Memberlist not showing awards when option is active
• Fixed - Navtab not being selected (vb version < 4.2)
• Fixed - Category title not being displayed on awards.php
• Fixed - Logging not working in modcp
• Fixed - A few other minor bugs

[absy]

Is this on a brand new fresh install, or upgrade?

Its a fresh install, on a test version of my forum, the error is the same on the default skin and my custom skin

Googled the error, dont know if this helps:

#

If the ONLY_FULL_GROUP_BY SQL mode is enabled, an error occurs:

mysql> SET sql_mode = 'ONLY_FULL_GROUP_BY';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT owner, COUNT(*) FROM pet;
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT()...)
with no GROUP columns is illegal if there is no GROUP BY clause

#

If ONLY_FULL_GROUP_BY is not enabled, the query is processed by treating all rows as a single group, but the value selected for each named column is indeterminate. The server is free to select the value from any row:

[CypherSTL]

Bart, I did notice another error on your site, particularly with the Profile Tab. I left out a conditional statement in the output code for that.

For those who downloaded the BETA2 Zip file before this post, please re-download and import the XML.

[CypherSTL]

Originally Posted by absy

Its a fresh install, on a test version of my forum, the error is the same on the default skin and my custom skin

Googled the error, dont know if this helps:

Trying to see if I can duplicate it.

--
There is a SUM statement, which adds up the total amount of points. That could be where it is erroring out on. Did you make that setting custom on your database, or what?

[absy]

not that I know, i disabled the points system and it works fine, so I am not worrired since I do not want to use the points, but it may be others might, thank you so much for working on this, itsa great part of our forum

[CypherSTL]

@absy: I've tried it so far with fresh installed on VB 4.0PL1 using the normal mysql extension, and the mysqli extension. I myself cannot duplicate this. Anyone else running into this?

[absy]

As I said, I am quite happy not to have a points system, if you would like to go on my test site and re enable the points and investigate there please do. If its just a quirk with my sql i wouldnt worry its an awesome mod

pm me if you want to go on my forum

[CypherSTL]

I sent you a PM absy with a link to an XML. See if it's fixed in that if you don't mind.

[CypherSTL]

Is anyone else having this problem with the points system being enabled and getting the SQL Error? I have a possible fix that I'm wanting to test before I update the actual .zip package.

I'm unable to duplicate the error on my test machines.

[DigitalDark]

I use beta 2 and I've found a little bug in the private messages. I've seen the changes... very good work in beta 2

Image of the bug:
With moderators and admins ocurrs but with standard users not..


Image disabling the mod:



Another thing is the medal description in profile...



I think that there is a issue with the css nothing more... Thanks for your help!

PD: I don't have this sql error. I use ucash and I think that everithing is right despite of this details.

[CypherSTL]

Digital. I did catch the Profile Tab bug and a few template's wern't caching. Those have been fixed in the current Beta2 Zip file. Try to redownload it and reimport the XML from that and see what it does.

Also, what postbit location are you using?