[glen290]

I am getting an error when I click on season or total rankings.
All was ok but had server issues over the week end and since then im getting the following errors.

Database error in vBulletin 4.2.2:

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 CAST(`bet_home`-`bet_away` AS SIGNED)=(`points_home`-`points_away`) AND NOT (`bet_home`=`points_home` AND `bet_away`=`points_away`)) AS 'rd'
FROM `tenpinfo_soccer_user_bet` b
INNER JOIN `tenpinfo_soccer_match` m ON (m.`id`=b.`match_id`)
WHERE m.`league_id`=9 GROUP BY `match_day`, b.`userid`;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`tenpinfo_forum`.`b`.`bet_home` - `tenpinfo_forum`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Tuesday, April 29th 2014 @ 09:50:35 AM
Error Date : Tuesday, April 29th 2014 @ 09:50:36 AM
Script : http://www.bowluk.com/vbsoccer.php?do=ranking
Referrer : http://www.bowluk.com/vbsoccer.php
IP Address : 95.172.68.155
Username : Glen
Classname : vB_Database
MySQL Version : 5.5.31-MariaDB-cll-lve


Can anybody help before I do a restore ?