kmail serious problems

[Ingo Klöcker]

On Dienstag, 7. Februar 2023 17:52:50 CET David Bryant wrote:
> Yes. Assuming that you are using mysql (aka mariadb) as your database
> engine, you can use the mysql program to remove the superfluous database
> rows. An analogous procedure should work with sqlite, if you're using that
> instead..
[...]
> MariaDB [akonadi]> *delete from pimitemtable where remoteid is NULL; *
> Query OK, 17 rows affected (0.005 sec)

This SQL command can also be run in the DB Console tab of akonadiconsole. You 
may want to run
```
select from pimitemtable where remoteid is NULL;
```
before to check which rows will be deleted.

Regards,
Ingo
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20230207/2636b5de/attachment-0001.sig>