Marius, maybe now i found an 'issue':
i'm gonna create some awards (silver & bronze for all) right now i created these:
- Activity Award [Gold]Hyperactive Geek
- Activity Award [Silver]Hyperactive Geek
- Activity Award [Bronze]Great Award!
- Posting Award [Gold]Zealousness posting and tagging
- Posting Award [Silver]Zealousness posting and tagging
- Community Award [Gold]Social engaged
- Helpful Award [Gold]Helping Hand
after that when i select 'generate awards' i got this:
Code:
Database error in vBulletin 3.7.0 Release Candidate 2:
Invalid SQL:
SELECT
userid,
AS get_count
FROM nWxperience_stats
ORDER BY get_count DESC
LIMIT 2,1;
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS get_count
FROM nWxperience_stats
ORDER BY get_co
Error Number : 1064
Date : Friday, April 4th 2008 @ 02:44:30 PM
Script : http://www.nowhine.net/board/admincp/xperience_admin.php?do=genawards
Referrer : http://www.nowhine.net/board/admincp/xperience_admin.php?do=manawards
IP Address : xxxxxxxxxxxxxx
Username : KURTZ
Classname : vb_database
MySQL Version : 4.0.27-standard-log
what's up?
NVM: i'm stupid