Error: Not a writeable directory

Post Reply
LifeIsLong
Posts: 85
Joined: 09 Oct 08 2:22

Error: Not a writeable directory

Post by LifeIsLong » 20 Apr 17 2:12

So recently I started getting the following error on startup (before any splash screen or main window):

Information
-----------
Unable to connect to the database.

The database reports:
SQLITE_ERROR - not a writable directory

[OK]

If I click ok I get a dialog saying "cannot connect to the database," but if I click ok and then login with the same (default) database as was just attempted, everything looks and works fine. The database checks and vacuums with no errors or problems.

The only problem I have is that if I import pictures or change any picture, I suddenly have over 1000 out-of-sync pictures... most of them are not the ones I just imported or changed. I can save the metadata to the files and the count goes back down to 0, but when I make another change, they show up again as out-of-sync.

Any ideas?

Hert
Posts: 20237
Joined: 13 Sep 03 7:24

Re: Error: Not a writeable directory

Post by Hert » 20 Apr 17 7:23

Sounds like your temp folder is not writable (or full?). PSU configures SQLite to let SQLite use the temp folder of the OS. Perhaps you recently made changes to the computer? OS update...or security changes...or file system reconfiguration....or even a new hard drive?
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

LifeIsLong
Posts: 85
Joined: 09 Oct 08 2:22

Re: Error: Not a writeable directory

Post by LifeIsLong » 20 Apr 17 10:53

Interesting. I checked my environment variables and C:\Windows\Temp is my temp folder. My C drive has 16GB free, and the temp folder does not have read only access set (and I deleted several files from it). I have not upgraded my harddisk recently...

Thinking back, I believe this started around the time I restored a catalog backup file, if that could help pinpoint something.

Is there any way to see what folder sqlite is trying to use as temp?

LifeIsLong
Posts: 85
Joined: 09 Oct 08 2:22

Re: Error: Not a writeable directory

Post by LifeIsLong » 21 Apr 17 13:00

Does PSU use the archive file attribute to help determine if a file has been changed?

Hert
Posts: 20237
Joined: 13 Sep 03 7:24

Re: Error: Not a writeable directory

Post by Hert » 21 Apr 17 17:03

No it doesn't.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply