paradise Posted November 18, 2014 Share Posted November 18, 2014 bonjour a tous j'ai un soucis avec paypal qui ne fonctionne pas quand on clique pour payer rien ne se passe ( lien : javascript:void(0) ) j'ai activé l'affichage des erreurs et voici les erreurs merci de m'aider [PrestaShopDatabaseException]Unknown column 'cp.id_compare' in 'where clause' SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0 at line 635 in file classes/db/Db.php629. 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]Argument [0] SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0 DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]Argument [0] SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0 DbCore->executeS - [line 60 - classes/CompareProduct.php] - [1 Arguments]Argument [0] SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0 CompareProductCore::getCompareProducts - [line 320 - classes/controller/FrontController.php] - [1 Arguments]314. foreach ($languages as $lang)315. $meta_language[] = $lang['iso_code'];316. 317. $compared_products = array();318. if (Configuration::get('PS_COMPARATOR_MAX_ITEM') && isset($this->context->cookie->id_compare))319. $compared_products = CompareProduct::getCompareProducts($this->context->cookie->id_compare);320. 321. $this->context->smarty->assign(array(322. // Usefull for layout.tpl323. 'mobile_device' => $this->context->getMobileDevice(),324. 'link' => $link, FrontControllerCore->init - [line 52 - controllers/front/ParentOrderController.php]46. */47. public function init()48. {49. $this->isLogged = (bool)($this->context->customer->id && Customer::customerIdExistsStatic((int)$this->context->cookie->id_customer));50. 51. parent::init();52. 53. /* Disable some cache related bugs on the cart/order */54. header('Cache-Control: no-cache, must-revalidate');55. header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');56. ParentOrderControllerCore->init - [line 39 - controllers/front/OrderController.php]33. */34. public function init()35. {36. global $orderTotal;37. 38. parent::init();39. 40. $this->step = (int)(Tools::getValue('step'));41. if (!$this->nbProducts)42. $this->step = -1; 43. OrderControllerCore->init - [line 163 - classes/controller/Controller.php]157. /**158. * Start controller process (this method shouldn't be overriden !)159. */160. public function run()161. {162. $this->init();163. if ($this->checkAccess())164. {165. // setMedia MUST be called before postProcess166. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))167. $this->setMedia(); ControllerCore->run - [line 373 - classes/Dispatcher.php]367. // Execute hook dispatcher368. if (isset($params_hook_action_dispatcher))369. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);370. 371. // Running controller372. $controller->run();373. }374. catch (PrestaShopException $e)375. {376. $e->displayMessage();377. } DispatcherCore->dispatch - [line 28 - index.php]22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)23. * International Registered Trademark & Property of PrestaShop SA24. */25. 26. require(dirname(__FILE__).'/config/config.inc.php');27. Dispatcher::getInstance()->dispatch(); Link to comment Share on other sites More sharing options...
saxomax Posted December 10, 2014 Share Posted December 10, 2014 Bonjour, j'ai le même problème sur ma boutique. est-ce que vous avez résolu votre problème ? Merci Link to comment Share on other sites More sharing options...
Olivier CLEMENCE Posted December 11, 2014 Share Posted December 11, 2014 Il faut regarder dans la base de données si dans la table "ps_compare" il y a bien la colonne id_compare. A priori d'après le message d'erreur elle est manquante. 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