cbjarnson Posted December 6, 2013 Share Posted December 6, 2013 I am getting this error on front page Fatal error: Uncaught exception 'SmartyException' with message 'Unable to load template file '/home/sunstone/public_html/themes/leotea/./layout//header.tpl' in '/home/sunstone/public_html/themes/leotea/./header.tpl'' in /home/sunstone/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php:127 Stack trace: #0 /home/sunstone/public_html/tools/smarty/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch(NULL, NULL, NULL, NULL, false, false, true) #1 /home/sunstone/public_html/cache/smarty/compile/e5/97/70/e59770ef3b52497bf2726ed6c5d51cb111c1a6eb.file.header.tpl.php(282): Smarty_Internal_Template->getSubTemplate('/home/sunstone/...', NULL, NULL, NULL, NULL, Array, 0) #2 /home/sunstone/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php(180): content_52a11b3320be88_45324374(Object(Smarty_Internal_Template)) #3 /home/sunstone/public_html/tools/smarty/sysplugins/smarty_internal_template.php(286): Smarty_Internal_TemplateBase->fetch(NULL, NULL, NULL, NULL, false, false, t in/home/sunstone/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php on line 127 Link to comment Share on other sites More sharing options...
cbjarnson Posted December 6, 2013 Author Share Posted December 6, 2013 I upgraded the theme but now I am getting a mysql error MySQL said: Table 'sunstone_prestashop.ps_leohook' doesn't exist I have no idea how to add a table into mysql. Link to comment Share on other sites More sharing options...
cbjarnson Posted December 6, 2013 Author Share Posted December 6, 2013 I am in php and I see the table. However when I click on it it says it does not exist. I also found this code somewhere and tried to enter it as a query DROP TABLE IF EXISTS `PREFIX_leohook`;CREATE TABLE IF NOT EXISTS `PREFIX_leohook` ( `id_hook` int(11) NOT NULL, `id_module` int(11) NOT NULL, `id_shop` int(11) NOT NULL, `theme` varchar(50) NOT NULL, `name_hook` varchar(100) NOT NULL, PRIMARY KEY (`id_hook`,`id_module`,`id_shop`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; it did not do anything. Link to comment Share on other sites More sharing options...
cbjarnson Posted December 6, 2013 Author Share Posted December 6, 2013 Now I tried to create it manually and it says that table already exists. I then click on the table and it says it doesn't exist. Link to comment Share on other sites More sharing options...
vekia Posted December 6, 2013 Share Posted December 6, 2013 PREFIX_leohook what is PREFIX ? it must be a variable with prefix value in this case: ps Link to comment Share on other sites More sharing options...
cbjarnson Posted December 6, 2013 Author Share Posted December 6, 2013 I ended up having to restore my old store. I could not figure it out. Link to comment Share on other sites More sharing options...
vekia Posted December 6, 2013 Share Posted December 6, 2013 ok, thank you for information how you did. hope that everything works for you now can you confirm please? i will mark this topic as [solved] then with regards, milos Link to comment Share on other sites More sharing options...
cbjarnson Posted December 6, 2013 Author Share Posted December 6, 2013 I restored my public_html file from a backup and restored the old database from cpanel. The site is working now. But I was unable to upgrade to 1.5.6.1 I am at 1.5.6.0 so I am fine for now. You can mark it as solved. Link to comment Share on other sites More sharing options...
Recommended Posts