Status
Not open for further replies.

R4to0

New member
This started few days ago and i have no idea what is causing this.

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:
Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it :D
 
I can create the temporary admincp user, but about ftp i have to pay to my webhost company for multiuser ftp and it's restricted to brazil only.

I was "debugging" the problem, also my ISP recently upgraded mysql to version 5.5, so i backup'd current database and installed mysql server 5.1 at my machine, enabled remote access to php script and ta-da! arcade.php works again... But if i use mysql server (5.5.x) from isp, the script crashes again.

Images:
http://puu.sh/1r2z7
http://puu.sh/1r2x9

I was searching "BIGINT UNSIGNED value is out of range" at google, and found this: MySQL :: MySQL 5.5 Reference Manual :: 11.2.6 Out-of-Range and Overflow Handling

Quoting from link:

As of MySQL 5.5.5, overflow during numeric expression evaluation results in an error. For example, the largest signed BIGINT value is 9223372036854775807, so the following expression produces an error:

mysql> SELECT 9223372036854775807 + 1;
ERROR 1690 (22003): BIGINT value is out of range in '(9223372036854775807 + 1)'

To enable the operation to succeed in this case, convert the value to unsigned;


I hope all this stuff help us :)


Thanks,
R4to0.
 
Just to let know, someone at my isp fucked something and my pages are unavailable until tomorrow for server change, and some hours for dns propagation.

EDIT: Site has been migrated, so what's the progress?
 
Last edited:
Close this, i reinstalled the product and it works (losing all data and scores).

Thanks,
R4to0.
 
Sorry, I was unable to reproduce this in order to debug the cause :(

If it happens again, just post in this thread and I will debug it on your site.
 
No problem, i'm still have an .sql backup, and if you need, i can provide for debugging or host separately.
 
Status
Not open for further replies.

Legacy vBArcade

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
898
Customer rating
0.00 star(s) 0 ratings
Back
Top