i just an odd error...

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE 1=1
AND post.postid IN (0,1331380,1331426,1331429,1331508,1331510,1331542 ,1331851,1334085,1334399,1334432,1334436,1334446,1 334460,1334503,1334505,1334614,1334806,1335043,133 8530,1338533,1338581,1338616,1338693,1342940,13429 68,1344396)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Unknown column 'a.award_id' in 'on clause'
Error Number : 1054
Date : Monday, June 4th 2007 @ 09:42:07 AM
Script : http://www.conceptart.org/forums/showthread.php?t=98016
Referrer : http://www.conceptart.org/forums/forumdisplay.php?f=2
IP Address : 66.72.161.124
Username : davi
Classname : vb_database

I installed and it all seemed to go well, however when I give someone a medal I get the following error;

It gives the award anyway, and appears in memberlist/posbit but when I try to view a member's profile it returns a white screen. I saw someone else mis edited the MEMBERINFO template, so I double checked mine and it was correct. I even reverted it to it's original state and tried clicking the profile anyway (assuming I'd see the user profile but no award stuff), but that still gave a white screen. When I remove the user's medal I can see their profile again. This is on 3.6.7. Help?

This may seem like a dumb question, but...

How do I get to the Awards List page? I can't seem to find it anywhere.

Thanks!

EDIT: Found it. It's amazing what looking well for something will do.

Well, it's been over 24 hours so I guess it's ok to bump...

Thanx very much MTHA for this modification.
Planning on making it a Major Feature on JPiC
**INSTALLED**

Jacquii.

Several things that could possible make a good add-on to this amazing mod.

Could you please make it possible for members to know about the different awards that are available in an area that they can readily access it should they desire to do so.

Can this area also have a recommend an award to someone area so that if someone wants to make a recommendation, they can.

Can we have a "Hall of Honor" to display those people who have won awards.

Can we also have something saying that we are prepared to make up a new award should there be a need recommended through PM to admins.

Let me know what you think!

Got it working, great mod, was looking for this one! Thank you very much!

works fully functional on 3.6.5 please guys follow all the steps, upload files. upload product. DO the styles edit first. then start messing with the awards. test it out before u start editing the settings. great great mod.

Witch database prefix do this mod upload
I want to delete it from my database

is this the thing or is it more?
vb3_award
vb3_award_cat
vb3_award_user

Any idea where to get the really small award icons? Ive searched high and low and can only find the large ones.