Announcement

#1 2020-04-16 22:34:18

Cyress
Member
2020-04-16
5

Data corruption in piwigo database

Hello,

If I want to upload photos from my lightroom to my Piwigo I get the error below. How can this be solved? I am pretty new in this...

Debug log for Piwigo Export Plug-in (3.0.3.2187)

It looks like you have some data corruption in your piwigo database.
The server returns the following error when the plugin attempts to update the categories of your uploaded photo:

<pre><br />
<b>Warning</b>:  [mysql error 1062] Duplicate entry '77-nt_wmc_folder' for key 'term_id_taxonomy'

UPDATE `piwib3_categories` AS t1, piwib3_categories_1587027178575203 AS t2
  SET t1.`rank` = t2.`rank`
    , t1.global_rank = t2.global_rank
  WHERE t1.id = t2.id in <b>/home/fotowp/domains/foto-wp.be/public_html/foto/include/dblayer/functions_mysqli.inc.php</b> on line <b>856</b><br />
</pre>{"stat":"ok","result":{"info":"Virtueel album toegevoegd","id":271}}

You many need to contact the Piwigo suppor team for assistance.


Piwigo version: 3.0.3
PHP version:
MySQL version:
Piwigo URL: http://foto-wp.be/foto/admin.php

Offline

 

#2 2020-07-06 18:09:34

susanm
Member
New York
2020-06-24
1

Re: Data corruption in piwigo database

which lightroom version you are using?

Looks like a foreign key issue in your database

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact