Error migrating to sqlite backend
Axel Braun
axel.braun at gmx.de
Fri Sep 18 16:57:22 BST 2026
Hi,
I wanted to give the migration from Postgres to sqlite another try
KMail is 26.08.1 on openSUSE Tumbleweed
When running
I ran
akonadictl fsck
akonadictl vaccum
before
akonadi-db-migrator --newengine sqlite
During this I get the error:
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: "42703"
org.kde.pim.akonadiserver: DB error: "ERROR: column \"pimitemflagrelation\" of relation \"pimitemflagrelation\" does not exist\nZEILE 1: UPDATE PimItemFlagRelation SET PimItemFlagRelation.Flag_id =...\n ^\nTIP: SET target columns cannot be qualified with the relation name.\n(42703)"
I tried gemini to find a solution, but except some dangerous proposals like
mv ~/.local/share/akonadi ~/.local/share/akonadi.bak
(which deletes all local content) nothing useful found.
Any hints to fix this?
Thanks
Axel
More information about the kdepim-users
mailing list