Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)
-   -   Announce Error (http://www.bvlist.com/showthread.php?t=12400)

xblade 4th August 2021 08:59
Announce Error
 
1 Attachment(s)
still have this Announce Error joe
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+94499103, port = '61034', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '3117103127', to_go = '0',speedup='0',speeddown='-425672', last_action = '2021-08-02 17:38:37', warned = 'no', hnr_warning = 'no' WHERE torrent = 26 AND userid = 100 Out of range value for column 'speeddown' at row 5
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+94499103, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '798928', agent= NULL, ip = '633043532', to_go = '0',speedup='-207690',speeddown='0', last_action = '2021-08-02 17:38:27', warned = 'no', hnr_warning = 'no' WHERE torrent = 26 AND userid = 3 Out of range value for column 'speedup' at row 45
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+3423492, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-3423492', last_action = '2021-08-02 06:32:37', warned = 'no', hnr_warning = 'no' WHERE torrent = 2 AND userid = 71 Out of range value for column 'speeddown' at row 1
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-3337',speeddown='0', last_action = '2021-08-04 06:21:20', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-4511',speeddown='0', last_action = '2021-08-04 06:18:40', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-5473',speeddown='0', last_action = '2021-08-04 06:17:20', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-8588', last_action = '2021-08-04 06:16:48', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-6127',speeddown='0', last_action = '2021-08-04 06:16:40', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-6516',speeddown='0', last_action = '2021-08-04 06:16:20', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-6730',speeddown='0', last_action = '2021-08-04 06:16:10', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+2052523, downloaded = downloaded+0, port = '51153', seeder = 'yes', connectable = 'yes', seeding_time = '1520415', agent= NULL, ip = '633043532', to_go = '0',speedup='-6842',speeddown='0', last_action = '2021-08-04 06:16:05', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 3 Out of range value for column 'speedup' at row 3
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-13157', last_action = '2021-08-04 06:15:25', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-27007', last_action = '2021-08-04 06:14:05', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-57015', last_action = '2021-08-04 06:13:25', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-128283', last_action = '2021-08-04 06:13:05', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2
Announce Error
SQL Error: UPDATE torrent_snatched SET uploaded = uploaded+0, downloaded = downloaded+2052523, port = '41511', seeder = 'yes', connectable = 'yes', seeding_time = '299', agent= NULL, ip = '89085303', to_go = '0',speedup='0',speeddown='-342087', last_action = '2021-08-04 06:12:55', warned = 'no', hnr_warning = 'no' WHERE torrent = 3 AND userid = 71 Out of range value for column 'speeddown' at row 2

everyone who is downloading is getting same error

darkalchemy 4th August 2021 16:08
Is speeddown supposed to be a negative number? Is the column bigint signed?

Looks like speedup has the same issue, should it be a negative number?

xblade 6th August 2021 08:44
yes the bigint signed 20
ive looked at github for fix in the announce.php took it and its the same as ive got i checked the update set it to the announce.php and all torrents went dead

From

Code:
            die();
        }
        if ($self["seconds"] != 0){
                $upload_speed = round(($self["uploaded"] - $uploaded) / $self["seconds"]);
                $download_speed = round(($self["downloaded"] - $downloaded) / $self["seconds"] );
                $updateset[] = "speed = speed - '".$self["upload_speed"]."' + '".$upload_speed."'";
        } else {
                $upload_speed = 0;
                $download_speed = 0;
        }
To

Code:
            die();
        }
        if ($self["seconds"] != 0){
                $upload_speed = round(($uploaded - $self["uploaded"]) / $self["seconds"]);
                $download_speed = round(($downloaded - $self["downloaded"]) / $self["seconds"] );
                $upload_speed = round(($self["uploaded"] - $uploaded) / $self["seconds"]);
                $download_speed = round(($self["downloaded"] - $downloaded) / $self["seconds"] );
                $updateset[] = "speed = speed - '".$self["upload_speed"]."' + '".$upload_speed."'";
        } else {
                $upload_speed = 0;
        }
Bump: its the same for every user on site who downloads a torrent get this error in there utorrent or what ever users are using

Bump: its the same for every user on site who downloads a torrent get this error in there utorrent or what ever users are using

Bump: ive fixed it seeding ok now no errors


All times are GMT +2. The time now is 22:35.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.