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...
roosje Posted March 24, 2016 Author Share Posted March 24, 2016 Klopt het is de officiele, gek toch dat daar in ene een fout in komt? ik heb hem nu uit gezet. Bedankt voor je hulp! 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