Database issue

Started by NekoJonez, April 11, 2015, 10:59:00 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

NekoJonez

QuoteDatabase Error: BIGINT UNSIGNED value is out of range in '((case when (`arpegi_be`.`score`.`champion_to` = 0) then 1428760945 else `arpegi_be`.`score`.`champion_to` end) - `arpegi_be`.`score`.`champion_from`)'


SELECT game.id_game, game.game_name,
CASE WHEN champion_from > 0 THEN (CASE WHEN champion_to = 0 THEN UNIX_TIMESTAMP() ELSE champion_to END - champion_from) ELSE 0 END AS champion_duration,
IFNULL(mem.id_member, 0) AS id_member, IFNULL(mem.real_name, '') AS real_name, CASE WHEN champion_to = 0 THEN 1 ELSE 0 END AS current
FROM smf_arcade_scores AS score
LEFT JOIN smf_arcade_games AS game ON (game.id_game = score.id_game)
LEFT JOIN smf_members AS mem ON (mem.id_member = score.id_member)
WHERE 1 = 1
GROUP BY score.id_score
HAVING champion_duration > 0
ORDER BY CASE WHEN champion_from > 0 THEN (CASE WHEN champion_to = 0 THEN UNIX_TIMESTAMP() ELSE champion_to END - champion_from) ELSE 0 END DESC
LIMIT 10

File: /*****/arpegi.be/****/Sources/ArcadeStats.php
Line: 272

Could somebody help me with this? It happens when I click the stats page.

Skhilled

Which version are you using? And do you have any other mods installed? I've never seen that error before.

NekoJonez

2.6 RC1.

Maybe I should reinstall it. ...? Can I uninstall the arcade without loosing the games / db stuff?

Skhilled

Perhaps, something did not install properly more than a mod conflict. And if you do uninstall/reinstall you should not lose your scores but will need to reinstall the games.