Installed the card hack

[randyc]

I installed Lesanes Card Hack (thankyou lesane, its excellent)

but whenever a moderator tries to use the "Give User A Award" and submit a new award to a user they get this:
+++++++++++++++++++++++++++++++++++++++
Database error in vBulletin Mod Control Panel 2.3.2:

Invalid SQL: INSERT into useraward (awardsid,userid,name,url,aw,who,reason) VALUES ('1','22','Red Card','http://www.~~~~~.net/forums/images/cards/red.gif','0','RandyC','')
mysql error: Unknown column 'who' in 'field list'

mysql error number: 1054

Date: Monday 20th of October 2003 02:11:16 PM
Script: bigarse link to the script
+++++++++++++++++++++++++++++++++++++++

in the little Javascript Popup Window.

[Lesane]

You'll need to install this addon to make it work:
https://vborg.vbsupport.ru/showpost.php?s=&postid=223642

[randyc]

ALTER TABLE useraward ADD who VARCHAR(100) NOT NULL
ALTER TABLE useraward ADD reason VARCHAR(100) NOT NULL
after running that...

sql sez:
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 'ALTER TABLE useraward ADD reason VARCHAR( 100 ) NOT NULL' a

[randyc]

Close this, thanks for the help lesane. it turned out to be either my fault or phpmyadmins fault...
i had to run each query individually...
go figure.