Problem adding product to cart (at line 791 in file classes/db/Db.php)

[nacxo]

Impossible to add the product to the cart.
textStatus: 'error'
errorThrown: 'Internal Server Error'
responseText:

[PrestaShopDatabaseException]

Duplicate entry '0' for key 'PRIMARY'
 

INSERT INTO `ps_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('1', '1', '0', '0', '0', '1', '0', '2114133', '1', '0', '0', '', '0', '', '', '0', '2016-09-15 09:42:39', '2016-09-15 09:42:39')

at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 763 - classes/db/Db.php] - [1 Arguments]
• DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments]
• DbCore->insert - [line 487 - classes/ObjectModel.php] - [3 Arguments]
• ObjectModelCore->add - [line 196 - classes/Cart.php] - [2 Arguments]
• CartCore->add - [line 279 - controllers/front/CartController.php]
• CartControllerCore->processChangeProductInCart - [line 73 - controllers/front/CartController.php]
• CartControllerCore->postProcess - [line 178 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

Edited September 15, 2016 by nacxo (see edit history)

[greenabz]

I have the same problem... please help...