Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 09-09-2014, 08: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
 

Thread Tools
Display Modes

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. The time now is 07:09 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03837 seconds
  • Memory Usage 2,402KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (1)postbit_attachment
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete