HM666
09-09-2014, 08:09 AM
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. :(
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. :(