[digiKam-users] database issue

[Maik Qualmann]

The cause with SQLite is 100% lack of write permission on the database file at 
file level. By using another user account, the file permissions were probably 
raised to a higher level and can no longer be written to by the second user 
account.

Maik

Am Donnerstag, 7. Juli 2022, 22:11:38 CEST schrieb Nadine Helkenn:
> The error you encountered appears to be generated by MySQL or MariaDB. I was
> receiving the same error when the MySQL tables became corrupted. I don;t
> believe the error has anything to do with SQLite.
> 
> 
> Nadine H
>  
> From: Digikam-users <digikam-users-bounces at kde.org> on behalf of Gilles
> Caulier <caulier.gilles at gmail.com> Sent: Thursday, July 7, 2022 12:14 AM
> To: digiKam - Home Manage your photographs as a professional with the power
> of open source <digikam-users at kde.org> Subject: Re: [digiKam-users]
> database issue
>  
> Hi,
> 
> 
> If you have removed the sqlite database files from your account, what did
> you expect from digiKam ? The behavior as you described sounds normal...
> 
> 
> So you need to restore the database files from a backup.
> 
> 
> Best
> 
> 
> Gilles Caulier
> 
> 
> 
> Le mer. 6 juil. 2022 à 15:32, <stefan.lange at quicknet.nl> a écrit :
> 
> 
> From a second account on my laptop I removed some duplicate files in the
> first account.
> 
> After closing the second account, I returned to the first account.
> 
> After login, I tried to start Digikam. I responded with:
> 
>  
> 
> You have insufficient rights for the Database.
> 
> Following rights have not been granted:
> 
> ALTER TABLE
> 
> Check your database rights and restart Digikam.
> 
>  
> 
> I use the SQL-database.
> 
>  
> 
> Where to check?
> 
> How to solve?
> 
> Can removing files trough an other Microsoft account (on the same laptop,
> and me being the owner of both) corrupt the database.
> 
>  
> 
>  
> 
> Regards,
> 
>  
> 
> Stefan Lange
> 
> 
> 
> 
> 
> 
> Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware.
> www.avast.com