Duplicate entry '1-2147483647' for key 'id_ebay_profile'

[zdarbilo]

Bonjour a tous voila depuis la mise a jour du module ebay j'ai ce message d'erreur :

 

 

[PrestaShopDatabaseException]

Duplicate entry '1-2147483647' for key 'id_ebay_profile'
 

INSERT INTO `ps_ebay_store_category` (`id_ebay_profile`, `ebay_category_id`, `name`, `order`, `ebay_parent_category_id`) VALUES ('1', '2147483647', 'LG', '1', '2147483647')
at line 635 in file classes/db/Db.php

 

629.             WebserviceRequest::getInstance()->setError(500, '

 '.$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]
• DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
• DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]
• DbCore->insert - [line 464 - classes/ObjectModel.php] - [3 Arguments]
• ObjectModelCore->add - [line 425 - classes/ObjectModel.php] - [2 Arguments]
• ObjectModelCore->save - [line 152 - modules/ebay/classes/EbayStoreCategory.php]
• EbayStoreCategory::_writeStoreCategory - [line 156 - modules/ebay/classes/EbayStoreCategory.php] - [3 Arguments]
• EbayStoreCategory::_writeStoreCategory - [line 133 - modules/ebay/classes/EbayStoreCategory.php] - [2 Arguments]
• EbayStoreCategory::updateStoreCategoryTable - [line 1136 - modules/ebay/ebay.php] - [2 Arguments]
• Ebay->getContent - [line 803 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->postProcessCallback - [line 1043 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

j'ai désinstaller et réinstaller mais sans succès j'ai meme supprimer puis recharger le module mais ça n'a pas marché, j'ai aussi supprimer les entrés dans la table en question mais le problème revient merci de m'aider si vous le pouvez.

[Motuman]

Bonjour,

 

I have the same problem here.

 

Working on PrestaShop™ 1.5.6.1 with the latest update of the Ebay Module.

Problem has just occured...

 

Any ideas or help would be appreciated.

 

Cordialement,

Carsten

 

 

[cockpitinferno]

same for me, anyone?

[zdarbilo]

try to uninstall module after this delete all table ebay from database

[cockpitinferno]

i installed an older version, 1.8 and it's fine

[vekia]

anyway, if someone will have the same problem - in this case to fix it it is necessary to alter database datas.

in table ps_ebay_store_category it's necessary to remove entry mentioned in error code.

in this case it's:
[PrestaShopDatabaseException]

Duplicate entry '1-2147483647' for key 'id_ebay_profile'

[raken]

Hi,

After delete this entry.
I reload.. and this entry come back.

Other solutions ?

[nosfevil]

where i have to delete this entry? In my sql?