1. Fennec
  2. Commercial Templates
  3. Monday, 19 January 2026
  4.  Subscribe via email
I installed the NINA demo but It gave an error

Error
"Duplicate entry '700-5.3.0-2025-03-14' for key 'PRIMARY'"

The site is there - but I cannot enter as administrator as the username/password I entered does not work

Warning
"Username and password do not match or you do not have an account yet."

Any fixes are more than welcome.

Thanks
Attachments (1)
Accepted Answer Pending Moderation
0
Votes
Undo
Hello,

do you have access to the database?
Accepted Answer Pending Moderation
0
Votes
Undo
Yes - through Plesk
Accepted Answer Pending Moderation
0
Votes
Undo
Okay, it seems to me that there is an error in the database.
Accepted Answer Pending Moderation
0
Votes
Undo
That is clear, It was a clean install, new database, any suggestions?
Accepted Answer Pending Moderation
0
Votes
Undo
Which Joomla and PHP versions?
Accepted Answer Pending Moderation
0
Votes
Undo
Joomla 5.3.3, (as delivered with the NINA demo) , PHP 8.4.15 (latest)
Accepted Answer Pending Moderation
0
Votes
Undo
Have you tried a different PHP version?
Accepted Answer Pending Moderation
0
Votes
Undo
In Nina QuickStart, an SQL file is executed during the import process, inserting a duplicate entry into #__schemas, thus creating an existing entry. This causes the import to fail with a duplicate key error.

The affected file in the QuickStart package is:

installation/sql/mysql/custom.sql


It contains (around line 1895 in my case) the following statement:


INSERT INTO `#__schemas` VALUES (21,'5.0.0-2023-09-11'),(700,'5.3.0-2025-03-14'),(1254,'3.5.1');


The part (700,'5.3.0-2025-03-14') is the culprit.


Solution: In the file installation/sql/mysql/custom.sql, remove the entry for 700:

Before:


INSERT INTO `#__schemas` VALUES (21,'5.0.0-2023-09-11'),(700,'5.3.0-2025-03-14'),(1254,'3.5.1');


After:


INSERT INTO `#__schemas` VALUES (21,'5.0.0-2023-09-11'),(1254,'3.5.1');


Then reinstall QuickStart (ideally with a completely empty/new database), and the installation should complete successfully.

Best regards
Accepted Answer Pending Moderation
0
Votes
Undo
Will give it a go - thanks
Accepted Answer Pending Moderation
0
Votes
Undo
Worked perfectly - thanks!
Accepted Answer Pending Moderation
0
Votes
Undo
Great :)
  • Page :
  • 1


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