Re: kmail serious problems

Ingo Klöcker <[email protected]> Tue, 07 Feb 2023 18:19:47 +0100

Newsgroups	gmane.comp.kde.devel.pim
Message-ID	<13201926.uLZWGnKmhe@daneel>

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

signature.asc (application/pgp-signature, 228 B)