| Summary: | photos missing from album | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | joel.lasky |
| Component: | Database-Sqlite | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | metzpinguin |
| Priority: | NOR | ||
| Version First Reported In: | 7.3.0 | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | 7.4.0 | |
| Sentry Crash Report: | |||
| Attachments: |
joeljoel-Inspiron-One-2330 export QT_LOG.txt
joel_lasky.vcf joeljoel-Inspiron-One-2330 sqlite3 homejo.txt joel_lasky.vcf attachment-20821-0.html joel_lasky.vcf |
||
|
Description
joel.lasky
2021-11-25 20:21:42 UTC
Are the Ubuntu digiKam packages a snap package? If so, it is unusable: Snap packets use a sandbox. We now know a lot of problems with the Ubuntu digiKam Snap packages. Please test it with our AppImage from www.digikam.org. Otherwise, what type of image is it that is not displayed? Have you tried the function to repair the album in the right mouse button context menu above the album tree? To be able to help, we need a log from the terminal, as described here: https://www.digikam.org/contribute/ Maik Created attachment 143948 [details] joeljoel-Inspiron-One-2330 export QT_LOG.txt I followed your instructions. I still have photos not displaying in certain subfolders. The photos are those that I have edited mainly using the oil paint technique. I've attached the log file per your request. On 11/25/21 2:06 PM, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=446089 > > Maik Qualmann <metzpinguin@gmail.com> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > CC| |metzpinguin@gmail.com > > --- Comment #1 from Maik Qualmann <metzpinguin@gmail.com> --- > Are the Ubuntu digiKam packages a snap package? If so, it is unusable: Snap > packets use a sandbox. We now know a lot of problems with the Ubuntu digiKam > Snap packages. Please test it with our AppImage from www.digikam.org. > > Otherwise, what type of image is it that is not displayed? > Have you tried the function to repair the album in the right mouse button > context menu above the album tree? > > To be able to help, we need a log from the terminal, as described here: > > https://www.digikam.org/contribute/ > > Maik > -- Joel Lasky joel.lasky@mail.com 480.270.4036 Created attachment 143949 [details]
joel_lasky.vcf
Your digiKam4.db core database is defective: digikam.dbengine: Failure executing query: ... Error messages: "Unable to fetch row" "database disk image is malformed" "11" 1 It will probably not be possible to repair it. You will have to start with a new digiKam configuration and databases. Be sure to check your hard drive for errors. Maik Install the sqlite3 package. Try a repair with the following command: sqlite3 /home/joel/Pictures/digikam4.db "PRAGMA integrity_check;" Maik Created attachment 143973 [details] joeljoel-Inspiron-One-2330 sqlite3 homejo.txt Still having problems. I followed instructions. I've attached the log. On 11/26/21 12:15 AM, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=446089 > > --- Comment #5 from Maik Qualmann <metzpinguin@gmail.com> --- > Install the sqlite3 package. Try a repair with the following command: > > sqlite3 /home/joel/Pictures/digikam4.db "PRAGMA integrity_check;" > > Maik > -- Joel Lasky joel.lasky@mail.com 480.270.4036 Created attachment 143974 [details]
joel_lasky.vcf
Here a possibility is described to create a new DB via dump, it is probably better to start with a new digiKam setup and DB ... https://ronnieroller.com/Repair-an-SQLite-database Maik From sqlite 3.29.0 there is also a recovery feature and it is perhaps easier to use: sqlite3 /home/joel/Pictures/digikam4.db ".recover" | sqlite3 new.db But this recovery feature does not work for every DB error either. Maik Created attachment 143982 [details] attachment-20821-0.html Other than an uninstall/reinstall, how do I start a new digikamsetup? Joel Lasky joel.lasky@mail.com 480.270.4036 Get BlueMail for Android On Nov 26, 2021, 10:57 AM, at 10:57 AM, Maik Qualmann <bugzilla_noreply@kde.org> wrote: >https://bugs.kde.org/show_bug.cgi?id=446089 > >--- Comment #8 from Maik Qualmann <metzpinguin@gmail.com> --- >Here a possibility is described to create a new DB via dump, it is >probably >better to start with a new digiKam setup and DB ... > >https://ronnieroller.com/Repair-an-SQLite-database > >Maik > >-- >You are receiving this mail because: >You reported the bug. remove the digiKam config file: ~/.config/digikamrc Maik Created attachment 143987 [details] joel_lasky.vcf That worked! Thank you! On 11/26/21 1:56 PM, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=446089 > > --- Comment #11 from Maik Qualmann <metzpinguin@gmail.com> --- > remove the digiKam config file: ~/.config/digikamrc > > Maik > -- Joel Lasky joel.lasky@mail.com 480.270.4036 |