> Hello, > > You website states that bugs reports should be sent to this list > (http://www.sqlite.org/src/wiki?name=Bug+Reports). > > ** > Bug report: unhelpful error message when directory permissions are wrong > > Steps to reproduce: > 1. Make new database in the directory /var/database/ with root > permissions. > 2. Change file ower to normal user > 3. Try to open database and make changes to it as the normal user > > What happends: > There is the error message "sqlite: Unable to open database file" > > What was expected: > The error message: "sqlite: Unable to write to database due to file or > folder permissions" > > I just spent several hours trying to debug a PySqlite app which gave > the "unable to open database file" error. Finally I found that in > order to write to the database, Sqlite for some reason needs to have > write permissions to the _folder_ the file resides in. Journal. SQLite create temp journals. That's why it need write permission to folder.
> Please change the error message to be more descriptive so that others > could save time debugging the issue. You can find on Google tons of > people wondering about this error, but few will ever find the > solutions. Fixing the error message would solve it. > ** > I second that. At the beginning of sqlite learning i searched a lot to find the error. > -- > Otto Kekäläinen > www.sange.fi > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users