No Chance To Update To Joomla 4.0 // Jinstaller: :install: Sql-fehler Duplicate Entry '1' For Key 'primary' - Forum | JoomShaper
Staff replied General

No Chance To Update To Joomla 4.0 // Jinstaller: :install: Sql-fehler Duplicate Entry '1' For Key 'primary'

Asked by Joerg Distler 4 years ago Last activity 4 years ago

Hi,
I updated many sites to joomla 4.1.2 from 3 ... .
But at the last site there is no chance.
After the update th front and backend have a mistake.

Infomation:

JInstaller: :Install: SQL-Fehler Duplicate entry '1' for key 'PRIMARY'

What can I do?

24 replies

Oldest first Newest first Most helpful
Joerg Distler Asked this
4 years ago

I can send you akeeba backup, so you can see.

Ariba Staff
4 years ago · edited

Hello

Apologies for the inconvenience. This kind of error actually means that you have been migrated to a database where fragments from previous unsuccessful attempts may remain. Can you try using a new database or clean the old one when restoring after unsuccessful attempts?

If you are testing the Joomla 4 upgrade, and you test and re-test on the same database, kindly make sure that you delete everything between each test.

Otherwise, the installer re-creates and re-inserts the same records on the tables that were created in the previous test, and then it fails with the error that you mentioned: "JInstaller: :Installer: Found SQL Duplicate entry '1' for key 'Primary'"

Additionally, if there was a previous failed attempt to upgrade to Joomla 4, there could be inconsistencies in the tables too.

Joerg Distler Asked this
4 years ago

Hello,

I made a new Database more times. But I does not help.
Can you help me?
Best jörg

Joerg Distler Asked this
4 years ago

Hi Ariba,

once again. I try more times more, but there is a mistake. Can you check it?
The last days, I update more sites... . But here is a big problem and I do not know, what can I do...
Best Joerg

Ariba Staff
4 years ago

Hello

Please share the Akeeba Backup here in ZIP format.

Joerg Distler Asked this
4 years ago · edited

Hi Ariba!

Thank you!
Here you find the Link.
Best Joerg

Joerg Distler Asked this
4 years ago

Hi Ariba,

how are you? Have you some news for me about the mistake?
Best Jörg

Toufiq Senior Staff
4 years ago

Hi there,

Sorry for the inconvenience. Will you please provide me the Joomla administrator access to check the issue? I will check & get back to you soon. 

-Thanks

Joerg Distler Asked this
4 years ago

Hello!

For your information. I have completely changed the site now from Floox to Template helix.

There are now already created about 20 attempts.... .

I also put a jpa. File to the check to the download ready ...
Thanks for your help.

Best Jörg

Toufiq Senior Staff
4 years ago

Do you know how to unarchive JPA file? I don't have any idea.

Log in to reply.