Hello,

do you have access to the database?

Yes - through Plesk

Okay, it seems to me that there is an error in the database.

That is clear, It was a clean install, new database, any suggestions?

Which Joomla and PHP versions?

Joomla 5.3.3, (as delivered with the NINA demo) , PHP 8.4.15 (latest)

Have you tried a different PHP version?

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

Will give it a go - thanks

Worked perfectly - thanks!

Great

Hi z0r0z,

I bought Nina a few days ago and encountered the same issue so I followed your instruction.

I have change line 1895 into

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

But now I am getting error "Duplicate entry '443-8' for key 'PRIMARY'" in a new database (PHP 8.3.30).

Any suggestions?


Best regards
Ed

Hi Ed,

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

installation/sql/mysql/custom.sql

The relevant line in your package is 2441:

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

The primary key of this table is (user_id, group_id) – and (443,8) already exists in your import → hence the "duplicate entry '443-8'".


Change line 2441 from:

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

Regarding:

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

This ensures duplicate mappings are skipped and the import runs smoothly.

Best regards

Worked perfectly

Thnx Ed