[sqlite] error "attempt to write a readonly database"
Thanks - you pointed me in the right direction. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 7 March 2015 at 19:44, Simon Slavin wrote: > > On 7 Mar 2015, at 7:31pm, Paul Sanderson > wrote: > >> I'm an idiot - dev environment was running as admin - so nothing else >> could write to DB out side of this as a normal users. > > A mistake we've all made. Glad you figured it out. > > Simon. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error "attempt to write a readonly database"
On 7 Mar 2015, at 7:31pm, Paul Sanderson wrote: > I'm an idiot - dev environment was running as admin - so nothing else > could write to DB out side of this as a normal users. A mistake we've all made. Glad you figured it out. Simon.
[sqlite] error "attempt to write a readonly database"
Thanks Simon I'm an idiot - dev environment was running as admin - so nothing else could write to DB out side of this as a normal users. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 7 March 2015 at 17:56, Simon Slavin wrote: > > On 7 Mar 2015, at 4:42pm, Paul Sanderson > wrote: > >> I have a database I have created and populated with various tables and data. >> >> I now want to create a new table and I get the above error. >> >> command is create table testtab (id int, data blob); > > If you are not already doing so, try using the SQLite shell tool to execute > that command and see if you get the same error. > > The database may be read-only for several reasons. You can explicitly ask > SQLite to open it read-only. The file may be marked for read-only access for > your user. The folder may be marked for read-only access, which would > prevent SQLite from creating a journal file for changes. And several other > causes. > > Simon. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error "attempt to write a readonly database"
On 7 Mar 2015, at 4:42pm, Paul Sanderson wrote: > I have a database I have created and populated with various tables and data. > > I now want to create a new table and I get the above error. > > command is create table testtab (id int, data blob); If you are not already doing so, try using the SQLite shell tool to execute that command and see if you get the same error. The database may be read-only for several reasons. You can explicitly ask SQLite to open it read-only. The file may be marked for read-only access for your user. The folder may be marked for read-only access, which would prevent SQLite from creating a journal file for changes. And several other causes. Simon.
[sqlite] error "attempt to write a readonly database"
I have a database I have created and populated with various tables and data. I now want to create a new table and I get the above error. command is create table testtab (id int, data blob); I am using sqlite 3.8.6 command line to try and create the table (although the DB was created using Devarts UniDac) . I am on windows, NTFS file system and the error occurs after a reboot so nothing should be holding the DB open. The file itself is not flagged as read only by the OS. I can run the same command on a different DB in the same folder Pragma integrity_check is OK The table testtab does not already exist Any ideas of why i can't create the table/why the db is flagged readonly? Thanks