Duplicate entry '1' for key 'PRIMARY'

Phoca Gallery - image gallery extension
kueppers
Phoca Member
Phoca Member
Posts: 11
Joined: 16 May 2017, 22:30

Duplicate entry '1' for key 'PRIMARY'

Post by kueppers »

After the successful update from Joomla 3 to 4, the error message "Duplicate entry '1' for key 'PRIMARY'" appears after trying to install Phoca Gallery. The www is not very helpful. Can anyone tell me how to fix this error.

Many other extensions could be installed without problems.

Regards
Kueppers

Tags:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Duplicate entry '1' for key 'PRIMARY'

Post by Jan »

Hi, did you follow this guide:
https://www.phoca.cz/documents/50-jooml ... o-joomla-4

This seems like new install tries to add new items into database but there are previous data which should not be there.
This can happen when Joomla system does not have any information and thinks that the component does not exist and install it instead of update :idea:

When you enable debug mode, do you get more information about the problem (e.g. which table it is, etc.)

Jan
If you find Phoca extensions useful, please support the project
kueppers
Phoca Member
Phoca Member
Posts: 11
Joined: 16 May 2017, 22:30

Re: Duplicate entry '1' for key 'PRIMARY'

Post by kueppers »

Jan, thank you for pointing this out.
I have "cleaned" the database and reinstalled the component according to the description.
Now the this error message no longer appears.

Regards
Kueppers
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48689
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Duplicate entry '1' for key 'PRIMARY'

Post by Jan »

Hi, great to hear it.

Jan
If you find Phoca extensions useful, please support the project
Post Reply