Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #11  
Old 7th May 2021, 10:32
firefly007's Avatar
firefly007 firefly007 is offline
SUPPORT GURU
 
Join Date: Jun 2010
P2P
Posts: 699
Default
What source are u using? The cleanup should work out the box so I find the issue u are having very strange. Did u change something down the line?
__________________

Due to free time I'm able to help interested member's with their tracker.

Please Note!
Depending on your requests I will charge you for my assistance for Tracker installs and mods.
All my mods are custom and prices will very depending on the request.

I'm able to install any tracker and mods including themes.

Please PM me

Reply With Quote
  #12  
Old 7th May 2021, 10:40
budgie's Avatar
budgie budgie is offline
Senior Member
 
Join Date: Nov 2020
Posts: 46
Default
i was on Debian 8 was working fine seeding and all, and all then they removed it so i had to go with Debian 9 and that when it all started on cleanup.. all the code base is mysqli nps on that everything works on but that part in clean up
also says seeding on seedbox and home pc no errors at all just clean up sending it dead to all to see but you can download the dead torrent lol
TBDev 09
And fully working on all PHP7 7.0 7.1 7.2 so on but same probs with clean ups
--------------------------------------------------------------------------------------------
In the U-232 master its all mysqli too only probs with that is announce
on line
PHP Code:
 mysqli_query($GLOBALS["___mysqli_ston"], "INSERT INTO peers (torrent, userid, peer_id, ip, port, connectable, uploaded, downloaded, to_go, started, last_action, seeder, agent, downloadoffset, uploadoffset, passkey) VALUES ($torrentid{$user['id']}, ".sqlesc($peer_id).", ".sqlesc($ip).", $port, '$connectable', $uploaded$downloaded$left, ".time().", ".time().", '$seeder', ".sqlesc($agent).", $downloaded$uploaded, ".sqlesc($passkey).")") or err("PL Err 2"); 
now ive looked in to this in depth checked DB and all the inputs are there so that dose your head in when its all there in seedbox and home pc the announce errors out on this like torrent dead error PL Err 2 not telling where look in longs and server longs nothing
Also i installed on my pc still same error

Last edited by budgie; 7th May 2021 at 10:53.
Reply With Quote
  #13  
Old 7th May 2021, 11:05
firefly007's Avatar
firefly007 firefly007 is offline
SUPPORT GURU
 
Join Date: Jun 2010
P2P
Posts: 699
Default
Ahhh I remember getting the same error (PL Err 2) some time ago but I cant remember what i did to fix the issue. I think I did something in the announce but I could be mistaken.

Edit:

Hard to fix without actually looking at the code. If u haven't fixed the issue and I have the time I will think about installing u232
__________________

Due to free time I'm able to help interested member's with their tracker.

Please Note!
Depending on your requests I will charge you for my assistance for Tracker installs and mods.
All my mods are custom and prices will very depending on the request.

I'm able to install any tracker and mods including themes.

Please PM me

Reply With Quote
  #14  
Old 7th May 2021, 11:11
budgie's Avatar
budgie budgie is offline
Senior Member
 
Join Date: Nov 2020
Posts: 46
Thumbs up
IVE have been at this for months on it mate i just removed the the xampp-win32-7.0.33-0-VC14-installer
from pc and server too as the error would not fix at all not even on seedbox same error

so if you would like to give ago please do mate would love the fix for it too mate
Reply With Quote
  #15  
Old 7th May 2021, 20:25
darkalchemy's Avatar
darkalchemy darkalchemy is offline
Super Moderator
 
Join Date: Dec 2017
United States
Posts: 96
Default
Quote:
Originally Posted by budgie View Post
also this will not work on seedbox and home pc torrents On cleanups
you will get DB locks on it via mysqli it will only work on PHP 5.6 NOT 7.0 SO ON

PHP Code:
    $fields explode(":""comments:leechers:seeders");
    
$res sql_query("SELECT id, seeders, leechers, comments FROM torrents");
    while (
$row mysqli_fetch_assoc($res)) {
        
$id $row["id"];
        
$torr $torrents[$id];
        foreach (
$fields as $field) {
            if (!isset(
$torr[$field]))
                
$torr[$field] = 0;
        }
        
$update = array();
        foreach (
$fields as $field) {
            if (
$torr[$field] != $row[$field])
                
$update[] = "$field = " $torr[$field];
        }
        if (
count($update))
            
sql_query("UPDATE torrents SET " implode(","$update) . " WHERE id = $id");
    } 
Which query gives the lock? Is your table myisam or innodb?

MyISAM locks the entire table on update, InnoDB on locks the effected rows.
__________________
I do custom coding, source installs, mods, server setup and/or config, etc. Feel free to pitch me your needs and your offer.
Reply With Quote
  #16  
Old 8th May 2021, 10:16
budgie's Avatar
budgie budgie is offline
Senior Member
 
Join Date: Nov 2020
Posts: 46
Default
It is the MyISAM on updates it only done it from moving from Debian 8 to Debian 9 as the server hosting removed the Debian 8
Reply With Quote
  #17  
Old 8th May 2021, 18:26
darkalchemy's Avatar
darkalchemy darkalchemy is offline
Super Moderator
 
Join Date: Dec 2017
United States
Posts: 96
Default
Quote:
Originally Posted by budgie View Post
It is the MyISAM on updates it only done it from moving from Debian 8 to Debian 9 as the server hosting removed the Debian 8
The table lock happens no matter what is you are using. The difference would be MySQL version you are using.
__________________
I do custom coding, source installs, mods, server setup and/or config, etc. Feel free to pitch me your needs and your offer.
Reply With Quote
  #18  
Old 8th May 2021, 19:01
budgie's Avatar
budgie budgie is offline
Senior Member
 
Join Date: Nov 2020
Posts: 46
Default
Apache/2.4.46 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 24568906d452ec590732a93b051f3827e02749b83 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.0.33-0+deb9u10
Debian 9
Version information: 4.6.6deb4+deb9u2
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 12:22. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2021, vBulletin Solutions Inc.