https://bugs.kde.org/show_bug.cgi?id=471961
Bug ID: 471961 Summary: Two database dump was made on the same day, but one of them is not read by digiKam Classification: Applications Product: digikam Version: 8.1.0 Platform: Other OS: Microsoft Windows Status: REPORTED Severity: normal Priority: NOR Component: Database-Albums Assignee: digikam-bugs-n...@kde.org Reporter: benedekppe...@gmail.com Target Milestone: --- digiKam version: (Weekly Snapshots) 8.1 on Windows 10 and LinuxMint 21 (appimage) Database: mysql-server 5.7.42-0ubuntu0.18.04.1 (The database runs on an ubuntu server) Dump: dump files were created automatically warning before loading the database (20230704_09:00:01-digikam_FAULT.sql): Old character set: UTF8, new character set: UTF8MB4 Comment: 20230704_23:22:29-digikam_GOOD.sql -- I restored a previous database backup, then I created a new dump. This works well. The uploaded two database dump and two screenshot: https://mega.nz/folder/IMwn0aKa#kJW3tpwUM5FGfFkrNSL8tQ Environment: Language: HU The database runs on an ubuntu server, and windows 10 clients connect to it in a network. In LinuxMint am currently only checking the database backups, no changes are made! I opened the 20230704_09:00:01-digikam_FAULT.sql database in Windows 10 and LinuxMint client, and I see that the data is not displayed (Fault_database_dump.jpg). After opening the database, digiKam starts rebuilding the data, even though the data is already in the database (I checked in a text editor). I restored a save from a few days ago and the data appeared (Good_database_dump.jpg) Between the two dates, only a few labels and captions were made for the pictures. I reloaded again the 20230704_09:00:01-digikam_FAULT.sql database, but it seems the albums/photos data is lost. Can two nearby digiKam weekly snapshots cause this problem? -- You are receiving this mail because: You are watching all bug changes.