Difference between revisions of "Workarounds"
From wiki
(Add digikam) |
(Kmail: Multiple merge candidates, aborting) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Digikam == | == Digikam == | ||
Crash when using bracketing fusion tool | Crash when using bracketing fusion tool | ||
| Line 12: | Line 7: | ||
$ cp /usr/share/icons/oxygen/22x22/animations/process-working.png toolbar | $ cp /usr/share/icons/oxygen/22x22/animations/process-working.png toolbar | ||
</syntaxhighlight>https://bugs.kde.org/show_bug.cgi?id=354364#c29 | </syntaxhighlight>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 <code>/etc/fail2ban/jail.d/roundcube-auth.conf</code> | ||
| + | |||
| + | == laptop_mode not reapplied on resume from suspend == | ||
| + | Bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=798777 | ||
| + | |||
| + | Created file <code>/lib/systemd/system-sleep/laptop-mode.sh</code> <syntaxhighlight lang="shell"> | ||
| + | #!/bin/sh | ||
| + | |||
| + | case "$1" in | ||
| + | pre ) | ||
| + | ;; | ||
| + | post ) | ||
| + | sleep 5 && /usr/sbin/laptop_mode force | ||
| + | ;; | ||
| + | esac | ||
| + | </syntaxhighlight>File is not in <code>/etc</code> due to https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=787711 | ||
| + | |||
| + | == Kmail: Multiple merge candidates, aborting == | ||
| + | This [https://bugs.kde.org/show_bug.cgi?id=338658 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''<syntaxhighlight lang="sql"> | ||
| + | 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 | ||
| + | </syntaxhighlight>To delete duplicates, you can run<syntaxhighlight lang="sql"> | ||
| + | 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 | ||
| + | ) | ||
| + | </syntaxhighlight> | ||
[[Category:TODO]] | [[Category:TODO]] | ||
Latest revision as of 21:50, 11 December 2016
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
)
