Why it is not updating the results ?

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

can you please add a greek superleague league? :(

Find in vbsoccer.php two times:

CAST(`bet_home`-`bet_away` AS SIGNED)

and replace it with

CAST(`bet_home` AS SIGNED) - CAST(`bet_away` AS SIGNED)

Is there no more update for the current 2015 / 2016 season?

Is this still working?

It was for me until last week, getting an access denied message when trying to get scores updated and in the diagnostics but cant see any other error message to give me a hint why

wird die Europa-Liga nicht mehr angeboten ? Bis dato kann man sie leider nicht einpflegen.
Danke für einen Hinweis.

hello butzel, the server seems to be offline...

http://www.vbulletin-germany.org/sho...4748#post84748

or take a look at the vb4 thread for this mod.

Danke f?r die Info.
Das waere sehr schade um das Soccer-Game :(