[Solved] Installing Theme Gives ‘Duplicate Entry’ Error – What Does This Mean?

[Skazz]

Hi guys, I’m trying to install the theme ‘Show Me The Dvd 1.6’ onto my newly updated prestashop shop and had some issues due to the version on php my server was using. That dealt with, now when I try to ‘use this theme’ in backoffice, I get an error thrown up:

 

Duplicate entry '69-0-1' for key 'PRIMARY'

INSERT INTO `ps_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`)

                                                                                                                                                VALUES (69, 1, 0, 1)

 

I am not familiar with sql but I get the impression that this indicates that there is another installed module from my previous theme using the position that one of the modules that wants to be installed for this new theme is currently occupying? Is this the case? If so, I have no idea how to find out which module this is and therefore move it or disable it. I also have no idea how to work around this in sql either – like I said, I know nothing about it! If anyone can help, I’d be delighted, elsewise I can feel we’re going to end up deleting the whole store and starting from scratch in order to update and change theme.  Thanks so much in advance!

Kat

 

Edit: Unable to solve this issue, I tried with a fresh install of prestashop and these issues were gone, however replaced by new ones! However, it would seem that in this error, there were some conflicts but I was never able to pin down what they were. Sorry!

Edited December 5, 2015 by Skazz (see edit history)

[Krystian Podemski]

Many times it's related to some problems with "Dashboard" module, try to reinstall this module

[Skazz]

Hi, thanks for the advice, I only have 4 Dashboard modules installed; Dashboard Activity v0.5.0, Dashboard Goals v0.7.0, Dashboard Products v0.3.5 and Dashboard Trends v0.8.1. I tried uninstalling them all, separately and all together and also reinstalled them - sadly, I got the same error at each stage Any other suggestions more than welcome though, thanks for your help!

 

Kat

 

 

 

[aojopi]

With phpmyadmin, look for the id_module in the table ps_module to get the module name, 69 in your error message, and uninstall the module from the Prestashop admin panel.

 

Alvaro