Properly removing TMS

[Hostboard]

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:


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/admincp/index.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?

[Seven Skins]

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