Announcement

#1 2018-06-28 15:57:03

raivan
Member
2013-09-10
6

Duplicate entry error

Hello/Hi/Greetings,

on every of the public pages of my Piwigo site I get the same MySQL error: Warning:  [mysql error 1062] Duplicate entry '1550543' for key 'PRIMARY'

I've found several online Piwigo sites with the same problem but so far no solution. When I try to use phpMyAdmin to look up the 1550543 ID in piwigo_history, there is no such entry. The list of entries stops at ID 1550542.

Has anyone a suggestion how to solve this?

Piwigo version: 2.9.3
PHP version: 5-54STABLE-STANDARD
MySQL version: 5.6.19
Piwigo URL: http://fotos.pfadfinder-tennengau.at/

Offline

 

#2 2018-06-28 18:46:42

flop25
Piwigo Team
2006-07-06
6811

Re: Duplicate entry error

Hello
you've set only the Smartpocket theme?


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2018-06-28 19:15:00

raivan
Member
2013-09-10
6

Re: Duplicate entry error

Hi,

yes, is that a problem?

BR

raivan

Offline

 

#4 2018-06-28 19:23:27

flop25
Piwigo Team
2006-07-06
6811

Re: Duplicate entry error

i went there to see the full error


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2018-06-28 19:26:45

raivan
Member
2013-09-10
6

Re: Duplicate entry error

Offline

 

#6 2018-06-28 19:37:53

raivan
Member
2013-09-10
6

Re: Duplicate entry error

Hi,

solved the problem, logged into phpMyAdmin and repaired the table with the command REPAIR TABLE  `piwigo_history`

Worked fine, the error message has gone away!

Br

raivan

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact