Last Update: 16 May 2010 , and on 4.1.10, there are a tons of changes....

Hello,vbulletin members and staff members please help me....i am using Yet Another Awards System...it work fine in vb4.1.5 after upgrading to vb 4.1.10 it did not work fine....all previous seeting work fine...but when i add new award or updat a award it gives error.... so i enabled to add new award....and also do not edit previously award setting..... when i add new award it gives the following error....

Database error in vBulletin 4.1.10:

Invalid SQL:

INSERT INTO award
(award_name, award_desc, award_icon_url, award_img_url, award_cat_id, award_displayorder, award_allowrequest, award_allowrecommend, award_pointvalue, award_active)
VALUES
('Special Proformas 2011',
'',
'http://******.com/images/medals/shairy.gif',
'http://********.com/images/medals/shairy.gif',
'27',
'1',
'0',
'0',
'0',
'1'
);

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 1st 2012 @ 08:28:27 AM
Error Date : Wednesday, February 1st 2012 @ 08:28:29 AM
Script : http://www.******.com/admin/award.php?do=insert
Referrer : http://www.******.com/admin/award.ph...ward_cat_id=-1
IP Address : 1**.1**.2**.5
Username : Administrator
Classname : vB_Database
MySQL Version : 5.1.56

so please tell me how can i do....????

please provide me another award system link....that work reply me soon......thanks

Why does this not work?

All of them have the setting: Enable Automation Task? YES
Also the Awards Systems Setting have: Automation: Enable Automation System set to YES
Members have been members for longer then 30 days.

This Mod is supposed to be supported. Then give me support and not some email address that doesn't include support.

Will this work with the latest version of VB?

I'm pretty sure the automation is not retroactive so if someone has already been a member of your site for X days they will not get the award just because you activate it. The query likely checks if they've been a member exactly X days and then gives an award.

Yes, although it doesn't function the way you want it to.

Thanks for replying. Are you sure about it not being retroactive?
I surely have to check the registration date for a member not how long the award has been active.

Because if it isn't, then this mod stinks even more then their support does.

Pretty sure, because it would make the code and the queries more complex if it was applying awards retroactively. I'm guessing that the automation is run through a cron job which runs every X period of time. If you want it to run retroactively then you're running an extra query for every single user in the database for every single award that is being automatically awarded. The overhead for that would not be something I'd want on my site.

As for complaining about the support, you do realize that whatever support you're getting, and I believe that just means patches and stuff, you aren't paying a cent for, so complaining that you aren't getting enough for free is . . . uncalled for at best.

Well I guess you and I read different things in to the term support. I read it as this: If a product is supported the customers can come with what ever problems they have with the product and get the help they need to fix the problem. It doesn't matter if it is free or not. What matters is that it is supported or not.

This product is supposed to be supported.

If it does mean what you say that it is just patches and such, then an other word then supported should be used. Such as In Active Development or some thing along those lines. Using supported is misleading in that case.

As for the award automation, it does not work, at all. I've tested with a 1 day membership award and it isn't awarded either. If it is some setting I've not done right or not, I have no idea as the documentation on how to use the product is not 100% on how to set it up. Nor have I gotten support here to sort it out.

As for rewarding automated awards retroactively, if it was a button you could click to start a process to check each member's amount of days as a member once, then it wouldn't be a huge amount of queries that runs all the time. Plus those that wouldn't like to use that function could choose not to. But since it's not working at all this is all just wishful thinking.