[Forum] How can I manually disable my Theme?

[ericfahey]

I currently am using a theme that i purchased from a website which i won't mention for advertising.

Anyways, I believe my main theme is corrupted somehow and I can't remove it via the AdminCP, how can I remove the theme manually by running some sort of query? etc.

Thanks

[Wayne Luke]

You can disable it by removing the check in the box on the left side in the style manager. Should be able to delete it by selecting Delete Style off the drop down.

[MEsh3L85]

is it that important to you to remove it completely ?
you can re-assign the default style by going to:
admincp >> settings >> style and language settings , then change the default style .

if you want to remove it from the style quick-chooser you can just go to :
admincp >> style manager >> uncheck the style that you don't want >> then save .

good luck


Edit : sorry Wayne didn't see your post

[ericfahey]

When I attempt to use the style manager or the style and language settings I'm given a database error:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT t1.templateid AS templateid_1, t1.title ,
t1.templateid AS templateid_1, t1.title AS title1, t1.styleid AS styleid_1 ,
t2.templateid AS templateid_2, t2.title AS title2, t2.styleid AS styleid_2
FROM template AS t1
LEFT JOIN template AS t1 ON (t1.title=t1.title AND t1.styleid=-2-1)
LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.styleid=17)
WHERE t1.styleid IN (-1,0)
ORDER BY t1.title;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Monday, May 14th 2012 @ 11:23:48 PM
Error Date : Monday, May 14th 2012 @ 11:23:49 PM
Script : http://www.website.com/forums/adminc...roup=stylelang
Referrer : http://www.website.com/forums/adminc...ons.php?null=0
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.62-cll

----

I've been told it was a error regarding a 3rd party plugin, that is not the case after disabling the plugins im still given the database error.

[Wayne Luke]

This is an error caused by a plugin. The same plugin you disabled before for this thread:

https://www.vbulletin.com/forum/showthread.php/399646-I-ve-been-given-the-following-SQL-Error

Should really uninstall the addon it belongs to until its author provides a fix. Another thread said it was the TMS addon.

[ericfahey]

This is an error caused by a plugin. The same plugin you disabled before for this thread:

https://www.vbulletin.com/forum/showthread.php/399646-I-ve-been-given-the-following-SQL-Error

Should really uninstall the addon it belongs to until its author provides a fix. Another thread said it was the TMS addon.

I uninstalled all my plugins/addons but I'm still given the error.

[TheLastSuperman]

I uninstalled all my plugins/addons but I'm still given the error.

At the very top of this guide https://www.vbulletin.com/forum/show...P-Forum-Access follow the info and add:

define('DISABLE_HOOKS', true);

To the top of your config.php file, now check the style manager and see if things will work properly, if so then more than likely you did not remove all the files associated with the mod OR a plugin is still present in the plugin manager.

[ericfahey]

At the very top of this guide https://www.vbulletin.com/forum/show...P-Forum-Access follow the info and add:

define('DISABLE_HOOKS', true);

To the top of your config.php file, now check the style manager and see if things will work properly, if so then more than likely you did not remove all the files associated with the mod OR a plugin is still present in the plugin manager.

Once I add that code and uploaded a fresh copy of Vbulletin, I am given the following error:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT t1.templateid, t1.title, INSTR(',17,-2-1,', CONCAT(',', t1.styleid, ',') ) AS ordercontrol, t1.styleid
FROM template AS t1
LEFT JOIN template AS t2 ON (t2.title=t1.title AND t2.styleid = -2)
WHERE t1.styleid IN (17,-) AND
t2.title IS NULL
ORDER BY title, ordercontrol;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND
t2.title IS NULL
ORDER BY title, ordercontrol' at line 4
Error Number : 1064
Request Date : Tuesday, May 15th 2012 @ 12:33:37 AM
Error Date : Tuesday, May 15th 2012 @ 12:33:37 AM
Script : http://www.dfg.com/forums/admincp/op...roup=stylelang
Referrer : http://www.fdg.com/forums/admincp/options.php?null=0
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.62-cll

[Wayne Luke]

That is because this addon changes how templates work and saves modifications in the template code itself. Something we don't recommend. You need to post in the modification thread over at www.vbulletin.org and ask how to properly uninstall it or fix the original error.

[TheLastSuperman]

Ok then let's check the database and ensure the TMS is 100% removed, use the same guide I posted above i.e. https://www.vbulletin.com/forum/show...P-Forum-Access however I want you to skip to the bottom first and try this query:

UPDATE plugin SET active=0

You still need to have the code in config.php too but let's run that query to ensure everything is in fact 100% disabled. If that does not sort it to where you can check things properly then you need to scroll back up and follow my guide and check for any remnants of the TMS in your product and plugin tables.

[whiteroserabbit]

Thanks for all the help!