R4to0
New member
This started few days ago and i have no idea what is causing this.
Thanks,
R4to0.
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT u.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS avheight_thumb, c.width_thumb AS avwidth_thumb, c.filedata_thumb, SUM(s.timefinish - s.timestart) AS total FROM vb_dbtech_vbarcade_session AS s LEFT JOIN vb_user AS u ON (u.userid = s.userid) LEFT JOIN vb_dbtech_vbarcade_game AS g ON (g.gameid = s.gameid) LEFT JOIN vb_avatar AS a ON (a.avatarid = u.avatarid) LEFT JOIN vb_customavatar AS c ON (c.userid = u.userid) WHERE g.enabled = 1 AND s.record > 2 GROUP BY s.userid ORDER BY total DESC LIMIT 3;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`xxxxxx`.`s`.`timefinish` - `xxxxxx`.`s`.`timestart`)'
Error Number : 1690
Request Date : Friday, November 16th 2012 @ 03:07:11 AM
Error Date : Friday, November 16th 2012 @ 03:07:11 AM
IP Address : 186.2xx.xx.xx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.22-log
Thanks,
R4to0.
Last edited: