Football Betting Game 1.4.25RC1 Version
Vbulletin vBulletin 4.1.12 Patch Level 2
vBSEO 3.6.0 PL2
I've uninstalled and reinstalled the product some time ago, continues to give me problems mysql:
Code:
Database error in vBulletin 4.1.12:
Invalid SQL:
SELECT (_wr * 0) +
((_count - _wr - _rr - _rd) * 1) +
(_rd * 2) +
(_rr * 3) AS points
FROM (
SELECT userid, COUNT(*) AS _count,
SUM(score_key != bet_score_key) AS _wr,
SUM(bet_home=points_home AND bet_away=points_away) AS _rr,
SUM(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 HG_soccer_user_bet AS b
INNER JOIN HG_soccer_match AS m ON(m.id=b.match_id)
WHERE userid=1 AND score_key>0 AND match_is_finished=1
GROUP BY userid) AS userpoints;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`hardware_Hardwaregame`.`b`.`bet_home` - `hardware_Hardwaregame`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Tuesday, June 12th 2012 @ 01:50:09 PM
Error Date : Tuesday, June 12th 2012 @ 01:50:09 PM
What's?? Help please