tracker working but no seed

overall:
public tracker is working on IPV4 this time but IPV6 still fail.

and again, table "bt_tracker_users" is empty again , so private tracker mode fails

i tested IPV6 , still in public stracker mode:
tracker is working "http://[2001:250:3002:1041::142]/bt6/announce.php"
but there is no seed, so file could not be downloaded.
i guess maybe bittorrent6.12 from bittorrent.com do not support ipv6. so which client are you using for testing ipv6?
by the way, your views (all three views ) have some error

     user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0) AND (.uid = 1) LIMIT 0, 10' at line 16 query: SELECT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, total_size, seeders, leechers, snatches, downloaded, last_seed, bytes_uploaded, bytes_downloaded, bytes_left, last_announce FROM node node WHERE (.bytes_left = 0) AND (.uid = 1) LIMIT 0, 10 in C:\root\bt6\sites\all\modules\views\includes\view.inc on line 755.
  

6.x-9.2-alpha1 , public tracker mode , in IPV4 is all right , but in IPV6 fail

I cannot re-pruduce this. I have tested 6.x-9.2-alpha1 release on clean installation and all works fine...

ok , i will have a clean installation to test again

It's supposed that IPv6 will be used for peers IPs. IPv6 in announce URL take no sense, because this is controlled by other software (DNS, browser, ...). So we need to test IPv6 for peers. You can see your IP (to test is it IPv6 or not) on your profile page (if bt_profile is enabled and set up).

sorry , i can't follow you , could you please describe it in another way ,please?
did you mean , i should not set my "/admin/bt/torrent"--"announce url" =="http://[2001:250:3002:1041::142]/bt6/announce.php"
then how could i test ipv6
and
error shows up on "admin/build/views/edit/bt_user_all_torrents"

i do have a clear installation again , public tracker success in ipv4 but failed in ipv6 ,
table "bt_tracker_users" is empty again while setting to private tracker mode.

overall , would you mind to upload your "success clear installation (whole site)" or email me a copy , my email is "blogbydrupal@gmail.com"
so that i could make a diff between mine one and yours, please!

i don't have an ipv6 domain , and blog.bojistudio.org is ipv4 only , so i have to use ipv6 ip to test.
http://[2001:250:3002:1041::142]/bt8/announce.php works on public tracker mode while i test again on a same physical machine but two different virtual machines A and B , but on a third machine C which is on another physical machine ,C only works on ipv4.
A and B could download files on each other , and they both could not download file from C .
but C could open website "http://[2001:250:3002:1041::142]/bt8/" , which means that C have a normal ipv6 enviroment , too

cut it short ::
i think A\B\C have a normal IPV6 enviroment , but don't know why A and B could not access C using BT while C could access both A and B from webpage but not BT .

And my "bt_tracker_users" (mysql ) is still empty on private mode.i think it's because i don't know how to config "bt_profile module" which also has no document, could you please descripe how to set up "bt_profile module" , i guess it have something correlation with private tracker mode.

think about this situation:
1.the first time you install "project/bittorrent" , you're on public tracker mode by default , then you upload your first BT-file to test ,
your "bt_tracker_users" (mysql ) must be empty , am i right?
2.then you move to private tracker mode by setting "admin/bt/tracker"--"Tracker Scope" to "private" , and left everything else as the same with "public tracker mode"
am i right ?
3.before you upload the second bt-torrent-file , your check your "bt_tracker_users" (mysql ) , this time , is the table still empty . in my case , it's empty , is it normal?
4.you have to use "http://blog.bojistudio.org/bt8/announce.php" as announceURL to create the second bt-torrent-file on private tracker mode and upload but your BT-client told you that your "Missing key"

so , what exactly button or link you click to let "bt_tracker_users" (mysql ) from empty to have passkey inside?

"admin/build/views/edit/bt_user_all_torrents" ,  just below the "Relationships box"  "Error: handler for node_data_field_torrent_file > field_torrent_file_fid doesn't exist!" 
"admin/build/views/edit/bt_user_leeching_torrents                                            "Error: handler for node_data_field_torrent_file > field_torrent_file_fid doesn't exist!" 
admin/build/views/edit/bt_user_seeding_torrents                                              "Error: handler for node_data_field_torrent_file > field_torrent_file_fid doesn't exist!"

then if i use 1 as an argument and click preview , three page of the above also show up the same error message :
  user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0) AND (.uid = 1) LIMIT 0, 10' at line 16 query: SELECT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, total_size, seeders, leechers, snatches, downloaded, last_seed, bytes_uploaded, bytes_downloaded, bytes_left, last_announce FROM node node WHERE (.bytes_left = 0) AND (.uid = 1) LIMIT 0, 10 in C:\root\bt8\sites\all\modules\views\includes\view.inc on line 755.

by the way , are there any user who had reported their success experience to the project?

overall :
i finally found out where was the problem.
your document must have left something important to mention!

if one would like to use private tracker , he or she has to set page "admin/content/node-type/story/display" to "bittorrent"
if one forget to do this step , which is not mention in your document , he or she will fail to test in private mode.
sorry , i wish to make a path , but i don't know how to .

overall :
i finally found out where was the problem.
your document must have left something important to mention!

if one would like to use private tracker , he or she has to set page "admin/content/node-type/story/display" to "bittorrent"
if one forget to do this step , which is not mention in your document , he or she will fail to test in private mode.
sorry , i wish to make a path , but i don't know how to .