|
#1
|
||||
|
||||
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 |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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; } 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: ive fixed it seeding ok now no errors |
|
|