<html><body><div dir="ltr"><div style="">
</div><div style=""><div>
<div dir="ltr">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.</div><div dir="ltr"><br></div><div dir="ltr">Nadine H</div>
<div id="ms-outlook-mobile-signature" dir="ltr"><div></div></div>
</div>
<div> </div><hr style="display:inline-block;width:98%" tabindex="-1"><div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif"><b>From:</b> Digikam-users <digikam-users-bounces@kde.org> on behalf of Gilles Caulier <caulier.gilles@gmail.com><br><b>Sent:</b> Thursday, July 7, 2022 12:14 AM<br><b>To:</b> digiKam - Home Manage your photographs as a professional with the power of open source <digikam-users@kde.org><br><b>Subject:</b> Re: [digiKam-users] database issue<div> </div></font></div><div dir="ltr"><div>Hi,</div><div><br></div><div>If you have removed the sqlite database files from your account, what did you expect from digiKam ? The behavior as you described sounds normal...</div><div><br></div><div>So you need to restore the database files from a backup.</div><div><br></div><div>Best</div><div><br></div><div>Gilles Caulier<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 6 juil. 2022 à 15:32, <<a href="mailto:stefan.lange@quicknet.nl" style="">stefan.lange@quicknet.nl</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex"><div lang="NL" style=""><div class="gmail-m_1743977055634396456WordSection1"><p class="MsoNormal"><span lang="EN-US">From a second account on my laptop I removed some duplicate files in the first account.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">After closing the second account, I returned to the first account.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">After login, I tried to start Digikam. I responded with:<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">You have insufficient rights for the Database.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Following rights have not been granted:<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> ALTER TABLE<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Check your database rights and restart Digikam.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I use the SQL-database.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Where to check?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">How to solve?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Can removing files trough an other Microsoft account (on the same laptop, and me being the owner of both) corrupt the database.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Regards,<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Stefan Lange<u></u><u></u></span></p></div><div id="gmail-m_1743977055634396456DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<br><br>
<hr style="border: medium none; height: 1px; width: 99%; background-color: rgb(176, 176, 176);">
<table style="border-collapse:collapse; border:medium none">
<tbody><tr>
<td style="border:medium none; padding:0px 15px 0px 8px">
<a href="https://www.avast.com/antivirus" style="">
<img alt="Avast logo" border="0">
</a>
</td>
<td>
<p style="font-family: Calibri, Verdana, Arial, Helvetica; font-size: 12pt; color: rgb(61, 77, 90);">
Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware.
<br><a href="https://www.avast.com/antivirus" style="">www.avast.com</a>
</p>
</td>
</tr>
</tbody></table>
<br>
<a href="#m_1743977055634396456_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1" style=""> </a></div></div></blockquote></div>
</div></div></body></html>