[SOLVED] Change theme from db

Quote

Post by OC2PS » Mon Jul 05, 2021 3:05 am

If my theme crashes OC, how can I change it back to default from the db?

OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions

User avatar
OC2PS
Active Member
Posts
1316
Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary
Top

Re: Change theme from db

Quote

Post by xxvirusxx » Mon Jul 05, 2021 4:23 am

Code: Select all

 update `oc_setting` SET `value` = 'default' WHERE `key` = `config_theme`;

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer

User avatar
xxvirusxx
Expert Member
Posts
4141
Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Top

Re: Change theme from db

Quote

Post by OC2PS » Mon Jul 05, 2021 4:45 am

Thank you kindly.

For anyone referring to this thread, slight correction in syntax (quotes for config_theme):

Code: Select all

UPDATE `oc_setting` SET `value` = 'default' WHERE `key` = 'config_theme';

OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions

User avatar
OC2PS
Active Member
Posts
1316
Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary
Top

Re: Change theme from db

Quote

Post by paulfeakins » Mon Jul 05, 2021 7:40 pm

OC2PS wrote: ↑
Mon Jul 05, 2021 4:45 am
 Thank you kindly.
Please add [SOLVED] to the start of the topic title if this worked.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

User avatar
paulfeakins
Guru Member
Posts
9185
Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Top

Re: Change theme from db

Quote

Post by straightlight » Mon Jul 05, 2021 9:44 pm

I was sure to have posted in here. Anyways, the additional issue was that:

Code: Select all

UPDATE `oc_setting` SET `value` = 'default' WHERE `key` = 'config_theme';
was showing as:

Code: Select all

UPDATE `oc_setting` SET value = 'default' WHERE `key` = 'config_theme';
Glad it was fixed though.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

straightlight
Legendary Member
Posts
22391
Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: niagato, Semrush [Bot], TheDeerKami and 446 guests