Error on checking out

[Morne McCartney]

Hi all

I am very new to Prestashop.  I installed the software and everything was working fine, but at some point, my customers could not longer check out.

I switched to debug mode and got the following error:-

Could anyone please assist me in the right direction to find the error, please as I have exhausted my meager knowledge to try to find the cause of the error.

----------------------------------------------------------------------------------------------------------------------------------------

[PrestaShopDatabaseException]

Unknown column 'prl.id_shop' in 'where clause'<br /><br /><pre>SELECT * FROM `pres_psreassurance` pr LEFT JOIN pres_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance) WHERE prl.id_lang = "1" AND prl.id_shop = "1" AND pr.status = 1 ORDER BY pr.position</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 613 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 186 - modules/blockreassurance/classes/ReassuranceActivity.php] - [1 Arguments]

ReassuranceActivity::getAllBlockByStatus - [line 493 - modules/blockreassurance/blockreassurance.php] - [2 Arguments]

blockreassurance->renderTemplateInHook - [line 385 - modules/blockreassurance/blockreassurance.php] - [1 Arguments]

blockreassurance->hookdisplayReassurance - [line 1007 - classes/Hook.php] - [1 Arguments]

----------------------------------------------------------------------------------------------------------------------------------------

[Prestachamps]

Hello,
Please try to reset the blockreassurance module, or update it.
I hope that it could help.
Have a nice day, Leo.

[Morne McCartney]

Thank you, so much Leo.  It was exactly the issue.

Morné