Closed jynxf closed 10 months ago
Does it work when you clear your settings or try to use a different session? See https://www.qownnotes.org/getting-started/cli-parameters.html
Thank you for getting back so quickly!
Using a different session worked. This involved choosing a different notes folder, which I let it create.
I think the reason there was a problem was that the folder I had originally chosen was a symbolic link. I removed the symbolic link and used an actual directory, and the problem didn't reoccur. (I did first try to simply choose the directory linked to, but this was automatically replaced by a /run path, which wasn't what I wanted.)
I would have preferred to use the symbolic link, as I try to keep data on a separate device, but it's not a big issue, and everything is now working.
Thanks again
There shouldn't be an issue with symlinks. But I'm not sure how Flatpaks are handling this...
I had a look at Flatpak, and it looks like it's simply a permissions problem.
While the symlink was in my home directory, it pointed to somewhere outside, which meant that Flatpak wouldn't allow access. (I'm not totally sure about how this works, as notes were being saved, it was just the database access that was causing a problem.)
The fix for me is to give Flatpak access to the physical location for QOwnNotes, and now I can use the symlink:
cd mkdir /mnt/Data/home/john/Notes/ ln -s /mnt/Data/home/john/Notes/ . sudo flatpak override org.qownnotes.QOwnNotes --filesystem=/mnt/Data/home/john
I can then choose the Notes folder in my home directory within QOwnNotes.
Thanks for your help with this
Ah, great!
Question
I get a database connection error when starting the application, or when changing settings
Output from the debug section in the settings dialog
Expand
QOwnNotes Debug Information =========================== ## General Info **Current Date**: `Tue Oct 17 12:21:46 2023` **Version**: `23.10.1` **Build date**: `Oct 12 2023` **Build number**: `1060` **Platform**: `linux` **Operating System**: `KDE Flatpak runtime` **Build architecture**: `x86_64` **Current architecture**: `x86_64` **Release**: `GitHub` **Qt Version (build)**: `5.15.10` **Qt Version (runtime)**: `5.15.10` **Portable mode**: `no` **Settings path / key**: `/home/john/.var/app/org.qownnotes.QOwnNotes/config/PBE/QOwnNotes.conf` **Application database path**: `/home/john/.var/app/org.qownnotes.QOwnNotes/data/PBE/QOwnNotes/QOwnNotes.sqlite` **Application arguments**: `QOwnNotes` **Qt Debug**: `0` **Locale (system)**: `en_GB` **Locale (interface)**: *empty* **Primary screen resolution**: `3440x1440` **Icon theme**: `breeze` **Notes in current note folder**: `165` **Calendar items**: `40` **Enabled scripts**: `0` ## Server Info **serverUrl**: `https://awesempro.dedyn.io` **appIsValid**: `yes` **notesPathExists**: `yes` **serverVersion**: `26.0.5.1` **appVersion**: *empty* ## Spellchecking **Enabled**: `true` **Selected language**: `auto` **Language codes**: `en_AU, en_BS, en_BZ, en_CA, en_GB, en_GH, en_IE, en_IN, en_JM, en_MW, en_NA, en_NZ, en_PH, en_TT, en_US, en_ZA, en_ZW` **Language names**: `Australian English (Australia), English (Bahamas), English (Belize), Canadian English (Canada), British English (United Kingdom), English (Ghana), English (Ireland), English (India), English (Jamaica), English (Malawi), English (Namibia), English (New Zealand), English (Philippines), English (Trinidad & Tobago), American English (United States), English (South Africa), English (Zimbabwe)` **Application dictionaries path**: `/home/john/.var/app/org.qownnotes.QOwnNotes/data/PBE/QOwnNotes/dicts` ## Note folders **currentNoteFolderId**: `1` ### Note folder `default` **id**: `1` **isCurrent**: `yes` **activeTagId**: `-1` **localPath**: `/run/user/1001/doc/b277bf44/Notes` **remotePath**: `Notes` **cloudConnectionId**: `1` **isShowSubfolders**: `yes` **isUseGit**: `no` **allowDifferentNoteFileName**: `no` **activeNoteSubFolder name**: `Dev` **database file**: `/run/user/1001/doc/b277bf44/Notes/notes.sqlite` ## Cloud connections ### Cloud connection `Default` **id**: `1` **isCurrent**: `yes` **serverUrl**: `https://awesempro.dedyn.io` **username**: `john` **accountId**: `john` **Nextcloud Deck boardId**: `0` **Nextcloud Deck stackId**: `0` ## Enabled scripts ## Settings **AboutDialog/geometry** (QByteArray): `Relevant log output in the Log panel
Expand
[12:18:46] [warning] QSqlDatabasePrivate::database: unable to open database: "unable to open database file Error opening database" [12:18:46] [warning] QSqlQuery::prepare: database not open [12:18:46] [warning] noteHasTags : QSqlError("", "Unable to fetch row", "No query") repeated a lot