Errors after updating Prestashop from version 1.7.8.9 to version 1.7.8.10

[sylwekb]

Hallo

There are errors after updating to the latest version of Prestashop from version 1.7.8.9 to version 1.7.8.10. What do I need to correct in the code? I don't see newer versions of the modules. Of course, I will restore from a backup to the previous version

 

 

 (1/1) ContextErrorException

Notice: Trying to access array offset on value of type null
in 3d9e1341720a6e6b7f2b2998794f676fc87816d7_2.file.category.tpl.php line 50
at Block_177968018064d3512eefc3a1_21293016->callBlock(object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 248
at Smarty_Internal_Runtime_Inheritance->callBlock(object(Block_177968018064d3512eefc3a1_21293016), object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 184
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_177968018064d3512eefc3a1_21293016), object(Block_214343648064d3512ef01962_52817553))in smarty_internal_runtime_inheritance.php line 186
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_214343648064d3512ef01962_52817553))in smarty_internal_runtime_inheritance.php line 156
at Smarty_Internal_Runtime_Inheritance->instanceBlock(object(SmartyDevTemplate), 'Block_214343648064d3512ef01962_52817553', 'product_list_header', 1)in 2d3e72e7edc94b2fea5a3920ecb776278291943c_2.file.product-list.tpl.php line 136
at Block_82142647064d3512ef015d4_35677284->callBlock(object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 248
at Smarty_Internal_Runtime_Inheritance->callBlock(object(Block_82142647064d3512ef015d4_35677284), object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 184
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_82142647064d3512ef015d4_35677284), object(Block_130663462564d3512ef0bdf0_60071952))in smarty_internal_runtime_inheritance.php line 186
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_130663462564d3512ef0bdf0_60071952))in smarty_internal_runtime_inheritance.php line 156
at Smarty_Internal_Runtime_Inheritance->instanceBlock(object(SmartyDevTemplate), 'Block_130663462564d3512ef0bdf0_60071952', 'content', 2)in c258838b19530358550d3d41de4027b4f55059ed_2.file.layout-left-column.tpl.php line 84
at Block_192751787564d3512ef0b5d4_53976330->callBlock(object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 248
at Smarty_Internal_Runtime_Inheritance->callBlock(object(Block_192751787564d3512ef0b5d4_53976330), object(SmartyDevTemplate))in smarty_internal_runtime_inheritance.php line 184
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_192751787564d3512ef0b5d4_53976330), object(Block_117701774064d3512ef15cb8_50606329))in smarty_internal_runtime_inheritance.php line 186
at Smarty_Internal_Runtime_Inheritance->process(object(SmartyDevTemplate), object(Block_117701774064d3512ef15cb8_50606329))in smarty_internal_runtime_inheritance.php line 156
at Smarty_Internal_Runtime_Inheritance->instanceBlock(object(SmartyDevTemplate), 'Block_117701774064d3512ef15cb8_50606329', 'content_wrapper')in 41427cf4e8a1622b928984dc3abee491eb6a97e7_2.file.layout-both-columns.tpl.php line 95
at content_64d3512ef1cc63_69804202(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, 'apparel-sportslayouts/layout-left-column.tpl', 0, 3600, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 116
at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-both-columns.tpl')in c258838b19530358550d3d41de4027b4f55059ed_2.file.layout-left-column.tpl.php line 38
at content_64d3512ef0c9c9_32798093(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-left-column.tpl', null, 'apparel-sportslayouts/layout-left-column.tpl', 0, 3600, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 116
at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'layouts/layout-left-column.tpl')in 2d3e72e7edc94b2fea5a3920ecb776278291943c_2.file.product-list.tpl.php line 37
at content_64d3512ef08a29_58915774(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('catalog/listing/product-list.tpl', null, 'apparel-sportslayouts/layout-left-column.tpl', 0, 3600, array(), 2, false, null, null)in smarty_internal_runtime_inheritance.php line 116
at Smarty_Internal_Runtime_Inheritance->endChild(object(SmartyDevTemplate), 'catalog/listing/product-list.tpl')in 3d9e1341720a6e6b7f2b2998794f676fc87816d7_2.file.category.tpl.php line 34
at content_64d3512eeff240_66572481(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, 'apparel-sportslayouts/layout-left-column.tpl', null, 0)in smarty_internal_templatebase.php line 116
at Smarty_Internal_TemplateBase->fetch('catalog/listing/category.tpl', null, 'apparel-sportslayouts/layout-left-column.tpl', null, false, true, false)in SmartyDev.php line 40
at SmartyDev->fetch('catalog/listing/category.tpl', null, 'apparel-sportslayouts/layout-left-column.tpl')in FrontController.php line 727
at FrontControllerCore->smartyOutputContent('catalog/listing/category.tpl')in FrontController.php line 709
at FrontControllerCore->display()in Controller.php line 326
at ControllerCore->run()in Dispatcher.php line 525
at DispatcherCore->dispatch()in index.php line 28





[PrestaShopDatabaseException]

Unknown column 'pc.id_shop' in 'where clause'<br /><br /><pre> SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 77 AND pc.`id_shop` = 1 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1</pre>
at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $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 663 - classes/db/Db.php] - [1 Arguments]
    DbCore->getRow - [line 207 - modules/myprestacomments/MyprestaComment.php] - [1 Arguments]
    MyprestaComment::getAverageGrade - [line 1233 - modules/myprestacomments/myprestacomments.php] - [1 Arguments]
    myprestacomments->hookDisplayProductListReviews - [line 1007 - classes/Hook.php] - [1 Arguments]

 

 

[endriu107]

Try reinstall myprestacomments module.

[Rhobur]

Or uninstalling it first to check if the error's gone...

[ccristian]

Hi!

Not the same issue like sylwekb, but I am facing with an issue too.

Missing the update button when triyng to upgrade from version 1.7.8.9 to 1.7.8.10, using the 1 Click-upgrade module (version 4.16.2).

Even if I put the store into mentainance mode, the 1 Click-upgrade module won't let me install the new version becouse the upgrade/update button is missing...... Error: PrestaShop requirements are not satisfied.

Does anyone know how I can solve this?

Thank you!

 

[ccristian]

3 minutes ago, ccristian said:

Hi!

Not the same issue like sylwekb, but I am facing with an issue too.

Missing the update button when triyng to upgrade from version 1.7.8.9 to 1.7.8.10, using the 1 Click-upgrade module (version 4.16.2).

Even if I put the store into mentainance mode, the 1 Click-upgrade module won't let me install the new version becouse the upgrade/update button is missing...... Error: PrestaShop requirements are not satisfied.

Does anyone know how I can solve this?

Thank you!

 

Solved, I didn't add the IP into Maintenance mode field. God bless you!