Bug Database Error

[Mick]

Got this error in my logs for the arcade:

#####################################
=====================================================

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT COUNT(*) AS plays, SUM(timefinish - timestart) AS timespent FROM theforumprefix__dbtech_vbarcade_session WHERE (sessionid = 3895 OR record > 2) AND gameid = 'fishy';

MySQL Error : BIGINT UNSIGNED value is out of range in '(`vb44`.`theforumprefix__dbtech_vbarcade_session`.`timefinish` - `vb44`.`theforumprefix__dbtech_vbarcade_session`.`timestart`)'
Error Number : 1690
Request Date : Tuesday, March 11th 2014 @ 06:03:25 PM
Error Date : Tuesday, March 11th 2014 @ 06:03:25 PM
Script : Arcade - DigitalWorldz Technology Forum - Satellite, television, consoles, community
Referrer : DigitalWorldz Technology Forum - Satellite, television, consoles, community
IP Address : 80.1.1.10
Username : useless1
Classname : vB_Database_MySQLi
MySQL Version :
=====================================================
#####################################

Thank you

 

[Fillip H.]

What MySQL version are you running? That information appears to have been truncated from the error message.

 

[Fillip H.]

Update: I did some research, and I may have a potential fix for this. Can you please try re-downloading the mod and re-uploading /arcade.php and let me know if this works for you?