Re: [sqlite] Fixing a database

[Jim Wilcoxson]

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, the database is already corrupted".

Jim

On 4/22/09, 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 error. The disk is not full.
>
> You don't have write permissions to the file, perhaps?
>
> Igor Tandetnik
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Software first.  Software lasts!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fixing a database - solved

[Alberto Simões]

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 error. The disk is not full.
>
> You don't have write permissions to the file, perhaps?

It had to be mine stupidity. I was testing as root, and as root I have
disk space.
As user I don't (root quota).

Thanks and sorry for the generated spam.

Alberto


-- 
Alberto Simões
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fixing a database

[Igor Tandetnik]

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 Tandetnik



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fixing a database

[Alberto Simões]

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 value. But not sure :)

Thank you
Alberto

-- 
Alberto Simões
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users