roosje Posted March 23, 2016 Share Posted March 23, 2016 Hi, Ik hoop heel erg dat jullie mij kunnen helpen! Ik maak gebruik van 1.5.4.0 en in ene werkt mijn winkelwagen module niet meer, ik heb helemaal niets aan de site aangepast of updates gedaan.. Ben al dagen er mee bezig, maar krijg hem niet aan de praat.. Kan iemand asjeblieft helpen? Mijn foutmelding: ble to add the product to the cart.textStatus: 'error'errorThrown: 'Internal Server Error'responseText:<style> #psException{font-family: Verdana; font-size: 14px} #psException h2{color: #F20000} #psException p{padding-left: 20px} #psException ul li{margin-bottom: 10px} #psException a{font-size: 12px; color: #000000} #psException .psTrace, #psException .psArgs{display: none} #psException pre{border: 1px solid #236B04; background-color: #EAFEE1; padding: 5px; font-family: Courier; width: 99%; overflow-x: auto; margin-bottom: 30px;} #psException .psArgs pre{background-color: #F1FDFE;} #psException pre .selected{color: #F20000; font-weight: bold;} </style><div id="psException"><h2>[PrestaShopDatabaseException]</h2><p><b>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2016-03-23 13:39:44')' at line 2<br /><br /><pre> INSERT INTO `ps_prestafraud_carts` (`id_cart`, `ip_address`, `date`) VALUES (673, ,'2016-03-23 13:39:44')</pre></b><br /><i>at line </i><b>607</b><i> in file </i><b>classes/db/Db.php</b></p><div class="psTrace" id="psTrace_" style="display: block"><pre>601. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. }603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))604. {605. if ($sql)<span class="selected">606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');</span>607. throw new PrestaShopDatabaseException($this->getMsgError());608. }609. }610.611. /**</pre></div><ul><li><b>DbCore->displayError</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_0').style.display = (document.getElementById('psTrace_0').style.display != 'block') ? 'block' : 'none'; return false">[line 307 - classes/db/Db.php]</a> - <a href="#" onclick="document.getElementById('psArgs_0').style.display = (document.getElementById('psArgs_0').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_0" ><pre>301. if ($sql instanceof DbQuery)302. $sql = $sql->build();303.304. $this->result = $this->_query($sql);305. if (_PS_DEBUG_SQL_)<span class="selected">306. $this->displayError($sql);</span>307. return $this->result;308. }309.310. /**311. * Execute an INSERT query</pre></div><div class="psArgs" id="psArgs_0"><pre><b>Argument [0]</b> INSERT INTO `ps_prestafraud_carts` (`id_cart`, `ip_address`, `date`) VALUES (673, ,'2016-03-23 13:39:44')</pre></li><li><b>DbCore->query</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_1').style.display = (document.getElementById('psTrace_1').style.display != 'block') ? 'block' : 'none'; return false">[line 447 - classes/db/Db.php]</a> - <a href="#" onclick="document.getElementById('psArgs_1').style.display = (document.getElementById('psArgs_1').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_1" ><pre>441. public function execute($sql, $use_cache = true)442. {443. if ($sql instanceof DbQuery)444. $sql = $sql->build();445.<span class="selected">446. $this->result = $this->query($sql);</span>447. if ($use_cache && $this->is_cache_enabled)448. Cache::getInstance()->deleteQuery($sql);449. return (bool)$this->result;450. }451.</pre></div><div class="psArgs" id="psArgs_1"><pre><b>Argument [0]</b> INSERT INTO `ps_prestafraud_carts` (`id_cart`, `ip_address`, `date`) VALUES (673, ,'2016-03-23 13:39:44')</pre></li><li><b>DbCore->execute</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_2').style.display = (document.getElementById('psTrace_2').style.display != 'block') ? 'block' : 'none'; return false">[line 443 - modules/prestafraud/prestafraud.php]</a> - <a href="#" onclick="document.getElementById('psArgs_2').style.display = (document.getElementById('psArgs_2').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_2" ><pre>437. SET `ip_address` = '.ip2long($_SERVER['REMOTE_ADDR']).', `date` = \''.pSQL(date('Y-m-d H:i:s')).'\'438. WHERE `id_cart` = '.(int)$params['cart']->id.' LIMIT 1');439. else440. Db::getInstance()->execute('441. INSERT INTO `'._DB_PREFIX_.'prestafraud_carts` (`id_cart`, `ip_address`, `date`)<span class="selected">442. VALUES ('.(int)$params['cart']->id.', '.ip2long($_SERVER['REMOTE_ADDR']).',\''.date('Y-m-d H:i:s').'\')');</span>443. return true;444. }445. 446. private function _getCustomerInfos($order)447. {</pre></div><div class="psArgs" id="psArgs_2"><pre><b>Argument [0]</b> INSERT INTO `ps_prestafraud_carts` (`id_cart`, `ip_address`, `date`) VALUES (673, ,'2016-03-23 13:39:44')</pre></li><li><b>PrestaFraud->hookCart</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_3').style.display = (document.getElementById('psTrace_3').style.display != 'block') ? 'block' : 'none'; return false">[line 423 - classes/Hook.php]</a> - <a href="#" onclick="document.getElementById('psArgs_3').style.display = (document.getElementById('psArgs_3').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_3" ><pre>417.418. // Call hook method419. if ($hook_callable)420. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);421. else if ($hook_retro_callable)<span class="selected">422. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);</span>423. // Live edit424. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))425. {426. $live_edit = true;427. $output .= self::wrapLiveEdit($display, $moduleInstance, $array['id_hook']);</pre></div><div class="psArgs" id="psArgs_3"><pre><b>Argument [0]</b>Array( [cookie] => Cookie Object ( [_content:protected] => Array ( [date_add] => 2016-01-12 14:07:59 [id_lang] => 2 [id_currency] => 1 [viewed] => 51,87,285 [no_mobile] => 1 [last_visited_category] => 8 [id_wishlist] => 5 [id_guest] => 235748 [id_connections] => 227447 [checksum] => 2942256380 ) [_name:protected] => ab432cf613bf5f10e4cd11c28777c559 [_expire:protected] => 1460464784 [_domain:protected] => www.hipperoza.nl [_path:protected] => / [_cipherTool:protected] => Rijndael Object ( [_key:protected] => xXRRxYUaZcbx4Zby9MtxSKvoxIausUr2 [_iv:protected] => Vd֮g+)p ) [_key:protected] => ZXtBQTzmokovBsLIa0FT4ZGXTvOha3mLyWhethbaFNCXKIE6fgeqZSGo [_iv:protected] => AzrADTyF [_modified:protected] => [_allow_writing:protected] => 1 ) [cart] => Cart Object ( [id] => 673 [id_shop_group] => 1 [id_shop] => 1 [id_address_delivery] => 0 [id_address_invoice] => 0 [id_currency] => 1 [id_customer] => [id_guest] => 235748 [id_lang] => 2 [recyclable] => 0 [gift] => 0 [gift_message] => [mobile_theme] => [date_add] => 2016-03-23 13:39:44 [secure_key] => [id_carrier] => 0 [date_upd] => 2016-03-23 13:39:44 [checkedTos] => [pictures] => [textFields] => [delivery_option] => [allow_seperated_package] => [_products:protected] => [_taxCalculationMethod:protected] => 0 [webserviceParameters:protected] => Array ( [fields] => Array ( [id_address_delivery] => Array ( [xlink_resource] => addresses ) [id_address_invoice] => Array ( [xlink_resource] => addresses ) [id_currency] => Array ( [xlink_resource] => currencies ) [id_customer] => Array ( [xlink_resource] => customers ) [id_guest] => Array ( [xlink_resource] => guests ) [id_lang] => Array ( [xlink_resource] => languages ) ) [associations] => Array ( [cart_rows] => Array Ps: de website is www.hipperoza.nl Link to comment Share on other sites More sharing options...
musicmaster Posted March 24, 2016 Share Posted March 24, 2016 ps_prestafraud_carts is geen standaard Prestashop module. Het is dus een addon die niet meer werkt en omdat dat zo specialistisch is ontkom je er niet aan om de leverancier van die module om raad te vragen. Voorlopig zou ik de module uitzetten: dan ben je waarschijnlijk van het probleem af. Link to comment Share on other sites More sharing options...
Recommended Posts