No Chance To Update To Joomla 4.0 // Jinstaller: :install: Sql-fehler Duplicate Entry '1' For Key 'primary' - Question | JoomShaper
🎃 Halloween Sale is Live! Get 35% OFF on all plans. Sale ends soon! Get Offer

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

JD

Joerg Distler

General 3 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?

0
24 Answers
JD
Joerg Distler
Accepted Answer
3 years ago #65251

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

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #65252

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.

0
JD
Joerg Distler
Accepted Answer
3 years ago #65253

Hello,

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

0
JD
Joerg Distler
Accepted Answer
3 years ago #65255

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

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #65256

Hello

Please share the Akeeba Backup here in ZIP format.

0
JD
Joerg Distler
Accepted Answer
3 years ago #65257

Hi Ariba!

Thank you! Here you find the Link. Best Joerg

0
JD
Joerg Distler
Accepted Answer
3 years ago #65534

Hi Ariba,

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #65713

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

0
JD
Joerg Distler
Accepted Answer
3 years ago #65830

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #65931

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

0
JD
Joerg Distler
Accepted Answer
3 years ago #65938

Hello Toufig,

I take the kickstart.php and the englisch language pack on the server or you download it at akkeba.

The kickstart only works at this moment at php 7, 4 not at php 8,0 ... I try yesterday ...

More information directly from akkeba. Thank you for your buisness.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #65965

Yes, I also found this issue. But, I don't think this issue occurred for our product. Thanks

0
JD
Joerg Distler
Accepted Answer
3 years ago #65974

Hello Toufiq,

I thought that you could use this to set up the website on a xampp server and find the error. If this service can not take place I have to completely rebuild the page.. .

Thanks. Jörg

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #65984

Please check the latest backup

0
JD
Joerg Distler
Accepted Answer
3 years ago #65994

Hi!

Update is done ... Same problem..

After update there is the first information.

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

Joomla!-Versionsaktualisierungsstatus Hinweis Die Site wurde aktualisiert. Die neue Joomla!-Version ist jetzt: ‎4.1.2.

Backend is "damaged".

You can see on the admin ...

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #66096

Did you try new install or did you try update on your existing?

0
JD
Joerg Distler
Accepted Answer
3 years ago #66151

Hello Toufig, The site is broken after an update from an exsiting Joomla 3 to Joomla 4 site. The jpa file is a copy of the site.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #66156

Download this zip file and run on your localhost first. If you think this package is works fine. Then you can move it live server.

https://drive.google.com/file/d/16fMwHR2ZAa3yctnP5rn7zm6YlwB7ijQj/view?usp=sharing

0
JD
Joerg Distler
Accepted Answer
3 years ago #66181

Hi Toufiq! Please read hidden Content. Best Jörg

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #66252
0
JD
Joerg Distler
Accepted Answer
3 years ago #66258

Hi Toufiq,

thank you for your e-mail. Please find the file on the server. Best Jörg

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #66388

I think this issue comes from Joomla. Cause, I have tried to update the Joomla include page builder and exclude page builder. But, Same error occurred. You need to contact with the Joomla forum. Thanks

0
JD
Joerg Distler
Accepted Answer
3 years ago #66468

Hello Toufig,

thank you. Best Jörg

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #66553

You are most welcome

0