Auto Upgrade Modul DatabaseException Duplicate entry '0' for key 'PRIMARY'

[icarus82]

Dear Prestashop Community

 

As I tried to install the One-Click Upgrade Module there was an error:

 

 

[PrestaShopDatabaseException]

Duplicate entry '0' for key 'PRIMARY'
 

INSERT INTO `ps_tab` (`id_parent`, `position`, `module`, `class_name`, `active`, `hide_host_mode`) VALUES ('17', '9', 'autoupgrade', 'AdminSelfUpgrade', '1', '0')
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 103 - classes/Tab.php] - [2 Arguments]
• TabCore->add - [line 425 - classes/ObjectModel.php] - [2 Arguments]
• ObjectModelCore->save - [line 115 - classes/Tab.php]
• TabCore->save - [line 74 - modules/autoupgrade/autoupgrade.php]
• Autoupgrade->install - [line 805 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->postProcessCallback - [line 1045 - 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]

 

I tried and googled but I could not found a solution. Can someone give me a hint how to solve this problem?

Best regards

Danny

[Krystian Podemski]

Now module appears as installed? If so, have you tried to use the Reset option instead of Install?

[icarus82]

Thank you for your reply! The module does not appear as installed. I also tried to download it manually and install the .zip file but I still get the same message.

[icarus82]

Can anyone please help me?

[icarus82]

I found the solution. 

 

I logged in to mysql panel and took a look at the table "ps_tab". there was an id_tab with value "0". I deleted this entry and activated Autoincrement  for the id_tap. After that I could install the module!

[erfaan]

same problem

can you explain more how you resolve this problem?how you can activated Autoincrement?

[icarus82]

Hi Erfaan

IIRC it was a checkbox I could check, clicked at "ps_tab" on the left and there were some options I could choose. Hope you know what I mean.

If you don't find it I can send you a screenshot.