View Single Post
  #1  
Old 09-09-2014, 07:09 AM
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Location: Little Rock, AR
Posts: 1,060
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problems Installing vBTT Tracker...

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:

Code:
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.
Attached Files
File Type: txt ssh errors.txt (18.1 KB, 4 views)
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02433 seconds
  • Memory Usage 1,786KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_attachment
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete