Re: [sqlite] Fixing a database

I think it would be a good idea for sqlite3 to display a message like "Database opened for read-only" if you don't have permission to write. I saw this problem myself where a rollback was necessary from a previous root process, and as a new SQLite user, it was confusing and made me think "great,

Re: [sqlite] Fixing a database - solved

Hello On Wed, Apr 22, 2009 at 9:17 PM, Igor Tandetnik wrote: > Alberto Simoes > wrote: >> I am not sure what happened, but I have a database that opens >> correctly with sqlite3 shell, I can select and query it, but I can't >> edit it. I get Disk I/O

Re: [sqlite] Fixing a database

Alberto Simoes wrote: > I am not sure what happened, but I have a database that opens > correctly with sqlite3 shell, I can select and query it, but I can't > edit it. I get Disk I/O error. The disk is not full. You don't have write permissions to the file, perhaps? Igor

[sqlite] Fixing a database

Hello. I am not sure what happened, but I have a database that opens correctly with sqlite3 shell, I can select and query it, but I can't edit it. I get Disk I/O error. The disk is not full. Is there any way to fix the database? I think some kind of flag somewhere in the database has a wrong