Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > BT.Manager (phpMyBitTorrent)
Reply
  #1  
Old 4th August 2021, 08:59
xblade's Avatar
xblade xblade is offline
Cod3r
 
Join Date: Nov 2020
P2P
Posts: 239
Default Announce Error
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
Attached Thumbnails
Snag_52526ac.jpg  
Reply With Quote
  #2  
Old 4th August 2021, 16:08
darkalchemy darkalchemy is offline
Administrator
 
Join Date: Dec 2017
United States
Posts: 101
Default
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?

Last edited by darkalchemy; 4th August 2021 at 16:30.
Reply With Quote
  #3  
Old 6th August 2021, 08:44
xblade's Avatar
xblade xblade is offline
Cod3r
 
Join Date: Nov 2020
P2P
Posts: 239
Default
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
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 19:39. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.