Jump to content
roosje

Foutmelding winkelwagen module

Recommended Posts

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.         else
440.             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 method
419.                 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 edit
424.                 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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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