[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-14 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #80 from Maik Qualmann --- Can you please test the current AppImage to see if anything has changed with the problem? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-11 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #79 from Maik Qualmann --- Git commit 52cd672878919ed58cd28dbfa1cdf9316dc25f21 by Maik Qualmann. Committed on 11/05/2024 at 17:07. Pushed by mqualmann into branch 'master'. check for a valid index M +36 -18

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-10 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #78 from Petr Schonmann --- Created attachment 169370 --> https://bugs.kde.org/attachment.cgi?id=169370=edit debug_log_20240511_010111.txt -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-09 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #77 from Maik Qualmann --- A new AppImage with more debug output is available, can you please create a new log? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-08 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #76 from Maik Qualmann --- Git commit 16a6c642968ff07cc097ac16283a904029d11a7b by Maik Qualmann. Committed on 08/05/2024 at 06:06. Pushed by mqualmann into branch 'master'. add more face engine debug M +2-2

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-06 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #75 from Maik Qualmann --- Git commit 008d086ff3b2a850973ad4ebf23f4e6c49c1 by Maik Qualmann. Committed on 06/05/2024 at 20:21. Pushed by mqualmann into branch 'master'. this should also be a QExplicitlySharedDataPointer and add test

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-06 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #74 from Petr Schonmann --- Created attachment 169248 --> https://bugs.kde.org/attachment.cgi?id=169248=edit debug_digiKam-8.4.0-20240505T093946-Qt6-x86-64.txt -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-05 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #73 from Maik Qualmann --- Git commit ba72a838c6287bce85bcc30c4fd23e80659567fc by Maik Qualmann. Committed on 05/05/2024 at 08:01. Pushed by mqualmann into branch 'master'. Revert "the FaceTagsIface can be override" M +1-1

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-05 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #72 from Maik Qualmann --- Ok, the cause is probably the virtual deconstructor, I can undo this. Objects in a QList should/must be copable and contain an assignment operator. Otherwise the compiler makes a default assignment operator, so

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-05 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #71 from caulier.gil...@gmail.com --- Maik, With the commit from the comment 60, i think you introduce a potential slicing problem in classes FaceTagsIface and FacePipelineFaceTagsIface.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-05 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #70 from Maik Qualmann --- Can you please test the current AppImage? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-03 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #69 from Maik Qualmann --- Git commit af2d341a7dd489dc8c5b324a303e8156d11a4404 by Maik Qualmann. Committed on 03/05/2024 at 10:41. Pushed by mqualmann into branch 'master'. remove items from model after face editing M +10 -10

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-02 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #68 from Maik Qualmann --- Are you using multicore option in the face engine settings of the people view? Please deactivate it once, restart if necessary and see if the problem also occurs. Maik -- You are receiving this mail because:

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-02 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #67 from Petr Schonmann --- Created attachment 169116 --> https://bugs.kde.org/attachment.cgi?id=169116=edit digikam_debug_467766_2024-05-02-another_debug_day.txt -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-02 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #66 from Maik Qualmann --- Another AppImage is available, please test again with debug log. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-02 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #65 from Maik Qualmann --- Git commit e917a7e1e913f23ca290280b39dbcb4df1f0e82e by Maik Qualmann. Committed on 02/05/2024 at 10:29. Pushed by mqualmann into branch 'master'. add assignment operator to FacePipelineFaceTagsIface M +14 -0

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-01 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #64 from Maik Qualmann --- Git commit ce8f53dfcfdd07adf2de473265f854fba2047e2c by Maik Qualmann. Committed on 01/05/2024 at 20:28. Pushed by mqualmann into branch 'master'. add test debug for FaceTagsIface M +2-1

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-01 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #63 from Petr Schonmann --- Created attachment 169083 --> https://bugs.kde.org/attachment.cgi?id=169083=edit digikam_debug_467766_2024-01-05-first_okay_second_not.txt -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-01 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #62 from Petr Schonmann --- Hi, i tried with new release digiKam-8.4.0-20240501T135922-Qt6-x86-64.appimage the first attempt was fine, no error, second, same error. Details in logs attached -- You are receiving this mail because: You are

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-05-01 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #61 from Maik Qualmann --- A new AppImage is available, can you please test whether the problem can still be reproduced? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-30 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #60 from Maik Qualmann --- Git commit 0f08fe600380954785a8a1dc65be3c09568b2548 by Maik Qualmann. Committed on 30/04/2024 at 20:35. Pushed by mqualmann into branch 'master'. add copy constructor and assignment operator to FaceTagsIface M

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-30 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #59 from Petr Schonmann --- Created attachment 169046 --> https://bugs.kde.org/attachment.cgi?id=169046=edit digikam_debug_467766_2024-04-30-without-write-metadata.txt -- You are receiving this mail because: You are watching all bug

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-30 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #58 from Maik Qualmann --- Yes, disable all 9 write options in the metadata settings. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-29 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #57 from Petr Schonmann --- Im not sure how to do that. Just uncheck in metadata configuration TAB Behavior all checked field and Sidecars uncheck write too ? Is it all setting which you need ? Or just which values in digikamrc to toggle

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-29 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #56 from Maik Qualmann --- The test debug entry shows nothing unusual. As a test, can you please deactivate all metadata write options so that nothing is written to an image or sidecar? Maik -- You are receiving this mail because: You

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #55 from Petr Schonmann --- Created attachment 168981 --> https://bugs.kde.org/attachment.cgi?id=168981=edit debuglog -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #54 from Petr Schonmann --- Tried with digiKam-8.4.0-20240428T104713-Qt6-x86-64.appimage Its attached, we exceed 64k limit comment :) -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #53 from Maik Qualmann --- @Petr, can you please create a new debug log with the current AppImage? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #52 from caulier.gil...@gmail.com --- It's under Progress... Gilles -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #51 from Maik Qualmann --- @Gilles, a new AppImage would be good. Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-28 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #50 from Maik Qualmann --- Git commit c182425929dafc5339e964e13e887f01b09ef5b6 by Maik Qualmann. Committed on 28/04/2024 at 10:38. Pushed by mqualmann into branch 'master'. add Test debug for bug 467766 M +3-1

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #49 from Petr Schonmann --- Synology Drive Client is the desktop utility that provides file syncing and personal computer backup services on multiple client computers to a centralized server, Synology Drive Server.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #48 from Maik Qualmann --- The sidecar file without the "jpg" extension comes from a sidecar setting "Sidecar filenames compatible with commercial programs". You probably activated this option at some point. But it doesn't matter for this

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #47 from Petr Schonmann --- Created attachment 168919 --> https://bugs.kde.org/attachment.cgi?id=168919=edit Dsc00743.jpg.xmp -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #46 from Petr Schonmann --- Created attachment 168918 --> https://bugs.kde.org/attachment.cgi?id=168918=edit Dsc00743.xmp -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #45 from Petr Schonmann --- Collection is not currently on network drive. This is for a historical reason and I haven't changed the configuration yet. In past, collection was on network drive. Reading / Writing was slow - then i moved

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-26 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #44 from Maik Qualmann --- My guess is a problem with your network drive. Everything is OK until the sidecar file is written. We then re-read the metadata. Now the ItemInfo image ID== 0. I suspect that the network drive is no longer

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #43 from Petr Schonmann --- pschonmann@E495:~$ digikam -- digiKam Linux AppImage Bundle -- Use 'help' as CLI argument to know all available options for digiKam application. -- Notes: to integrate this bundle to your desktop, use

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #42 from Maik Qualmann --- I'm referring to the log from Comment 19. Your collection is not available at startup, after the first database query/item listing there is a Solid event and the collection becomes available. That's a strange

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #41 from Maik Qualmann --- Git commit d472489b5457710d44c83ed6bac61c795e607646 by Maik Qualmann. Committed on 25/04/2024 at 19:18. Pushed by mqualmann into branch 'master'. show an error icon if the collection/album root is not available

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #40 from Maik Qualmann --- I see in an old log that you uploaded here that your collection is not available for digiKam! Go to the digiKam collection settings and use the update function (round circle icon tool button) for the collection.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #39 from Maik Qualmann --- No, these characters are allowed in file names. Can you post the beginning of the digiKam start as a log? Until the plugins load is sufficient. Maik -- You are receiving this mail because: You are watching all

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #38 from Petr Schonmann --- Yeap, library is online and accessible pschonmann@E495:~$ ls -lsah '/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg' 96K -rw-r--r-- 1 pschonmann pschonmann 94K Jan 18 05:52 '/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg'

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #37 from Maik Qualmann --- These messages from your last log are strange. You also write sidecar to JPG files, but this doesn't report any errors. Afterwards Exiftool cannot find the (original) file and an empty file path is reported. Is

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #36 from Petr Schonmann --- Created attachment 168772 --> https://bugs.kde.org/attachment.cgi?id=168772=edit Fresh DB from DK8.4.0 -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #35 from Petr Schonmann --- Created attachment 168771 --> https://bugs.kde.org/attachment.cgi?id=168771=edit Actual DB scheme -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #34 from Petr Schonmann --- Tried to change collation on tables, no change, still getting error. digikam.sql is my database schema after change digikam2.sql is newly created database in digikam 8.4.0 -- You are receiving this mail

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #33 from Petr Schonmann --- Probably found that tables have bad collation, db not *** mysql> SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'digikam' LIMIT 1; ++ |

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #32 from Maik Qualmann --- You sent me your database and I couldn't reproduce it with it. However, you are using your database with utf8mb4 and then the index might be too small to uniquely resolve entries. So far we have undone tests with

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.2.0 |8.4.0 -- You are receiving this

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-21 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #31 from Petr Schonmann --- Yes, still reproducible. For example. Digikam::DMetadata::load: Loading metadata with "Exiv2" backend from "/mnt/snorlax/Photos/Peta/_TELEFON/2023/PXL_20230506_110913832.jpg"

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2024-04-19 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #30 from caulier.gil...@gmail.com --- Hi all, The digiKam 8.4.0 Appimage bundle pre-release is now based on last modern frameworks Qt 6.7.0 and KDE 6.2.0. File can be downloaded at usual place : https://files.kde.org/digikam/ Take a care

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-28 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #29 from Petr Schonmann --- Here is my percona config -- root@db:~# grep -v ^# /etc/mysql/percona-server.conf.d/mysqld.cnf /etc/mysql/percona-server.conf.d/petr.cnf | grep -v :$ /etc/mysql/percona-server.conf.d/mysqld.cnf:[mysqld]

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-28 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #28 from Maik Qualmann --- Hi Petr, I haven't been able to reproduce the problem with your database backup yet. I want to examine it further over the next few days. Do I see correctly in your backup file that you are running the database

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-27 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.0.0 |8.2.0 -- You are receiving this

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-27 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 Petr Schonmann changed: What|Removed |Added Platform|Mint (Ubuntu based) |Appimage --- Comment #27 from Petr Schonmann

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-12 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #26 from Petr Schonmann --- Hey Maik ! Enjoy your meal :) This bug isnt important, your meal is ! Ill be absolutelly happy with response time 48h with that large project as digikam is. Have a nice day. -- You are receiving this mail

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-12 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #25 from Maik Qualmann --- Thanks for the MySQL backup. I was only able to test it briefly during my lunch break. I had given names to unknown faces. There was no error message. But according to the video, the problem occurs with

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-12 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #24 from Petr Schonmann --- Mysqldump download link sent to mail metzping...@gmail.com -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-12 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #23 from Maik Qualmann --- To find this bug, we need to be able to reproduce the problem and debug it ourselves. Could you provide me your MySQL digiKam core database as a MySQL backup file? Maik -- You are receiving this mail because:

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-11 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #22 from Petr Schonmann --- Im waiting for your turn :) nothing changes from my side :) For better understanding, there is video. https://share.schonmann.eu/s3d36z.mp4 First tag face - that not unconfirmed for right person, i tag to the

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-10-10 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #21 from caulier.gil...@gmail.com --- Petr, Any feedback here ? Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #20 from Petr Schonmann --- Same situation, log attached https://bugs.kde.org/attachment.cgi?id=161271 -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #19 from Petr Schonmann --- Created attachment 161271 --> https://bugs.kde.org/attachment.cgi?id=161271=edit Log for digiKam-8.2.0-20230828T081053-x86-64.appimage -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #18 from Petr Schonmann --- Tried to migrate mariadb from nas to dedicated mysql server. Its percona8 on debian12 - testing release, but seems stable Linux db 6.1.0-11-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-4 (2023-08-08) x86_64

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #17 from Maik Qualmann --- I see that we are already cleaning up the ImageTagProperties table. Have you already run the database cleaner in the maintenance tool with the option extented clean and shrink database? You can also try the

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #16 from Maik Qualmann --- In the "ImageTagProperties" table there is an image ID that no longer exists in "Images". I will add a corresponding function in the database cleaner tool. Maik -- You are receiving this mail because: You are

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-29 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #15 from caulier.gil...@gmail.com --- What’s about the 8.2.0 pre release appimage bundle ? -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-08-27 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #14 from Petr Schonmann --- Problem persists in 8.1.0 Appimage -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-05-03 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #13 from caulier.gil...@gmail.com --- Hi all, what's the next step for this entry ? Gilles -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #12 from Petr Schonmann --- from table file i removed tables which doenst contain imageid column. root@nas:~# for table in $(cat tables);do echo -n "$table : " && mysql -D digikam -NBe "SELECT count(*) FROM $table WHERE imageid IS

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #11 from Maik Qualmann --- Note that for "Images" you need to test on column "id". Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #10 from Maik Qualmann --- Can you test again for "NULL" instead of "0"? Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #9 from Petr Schonmann --- Seems all queries with imageid = 0 are empty root@nas:~# cat tables ImageComments ImageCopyright ImageHaarMatrix ImageHistory ImageInformation ImageMetadata ImagePositions ImageProperties ImageRelations Images

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #8 from Maik Qualmann --- The same for: SELECT * FROM ImageTagProperties WHERE imageid = 0; Maik -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #7 from Petr Schonmann --- Its empty set ! Server version: 10.3.32-MariaDB Source distribution MariaDB [(none)]> use digikam Database changed MariaDB [digikam]> SELECT * FROM Images WHERE id = 0; Empty set (0.000 sec) -- You are

[digikam] [Bug 467766] MySQL foreign key error on a zero image id

2023-03-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 Maik Qualmann changed: What|Removed |Added Summary|QMYSQL3: Unable to execute |MySQL foreign key error on