OK I saw where someone else had this problem but after reading through 34 pages didn't see where it was "talked" about.

That is because you have MySQL 4.1 installed. "Order by" with "Group by" is a no-go. I'm already working on a version that is compatible to that very old MySQL.

Can my HOST change that? ugh!!

That is a question that can only be answered by your host :)

Yeah LOL THANKS!! Working on that now!! :)

Database error with 4.0.5 and here are the details m'friend

Database error in vBulletin 4.0.5:

Invalid SQL:
UPDATE vb_xperience_stats
SET
points_xperience=504,points_threads=62,points_thre ad_votes=0,points_thread_replycount=18.9,points_th read_views=18.78,points_thread_stickies=0,points_p osts=192,points_post_avg=3.0006967763782,points_po st_attachment=0,points_misc_events=0,points_thread s_sg=0,points_posts_sg=0,points_post_attachment_vi ews=0,points_user_profile=40,points_post_den=24,po ints_user_law=0,points_user_infractions=0,points_u ser_reputation=14,points_user_reputation_use=8,poi nts_user_online=63.985138888889,points_user_referr als=0,points_misc_custom=0,points_user_socialgroup =0,points_thread_tags=0,points_thread_rate=1,point s_user_friends=9,points_user_visitormessages=0,poi nts_user_albumpictures=0,points_misc_ldm=0,points_ misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms= 0,points_misc_ppd=0,points_misc=3.75,points_thread =100.68,points_post=265,points_user=134.9851388888 9,points_xperience=504,points_shop=0,points_misc_v 3arcadechamps=1.25,points_misc_v3sub=2.5,points_us er_activity=100,points_user_activity30=100,points_ user_activity7=100,points_level=10,promoted=0,
dateline=1279162860
WHERE userid=3;

MySQL Error : Unknown column 'points_misc_v3sub' in 'field list'
Error Number : 1054
Request Date : Wednesday, July 14th 2010 @ 11:01:15 PM
Error Date : Wednesday, July 14th 2010 @ 11:01:15 PM
Script : http://www.electricscotland.org/cron...and=1279162866
Referrer : http://www.electricscotland.org/foru...p/26-Genealogy
IP Address : 67.142.161.36
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

how to make like this? this is when i didnt klik the username

http://www.indoimage.com/pictures/94...cce57f3e04.jpg

and this is when i click his username

http://www.indoimage.com/pictures/c3...dacd469f25.jpg

I installed this mod on July 10th, and all Awards were given out at that time. Even though the scheduled task for Experience Awards is set to run at 2:30am every day, the Awards have not changed at all.

I just clicked on "Run Now" for Experience Awards task, and nothing changed.

If this was working, and just the same people are getting the same awards, I would expect the date & time to reflect each day... instead, it still says July 10th.

Why aren't the Awards working?

This not an error related to vBulletin 4.0.5. It seems you installed an old version or didn't upgraded the v3Arcade Plugin. Please uninstall the vBExperience v3Arcade Plugin and install the version that is delivered with the GOLD version again.

Please click "Mark as Installed".
This is relevant to vBExperience 3.8, not vBExperience 4.0 - vBulletin 4.0 hasn't such a menue anymore.


What exactly is not working? The awards are assigned to users beeing the best/first. This must not change everyday, if the users don't loste/gather new points that would change the ranking.

I'm running version vBulletin 4.0.2 and it seems the achievements are bugged somehow. I cleared all of the logs/achievements from the users because some users had achievements they shouldn't. Like the one i have right now is 10 Friends which is set to Friends field is > 9 you get the achievement. But, people with 3 friends had it. Now that i cleared everything, i clicked recount/update achievements and it doesn't do anything.... no one has the achievement but i know for a fact many have more then 10 friends including me... any idea whats up with it? Awards seem to be working fine from what I can tell and no other issues at this moment.