• Priority: 0
  • Status: Closed
  • Theme: Venedor
  • Assigned To: Alex
  • Private: No
  • Open Date: 19.04.16, 14:51
  • Opened by: Emilie
  • Closed by: Alex
  • Closed on: 06.05.16, 14:14
  • Reason: Closed
  • Comment: Glad to help!

Ticket #9475 - I can´t install. Duplicate entry mesage

When trying to intall I get this error message:

Duplicate entry ‘93-0-1’ for key ‘PRIMARY’

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

Comments

Emilie 19 Apr 2016, 14:51

What can I do?

Marek 20 Apr 2016, 11:00

Hi Emilia.
Sorry for the delay.
Please fill access details to your back office in your profile https://support.promokit.eu/index.php?do=myprofile and I’ll try to install it for you.

Emilie 20 Apr 2016, 11:04

It´s on my localhost (on my computer)…

Marek 20 Apr 2016, 11:05

Ok, try to reinstall prestahop. You need to start with clean database

Emilie 20 Apr 2016, 11:11

OK, thanks. I´ll try it.

Emilie 20 Apr 2016, 19:41

Yep. I could install the theme on a fresh installation, now a new problem facing:

On the frontend it doesn´t load the styles (see screenshot) and if I active the debug mode that it´s what it said:
[PrestaShopDatabaseException]

Table ‘usdg78511produec.xl_wishlist’ doesn’t exist

SELECT `id_wishlist` FROM `xl_wishlist` WHERE `id_customer` = 0

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 643 - classes/db/Db.php] - [1 Arguments]
DbCore→executeS - [line 440 - modules/pk_productscarousel/pk_productscarousel.php] - [1 Arguments]
pk_productscarousel→getUserWishlists - [line 361 - modules/pk_productscarousel/pk_productscarousel.php] - [3 Arguments]
pk_productscarousel→hookDisplayHome - [line 587 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 40 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore→initContent - [line 189 - classes/controller/Controller.php]
ControllerCore→run - [line 367 - classes/Dispatcher.php]
DispatcherCore→dispatch - [line 28 - index.php]

Please help I need to instal it shortly.

Marek 21 Apr 2016, 12:35

1. Do you have enables “Smart CSS” on the performance page?
2. Please enable “Wishlist” module

Emilie 22 Apr 2016, 14:32

Hi!

1. Yes, it is enabled.
2. I can´t find any wishlist module…

Thanks

Marek 23 Apr 2016, 11:26

ok, it seems an issues with “pk_productscarousel” module. Try to disable it.

Emilie 06 May 2016, 11:25

Solved, It was the wishlist module. It wasn´t installed. Thanks!