[KGI_Bling]

--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------



Can anyone help me out here?

I'm getting a database error when I try to access the season rankings at:
/vbsoccer.php?do=ranking

Database error in vBulletin 4.2.0:

Invalid SQL:

		SELECT
			b.`userid`, `match_day`,
			COUNT(*) AS `bets`,
			SUM(`score_key`>0) AS 'evaluated',
			SUM(`score_key`>0 AND `score_key` != `bet_score_key`) AS 'wr',
			SUM(`score_key`>0 AND `bet_home`=`points_home` AND `bet_away`=`points_away`) AS 'rr',
			SUM(`score_key`>0 AND (`bet_home`-`bet_away`)=(`points_home`-`points_away`) AND NOT (`bet_home`=`points_home` AND `bet_away`=`points_away`)) AS 'rd'
		FROM `soccer_user_bet` b
		INNER JOIN `soccer_match` m ON (m.`id`=b.`match_id`)
		WHERE m.`league_id`=1 GROUP BY `match_day`, b.`userid`;

MySQL Error   : BIGINT UNSIGNED value is out of range in '(`*********`.`b`.`bet_home` - `*********`.`b`.`bet_away`)'
Error Number  : 1690
Request Date  : Tuesday, November 27th 2012 @ 04:46:57 PM
Error Date    : Tuesday, November 27th 2012 @ 04:46:57 PM
Script        : http://www.*********/vbsoccer.php?do=ranking
Referrer      : http://www.*********/vbsoccer.php?do=live

-------------------------------------------------

Anyone any ideas?

--------------------------- IGNORE THIS _ FIXED IT!!!!!!!!!!!! -------------------------

I fixed it... Thanks