Jump to content

Recommended Posts

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.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]
    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();

 

Share this post


Link to post
Share on other sites

Bonjour,

j'ai le même problème sur ma boutique.

est-ce que vous avez résolu votre problème ?

 

Merci

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More