[chikkoo]

Hello,

I am trying to create a new Award and I got a error message saying "Unknown column 'award_allowrecommend' in field list". This also comes while editing existing awards.

I have disabled the point system in my Forum. If I enable it, I also get an error message saying Unknown column 'award_pointvalue' in 'field list'.

I have recently upgraded my forum to 3.8.4 therefore upgraded the YaAS to 3.8.4.

I went to phpMyadmin and noticed these 2 fields (award_pointvalue & award_allowrecommend) are not there in Award table. How can I manually add these 2 fields. Somebody please guide me.

Database error in vBulletin 3.8.4:

Invalid SQL:

	INSERT INTO vb3_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 
		('xxxxxxxxx',
			'',
			'http://www.xxxxxxxx.com/images/medals/Medal_01.gif',
			'http://www.xxxxxxxx.com/images/medals/medal_star2.gif',
			'10',
			'1',
			'0',
			'0',
			'0',
			'1'
		);

MySQL Error   : Unknown column 'award_allowrecommend' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, March 10th 2010 @ 07:33:41 AM
Error Date    : Wednesday, March 10th 2010 @ 07:33:41 AM
Script        : http://www.xxxxxxxxx.com/admincp/award.php?do=insert
Referrer      : http://www.xxxxxxxx.com/admincp/award.php?do=add
IP Address    : xxx.xxx.xxx.xxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 4.1.22-standard