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!

Join Our Newsletter

* indicates required
We respect your privacy and do not tolerate spam and will never sell, rent, lease or give away your information (name, email, number, etc.) to any third party. Nor will we send you unsolicited email.
Joomla51 - Mullaghmore, Co. Sligo, Ireland
Joomla51.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by
Open Source Matters
the trademark holder in the United States and other countries.