
01-11-2010, 01:10 PM
|
|
|
Join Date: Mar 2006
Location: St. Charles, MO
Posts: 306
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Charles_1
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?
|
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.
|