Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2013, 02:40 PM
Hostboard's Avatar
Hostboard Hostboard is offline
 
Join Date: May 2002
Location: CT
Posts: 843
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Properly removing TMS

TMS has been giving me some issues due to not installing properly. Re-installing did not work and uninstalling does not either (both giving db errors)

So I am attempting a manual removal. So far I have:

DROP tables:
'templateedit' and 'templateditlocation'

Deleted fields:
'templateeditlist' from the 'style' table
'edited' from the 'template' table
'TMS' from the 'product' table

Then delete the uploaded files.

However I still get a DB error when I try to access the AP's main screen:

Code:
Database error in vBulletin 4.1.12:
Invalid SQL:
  SELECT templateedit.version AS editversion, template.version AS templateversion
  FROM templateeditlocation AS templateeditlocation
  LEFT JOIN templateedit AS templateedit ON (templateedit.varname=templateeditlocation.varname AND templateedit.styleid=-1)
  LEFT JOIN template AS template ON (template.title=templateeditlocation.template AND template.styleid = -1)
  LEFT JOIN product AS product ON (product.productid=templateeditlocation.product)
  WHERE templateedit.active = 1
   AND (templateeditlocation.product = 'vbulletin' OR product.active = 1)  
   AND templateeditlocation.varname != 'tmsbranding';
MySQL Error   : Table 'forum4.templateeditlocation' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, February 6th 2013 @ 08:38:41 AM
Error Date    : Wednesday, February 6th 2013 @ 08:38:41 AM
Script        : http://www.MyDomain.com/forums/admin...ex.php?do=home
Referrer      : http://www.MyDomain.com/forums/admincp/index.php?do=nav
IP Address    : xxx.xxx.xxx.xxx
Username      : UserID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.66-0ubuntu0.10.04.3
Something is still hooked into VB. What did I miss/need to do to fully remove it?
Reply With Quote
  #2  
Old 02-06-2013, 08:42 PM
Seven Skins's Avatar
Seven Skins Seven Skins is offline
 
Join Date: Sep 2008
Location: London, UK
Posts: 1,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Look into the XML or PHP installation file for the hack, it may give you the answer.
Reply With Quote
Reply


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 12:33 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.05123 seconds
  • Memory Usage 2,166KB
  • 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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (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_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
  • 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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete