[kailew]

Hi,

I'm getting a SQL Error:

----------------------
Datenbankfehler in vBulletin 3.8.6:

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 `pfosoccer_user_bet` b
INNER JOIN `pfosoccer_match` m ON (m.`id`=b.`match_id`)
WHERE m.`league_id`=12 GROUP BY `match_day`, b.`userid`;

MySQL-Fehler : BIGINT UNSIGNED value is out of range in '(`dbxxxxx_xx`.`b`.`bet_home` - `dbxxxxx_xx`.`b`.`bet_away`)'
Fehler-Nr. : 1690
Fehler-Zeit : Friday, 01.02.2013 @ 10:00:57
Datum : Friday, 01.02.2013 @ 10:00:57
Skript : http://www.myforum.org/vbsoccer.php?do=ranking
Referrer : http://www.myforum.org/vbsoccer.php?do=live
IP-Adresse : 91.xx.xxx.xx
Benutzername : xxx
Klassenname : vB_Database
MySQL-Version : 5.5.28-log
-----------------------------------

Any ideas?

Kai