https://bugs.kde.org/show_bug.cgi?id=526935
Bug ID: 526935
Summary: Cannot launch DigiKam "have insufficient privileges on
the database, Following privileges are not assigned to
you: CREATE TABLE"
Classification: Applications
Product: digikam
Version First 9.1.0
Reported In:
Platform: Fedora RPMs
OS: Linux
Status: REPORTED
Severity: critical
Priority: NOR
Component: Database-Sqlite
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 197011
--> https://bugs.kde.org/attachment.cgi?id=197011&action=edit
Error message when starting digiKam
DESCRIPTION
I have digiKam running on Fedora 44 KDE Edition. digiKam was installed months
ago using dnf from the Fedora repository. digiKam has been working correctly
for months. I used pretty standard settings (I believe the database is SQLite,
as it's the default) , my pictures and database are stored on an external 1TB
HDD. The external HDD is NOT full, it has 42% free space. After having this
problem I made sure that my user has read and write permissions for the
database files: I'm the owner and have rw rights to all 4 databases.
STEPS TO REPRODUCE
1. Connect and mount the external HDD where I keep my photos and digiKam
database
2. Try to launch digiKam
3. The main digiKam interface doesn't open, instead a window pops up with an
error message
OBSERVED RESULT
A window pops up with an error message:
Following privileges are not assigned to you:
CREATE TABLE
Check your privileges on the database and restart digiKam
EXPECTED RESULT
digiKam starts normally, as it did repeatedly during the last months.
SOFTWARE/OS VERSIONS
Operating System (available in the Info Center app, or by running `kinfo` in a
terminal window):
KDE Plasma Version: 6.7.5
KDE Frameworks Version: 6.30.0
Qt Version: 6.11.2
ADDITIONAL INFORMATION
Looking at other bug reports with similar messages, I saw users are often
requested to share capture debug traces logs, so I took one which I share here:
$ export QT_LOGGING_RULES="digikam*=true"
$ digikam
digikam.widgets: Use installed icons
digikam.general: AlbumWatch is disabled
digikam.general: Database Parameters:
Type: "QSQLITE"
DB Core Name:
"/run/media/avalanche/Seagate/DigiKam25/digikam4.db"
DB Thumbs Name:
"/run/media/avalanche/Seagate/DigiKam25/thumbnails-digikam.db"
DB Face Name:
"/run/media/avalanche/Seagate/DigiKam25/recognition.db"
DB Similarity Name:
"/run/media/avalanche/Seagate/DigiKam25/similarity.db"
Connect Options: ""
Host Name: ""
Host Port: -1
WAL Mode: true
Internal Server: false
Internal Server Path: ""
Internal Server Init Cmd: ""
Internal Server Admin Cmd: ""
Internal Server Program Cmd: ""
Internal Server Upgrade Cmd: ""
Username: ""
Password: ""
digikam.dbengine: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected: 3 found: 3
digikam.dbengine: Failure executing query:
"PRAGMA journal_mode;"
Error messages: "Unable to execute statement" "unable to open database file"
"14" 2
Bound values: QList()
digikam.dbengine: Failure executing query:
"PRAGMA journal_mode;"
Error messages: "Unable to fetch row" "No query" "" 1
Bound values: QList()
digikam.coredb: Core database: running schema update
digikam.dbengine: Failure executing query:
""
Error messages: "Unable to execute statement" "unable to open database file"
"14" 2
Bound values: QList()
digikam.dbengine: Error while executing DBAction [ "CheckPriv_Cleanup" ]
Statement [ "\n DROP TABLE IF EXISTS PrivCheck;\n
" ]
digikam.coredb: Core database: error while creating a trigger. Details:
QSqlError("14", "Unable to execute statement", "unable to open database file")
digikam.dbengine: Failure executing query:
""
Error messages: "Unable to execute statement" "unable to open database file"
"14" 2
Bound values: QList()
digikam.dbengine: Error while executing DBAction [ "CheckPriv_CREATE_TABLE" ]
Statement [ "CREATE TABLE PrivCheck\n (id INT,\n
name VARCHAR(35));\n " ]
digikam.coredb: Core database: error while creating a trigger. Details:
QSqlError("14", "Unable to execute statement", "unable to open database file")
digikam.coredb: Core database: insufficient rights on database.
digikam.coredb: Core database: cannot process schema initialization
digikam.general: Allowing a cache size of 939 MB
digikam.general: Testing "mariadb-upgrade" ...
digikam.general: Found "mariadb-upgrade"
digikam.general: Testing "mariadbd" ...
digikam.general: Found "mariadbd"
digikam.general: Testing "mariadb-admin" ...
digikam.general: Found "mariadb-admin"
digikam.general: Testing "mariadb-install-db" ...
digikam.general: Found "mariadb-install-db"
--
You are receiving this mail because:
You are watching all bug changes.
