PDA

View Full Version : Please some one help me?????


M.Iftikhar
02-02-2012, 03:08 AM
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 (http://www.******.com/admin/award.php?do=add&award_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

ForceHSS
02-02-2012, 03:49 AM
you are missing this MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
remove plugin and all files and reinstall see if that fixes it

WebCraker
06-24-2012, 12:51 AM
From phpmyadmin apply this query :

ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL;