1. ecweb
  2. Sherlock Holmes
  3. Commercial Templates
  4. Wednesday, 18 May 2022
  5.  Subscribe via email
Hi,
When I try to install the joomla 4 demo installer of j51_emani I get the following error after entering the database credentials:
Duplicate entry '31-8' for key 'PRIMARY'
This is to an empty database.
What should I do to solve it?
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

I have just updated the Joomla 4 demo installer for the Emani template to the latest Joomla 4 version (4.1.3) which should resolve any issues. To obtain simply redownload your template from your Joomla51 Template Downloads.

Ciaran
  1. more than a month ago
  2. Commercial Templates
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
Hi I have the same problem with the theme Jasmine (Duplicate entry '46-8' for key 'vch7p_user_usergroup_map.PRIMARY').
Version: 1.1.15. Please help, thank you
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Webmasto,

in this Jasmine Quickstart guide, the error is specifically located in the file:

installation/sql/mysql/custom.sql


The relevant line in your package is 2344:


INSERT INTO `#__user_usergroup_map` VALUES (...,(443,8),...);


The primary key of this table is (user_id, group_id), so if (443,8) already exists during import, Joomla throws the error:

Duplicate entry '443-8' for key 'PRIMARY'

A simple workaround is to change:


INSERT INTO `#__user_usergroup_map` VALUES (...,(443,8),...);


to:


INSERT IGNORE INTO `#__user_usergroup_map` VALUES (...,(443,8),...);


This way, duplicate mappings are skipped and the installation can continue.

Best regards
Accepted Answer Pending Moderation
0
Votes
Undo
Grazie mille
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!