https://bugs.kde.org/show_bug.cgi?id=451153
bugskde...@goland.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|WORKSFORME |---
Status|RESOLVED |REPORTED
--- Comment #2 from bugskde...@goland.org ---
So the problem seems to be more complicated than I first thought. After I got
digikam working again I tried to use facial recognition and that ended up
running in about 1 second on 10s of 1000s of photos. Which obviously isn't
right. After that digikam UX could no longer show me any pictures. I tried to
restart and I'm back to:
You have insufficient privileges on the database.
Following privileges are not assigned to you:
CREATE TABLE
Check your privileges on the database and restart digiKam.
I looked back in the digikam folder and there was PrivCheck.ibd all by itself
again. So I manually deleted it.
When I restarted digikam this time I got a new error, same as above except
instead of "CREATE TABLE" it says "ALTER TABLE' and now there are both a
PrivCheck.frm and PrivCheck.ibd files present.
Since both files are present I decided to try and delete them through MariaDB
instead of the file system. So I:
mysql -u root -p -S mysql.socket (executed inside of
~/.local/share/digikam/db_misc)
I have done this in the past using the password I set in digikam but after this
latest round of problems this has stopped working. It now gives me a "ERROR
2002 (HY000): Can't connect to local MySQL server through socket 'mysql.socket'
(111)" error.”
This looks like a password error but what is weird is that I had this working
before. I have no idea why it’s rejecting the password now.
So I tried starting digiKam again as part of the startup process it did delete
PrivCheck.frm but not PrivCheck.ibd and so I’m back where I started.
And yes this time I get the CREATE TABLE error. And if I delete PrivCheck.ibd
then yes I go back to the start with PrivCheck.frm and PrivCheck.ibd and the
ALTER TABLE error.
So now I’m stuck. I can’t get to my photo database at all. Help!
--
You are receiving this mail because:
You are watching all bug changes.
