We are getting this error when suggesting an award. I see it address some pages back. Was it take care of in a newer version?

There's some error when sending your award request. Please contact site's administrator for assistant.

I also have other problems. In the admin panel when I grant an award it still shows it needing to be granted or denied. I click it again and the same thing happens. Then if you look at the award you will see it has been granted to the same person for each time I tried it.

If the date isn't more recent than the last update (May 2010) then no and given this hasn't been updated in a year and a half I'd say unlikely.

can i have a 3rd party modify this mod to suit what i need it to do?

if it still seen in your awards request. (like mine was) i would just change the phrase so that it says your request has been submitted. i did that to mine. a member would request an award and give that error but my awards commander would still have it in the awards request box.

NVM my question was answered before i posted it. Just learned about the Re-Useable Code check mark...

This problem is caused by en error in the upgrade script when upgrading from YAAS 3.8.4, which has already added the column. In order to fix it you need to open the xml file find the part of the code that upgrades for version 3.8.3 (approximately line 160) and delete that section.

Is there a way to set requested awards to auto approve?

so i did that and now i get

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TABLE award_requests (
award_req_id int(8) unsigned NOT NULL auto_increment,
award_req_timestamp timestamp NOT NULL default CURRENT_TIMESTAMP,
award_req_uid int(8) NULL,
award_rec_uid int(8) NULL,
award_req_aid int(8) NULL,
award_req_reason varchar(512) NOT NULL,
PRIMARY KEY (award_req_id)
);

MySQL Error : Table 'award_requests' already exists
Error Number : 1050
Request Date : Friday, November 18th 2011 @ 09:58:53 AM
Error Date : Friday, November 18th 2011 @ 09:58:54 AM
Script : http://www.**********.com/admincp/pl...=productimport
Referrer : http://www.***************.com/admin...?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community-log

Given the table already exists in 3.8.4 with the exact same settings you can remove that part of the script as well. Its the part listed in the upgrade for version 4.0.1.2, located at about line 176.

could you give me the scipt i dont want to delete the wrong one