Faizan Qureshi Posted July 13, 2020 Share Posted July 13, 2020 Anyone please suggest me on the error below; Table 'rubinabc_pres526.psry_xip_image_type' doesn't exist<br /><br /><pre>SELECT * FROM `psry_xip_image_type` WHERE active = 1 AND id_shop = 1</pre> at line 769 in file classes/db/Db.php if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, ' ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. } DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 46 - modules/xipblog/classes/xipimagetypeclass.php] - [1 Arguments] xipimagetypeclass::GetAllImageTypes - [line 467 - modules/xipblog/classes/xippostsclass.php] xippostsclass::GetCategoryPosts - [line 240 - modules/xipblogdisplayposts/xipblogdisplayposts.php] - [5 Arguments] xipblogdisplayposts->ExecuteHook - [line 258 - modules/xipblogdisplayposts/xipblogdisplayposts.php] xipblogdisplayposts->hookdisplayBlockPosition1 - [line 970 - classes/Hook.php] - [1 Arguments] Link to comment Share on other sites More sharing options...
prestamonste Posted July 14, 2020 Share Posted July 14, 2020 (edited) Hi there, In the table image_type, there are no columns id_shop and active. => Your sql is wrong. Thanks, Edited July 14, 2020 by prestamonste (see edit history) Link to comment Share on other sites More sharing options...
Faizan Qureshi Posted July 14, 2020 Author Share Posted July 14, 2020 (edited) Then what should i do now? kindly recommend Edited July 14, 2020 by Faizan Qureshi (see edit history) Link to comment Share on other sites More sharing options...
Faizan Qureshi Posted July 14, 2020 Author Share Posted July 14, 2020 furthermore what is this Link to comment Share on other sites More sharing options...
Mian Waqas Posted July 14, 2020 Share Posted July 14, 2020 the issue seems to be the module "xipblog" when you disable it does it fix the issue? also can you delete or rename /Var/Cache/ "dev" & prod folders manually to clear the cache and then check. Regards Link to comment Share on other sites More sharing options...
Faizan Qureshi Posted July 14, 2020 Author Share Posted July 14, 2020 Thanks/ xipblog uninstalled as there is no use. Kindly suggest me the below errors appearing in the debug mode: Whoops, looks like something went wrong. (1/1) ContextErrorException Warning: count(): Parameter must be an array or an object that implements Countable in Staticfooter.php line 55 at Staticfooter->getStaticfooterLists(1, 'displayBlockFooter1')in posstaticfooter.php line 140 at posstaticfooter->hookdisplayBlockFooter1(array('smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 1))in Hook.php line 970 at HookCore::coreCallHook(object(posstaticfooter), 'hookdisplayBlockFooter1', array('smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 1))in Hook.php line 355 at HookCore::callHookOn(object(posstaticfooter), 'displayBlockFooter1', array('smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 1))in Hook.php line 907 at HookCore::exec('displayBlockFooter1', array('smarty' => object(SmartyDevTemplate), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 1), null)in smarty.config.inc.php line 167 at smartyHook(array('h' => 'displayBlockFooter1'), object(SmartyDevTemplate))in SmartyLazyRegister.php line 83 at SmartyLazyRegister->__call('smartyHook', array(array('h' => 'displayBlockFooter1'), object(SmartyDevTemplate)))in d266d580f49e6021f7335cce91c671ef286c8ecb_2.file.footer.tpl.php line 26 at content_5f0df149a7f603_52396423(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123 at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114 at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216 at Smarty_Internal_Template->render()in smarty_internal_template.php line 385 at Smarty_Internal_Template->_subTemplateRender('file:_partials/footer.tpl', null, 'layouts/layout-full-width.tpl', 0, 31536000, array(), 0, false)in 71c07687159047987f1aa0325189c53c937e0779_2.file.layout-both-columns.tpl.php line 315 at Block_1015281865f0c97d40f0865_54122264->callBlock(object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 248 at Smarty_Internal_Runtime_Inheritance->callBlock(object(Block_1015281865f0c97d40f0865_54122264), object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 184 at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_1015281865f0c97d40f0865_54122264))in smarty_internal_runtime_inheritance.php line 156 at Smarty_Internal_Runtime_Inheritance->instanceBlock(object(SmartyDevTemplate), 'Block_1015281865f0c97d40f0865_54122264', 'footer')in 71c07687159047987f1aa0325189c53c937e0779_2.file.layout-both-columns.tpl.php line 110 at content_5f0c97d40f21f6_41329574(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123 at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114 at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216 at Smarty_Internal_Template->render()in smarty_internal_template.php line 385 at Smarty_Internal_Template->_subTemplateRender('layouts/layout-both-columns.tpl', null, 'layouts/layout-full-width.tpl', 0, 31536000, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 125 at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-both-columns.tpl')in 04a7fb7b92caff7686de269bd73717cd1cc10136_2.file.layout-full-width.tpl.php line 42 at content_5f0c97d40da722_82991539(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123 at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114 at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216 at Smarty_Internal_Template->render()in smarty_internal_template.php line 385 at Smarty_Internal_Template->_subTemplateRender('layouts/layout-full-width.tpl', null, 'layouts/layout-full-width.tpl', 0, 31536000, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 125 at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-full-width.tpl')in 22985e41433fa3b7a1c9e50277a1212a0db3e50e_2.file.page.tpl.php line 31 at content_5f0c97d40d4a35_87221822(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123 at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114 at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216 at Smarty_Internal_Template->render()in smarty_internal_template.php line 385 at Smarty_Internal_Template->_subTemplateRender('page.tpl', null, 'layouts/layout-full-width.tpl', 0, 31536000, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 125 at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'page.tpl')in 8987683dbdc2092d9ed015923390310a65208ed8_2.file.index.tpl.php line 31 at content_5f0c97d40caea2_37906218(object(SmartyDevTemplate))in smarty_template_resource_base.php line 123 at Smarty_Template_Resource_Base->getRenderedTemplateCode(object(SmartyDevTemplate))in smarty_template_compiled.php line 114 at Smarty_Template_Compiled->render(object(SmartyDevTemplate))in smarty_internal_template.php line 216 at Smarty_Internal_Template->render(false, 0)in smarty_internal_templatebase.php line 232 at Smarty_Internal_TemplateBase->_execute(object(SmartyDevTemplate), null, 'layouts/layout-full-width.tpl', null, 0)in smarty_internal_templatebase.php line 116 at Smarty_Internal_TemplateBase->fetch('index.tpl', null, 'layouts/layout-full-width.tpl', null, false, true, false)in SmartyDev.php line 40 at SmartyDev->fetch('index.tpl', null, 'layouts/layout-full-width.tpl')in FrontController.php line 683 at FrontControllerCore->smartyOutputContent('index.tpl')in FrontController.php line 667 at FrontControllerCore->display()in Controller.php line 312 at ControllerCore->run()in Dispatcher.php line 515 at DispatcherCore->dispatch()in index.php line 28 Link to comment Share on other sites More sharing options...
Mian Waqas Posted July 14, 2020 Share Posted July 14, 2020 when you turn off the debug mode , does it fix the errors? also tell me your Prestashop and PHP version. you can check it in Parameters> information. this error will fix with disabling the posfooter module, but still tell me the above information i think your configs are incorrect Regards Link to comment Share on other sites More sharing options...
Faizan Qureshi Posted July 15, 2020 Author Share Posted July 15, 2020 Below is the information. Link to comment Share on other sites More sharing options...
Faizan Qureshi Posted July 15, 2020 Author Share Posted July 15, 2020 also this file Link to comment Share on other sites More sharing options...
Mian Waqas Posted July 15, 2020 Share Posted July 15, 2020 (edited) 2 hours ago, Faizan Qureshi said: also this file Yes this fine as the debug mode codes are in this file. Did you tried to disable the debug mode? Does the error show in debug mode off? Did you deleted/ renames the dev and prod folders as i mentioned earlier? Did you cleared the cache from back office? These are the basic things you need to do first Edited July 15, 2020 by SMTmardan (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now