Workarounds

From wiki
Revision as of 21:50, 11 December 2016 by Vincent (talk | contribs) (Kmail: Multiple merge candidates, aborting)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Digikam

Crash when using bracketing fusion tool

https://bugs.kde.org/show_bug.cgi?id=354364

$ cd ~/.kde/share/apps/digikam
$ mkdir toolbar
$ cp /usr/share/icons/oxygen/22x22/animations/process-working.png toolbar

https://bugs.kde.org/show_bug.cgi?id=354364#c29

Roundcube/Fail2ban

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=810287

Path to log overridden in /etc/fail2ban/jail.d/roundcube-auth.conf

laptop_mode not reapplied on resume from suspend

Bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=798777

Created file /lib/systemd/system-sleep/laptop-mode.sh

#!/bin/sh

case "$1" in
  pre )
    ;;
  post )
    sleep 5 && /usr/sbin/laptop_mode force
    ;;
esac

File is not in /etc due to https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=787711

Kmail: Multiple merge candidates, aborting

This sadly famous Kmail bug will block synchronization of you email. Unfortunately there is no way to find the problematic email through the UI.

To find duplicate run the following using the DB Console tab from Akonadi Console

SELECT pimitemtable.*, collectiontable.name FROM pimitemtable
INNER JOIN pimitemtable dup ON pimitemtable.id != dup.id and pimitemtable.remoteId = dup.remoteId and pimitemtable.collectionId = dup.collectionId
INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id
ORDER by pimitemtable.remoteId

To delete duplicates, you can run

DELETE FROM pimitemtable WHERE pimitemtable.id in (
    SELECT id FROM (
        SELECT id FROM pimitemtable
        LEFT OUTER JOIN (
            SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId, pimitemtable.collectionId FROM pimitemtable GROUP by pimitemtable.remoteId, pimitemtable.collectionId
        )
        as KeepRows ON pimitemtable.id = KeepRows.RowId
        WHERE KeepRows.RowId IS NULL
    ) AS foo
)