|CC:||506157 [...] bugs.debian.org|
|Subject:||Re: Bug#506157: libdbd-sqlite3-perl: unsufficient error message while opening database for writing|
|Date:||Wed, 19 Nov 2008 00:08:33 +0100|
|To:||"Eugene V. Lyubimkin" <jackyf.devel [...] gmail.com>|
|From:||Ansgar Burchardt <ansgar [...] 2008.43-1.org>|
Hi, I'm forwarding the bug report, the original report is available on the Debian Bug Tracker. Please CC: firstname.lastname@example.org in replies. "Eugene V. Lyubimkin" <email@example.com> writes: Show quoted text
> I've spent several days in investigating strange problem and it would be > good to deal somehow with it. > > SQLite database consists of one file. But, is is unsufficient to have > write rights to this database file to perform 'INSERT' statements. At > least, this perl package have requirement user should have write rights > to directory containing this file too. Otherwise, my 'INSERT' statement > ($sth->execute(...)) will fail with error: > > -8<- > DBD::SQLite::st execute failed: unable to open database file(14) at > dbdimp.c line 403 at /var/www/search-site/cgi-bin/register.cgi line 31, > <STDIN> line 1. > ->8- > > I was very confused to see this while having all necessary right on > database file. Please document this or rather extend the error message.This behavior is documented in the SQLite documentation. The SQLite library may create temporary for various reasons, even when only using SELECT statements (see , 2.5). I prepared a small patch adding a note about this in SQLite.pm. Regards, Ansgar Footnotes:   -- PGP: 1024D/595FAD19 739E 2D09 0969 BEA9 9797 B055 DDB0 2FF7 595F AD19
Message body is not shown because sender requested not to inline it.