The Arcive of vBulletin Modifications Site. |
|
Installed the card hack Details »»
|
|||||||||||||||||||||||||
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. Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
You'll need to install this addon to make it work:
https://vborg.vbsupport.ru/showpost....&postid=223642 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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. |
![]() |
|
|