Prestashopdatabaseexception

[difust]

Buenas tardes,

 

Despues de actualizar prestashop actualmente en 1.6.0.6.

 

Al intentar entrar desde el backoffice a una cuenta de cliente me lanza un mensaje de error.

 

Table 'difust160.ps_approvedcustomer' doesn't exist
 

			SELECT *			FROM `ps_approvedcustomer` ac			WHERE ac.`id_customer` = 195 and ac.`is_approved` = 0

at line 635 in file classes/db/Db.php

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. 		}631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. 		{633. 			if ($sql)634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. 			throw new PrestaShopDatabaseException($this->getMsgError());636. 		}637. 	}638. 639. 	/**

• DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 58 - modules/customerregistration/ApprovedCustomer.php] - [1 Arguments]
• ApprovedCustomer::isApproved - [line 156 - modules/customerregistration/customerregistration.php] - [1 Arguments]
• customerRegistration->hookAdminCustomers - [line 509 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 188 - config/smarty.config.inc.php] - [3 Arguments]
• smartyHook - [line - ] - [2 Arguments]
• call_user_func_array - [line 241 - config/smarty.config.inc.php] - [2 Arguments]
• SmartyLazyRegister->__call - [line 804 - cache/smarty/compile/0d/00/0e/0d000e8311af6d92adf971f2fee9b360ecee9369.file.view.tpl.php] - [2 Arguments]
• SmartyLazyRegister->smartyHook - [line 804 - cache/smarty/compile/0d/00/0e/0d000e8311af6d92adf971f2fee9b360ecee9369.file.view.tpl.php] - [2 Arguments]
• content_56d9a75c6b4487_82008202 - [line 180 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
• Smarty_Internal_TemplateBase->fetch - [line 114 - classes/helper/Helper.php]
• HelperCore->generate - [line 59 - classes/helper/HelperView.php]
• HelperViewCore->generateView - [line 1995 - classes/controller/AdminController.php]
• AdminControllerCore->renderView - [line 820 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->renderView - [line 1749 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 190 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

Me podeis ayudar ??

 

gracias

 

[PrestashopTrackglobe]

Hola,

 

El error lo da en el módulo customerregistration que tienes instalado puesto que falta una tabla en la base de datos. Mi recomendación es que desde el administrador lo desinstales y lo vuelvas a instalar y configurar para solucionar este problema.

 

Un saludo.