Problems Installing vBTT Tracker...

[HM666]

I am running vBulletin 3.8.8 and I wanted to install the vBTT3 tracker for my bootleg forum. It seems that the only place to get the files is on SourceForge, so I downloaded it from there and there seems to be no support ANYWHERE for this tracker. And its the only thing that seems to work for some vBulletin users.

So here's my problem, maybe someone here can help me out. The instructions say to install XBT on the server after uploading the files & importing the vB product into the Admincp. I did that all imported fine but when I went to use SSH to install the XBT tracker portion I got a TON of errors. I have no idea what they mean I do not use SSH all that often. The server is CentOS Linux. I've attached the errors in a text file because there were a lot of them.

After I ran the XBT install in Putty and tried to view my forums I got the following database error:

Database error in vBulletin 3.8.8:

Invalid SQL:

		SELECT attachmentid, attachment.userid, filename, size , attachment.dateline, attachment.postid, seeders, leechers, completed, post.threadid, post.title, user.username, user.userid
		FROM vb3_attachment
            LEFT JOIN vb3_post ON post.postid = attachment.postid
            LEFT JOIN vb3_user ON user.userid = attachment.userid
            WHERE info_hash != '' ORDER BY attachmentid DESC LIMIT 20;

MySQL Error   : Unknown column 'attachment.userid' in 'field list'
Error Number  : 1054
Request Date  : Monday, September 8th 2014 @ 05:18:23 AM
Error Date    : Monday, September 8th 2014 @ 05:18:23 AM
Script        : http://metalbootlegs.com/
Referrer      : http://metalbootlegs.com/misc.php?do=donate
IP Address    : xxxxxxxxxxxx
Username      : HerzeleidMeister
Classname     : vB_Database
MySQL Version : 5.5.37-cll

I realize that if i had errors on the XBT install that there was a chance that the tracker would not work, but I thought I'd try. I figured at least if it worked somewhat I could tinker with it to get it to work the rest of the way.

I did all the file edits as it said in the instructions and still had the database error.

Anyone have any ideas? Please help as I'd really like to have a working tracker for my site.

[Lynne]

You are using a database prefix, so this is wrong:
attachment.userid

It should be:
vb3_attachment.userid

You will need to find that in the code and modify it. (And, actually change it in several places in the query - whenever is says table.field, change to vb3_table.field)

[mitch84]

where are you downloaded that? here?
http://xbtt.sourceforge.net/tracker/

[HM666]

Originally Posted by Lynne

You are using a database prefix, so this is wrong:
attachment.userid

It should be:
vb3_attachment.userid

You will need to find that in the code and modify it. (And, actually change it in several places in the query - whenever is says table.field, change to vb3_table.field)

Ok The host actually found that some of the things that it needed were not installed so they have installed them, but there is one thing that they cannot install. I'll hunt down the message and copy and paste that here as I'm not sure what to do to solve that issue. Here is what the prob is with the host:

boost-devel gcc-c++ subversion are all installed

mysql-devel from yum can not be installed because it would conflict with cpanel's mysql install. Theirs some include a devel package for mysql. It could be cpanel's mysql is too new. Does this tracker offer any precompiled binaries?

Lynn, Are you talking about the xml file for the product for vBTT?

Originally Posted by mitch84

where are you downloaded that? here?
http://xbtt.sourceforge.net/tracker/

No I got it from here: https://sourceforge.net/projects/vbtt/ xbt is already included in this release. He said in the installation file that the xbt tracker is modified.

YOU MUST USE THE INCLUDED XBT SOURCE TO ENABLE SPEED AND WHO COMPLETED TORRENT SUPPORT.

ORIGINAL XBT DOES NOT INCLUDE THIS SUPPORT!

Thanks.

[Lynne]

Originally Posted by HM666

Lynn, Are you talking about the xml file for the product for vBTT?

I don't know where the query is. You will need to find it either in the files or the plugins. It's somewhere in there.

[HM666]

Originally Posted by Lynne

I don't know where the query is. You will need to find it either in the files or the plugins. It's somewhere in there.

Oh dear, ok thanks