Re: [sqlite] malformed 2.1 db

2005-04-08 Thread Kurt Welgehausen
> Unable to open database 1.db
> now what? any suggestions?

There's probably nothing you can do to fix the file.

In the past, you could corrupt a database by vacuuming
it in one process and then doing an insert in another
process. This has been fixed in V3; I don't know if the
bug even existed in V2.

Most likely, you (or someone) did something to corrupt
the file. See Section 6 of .

Regards


[sqlite] malformed 2.1 db

2005-04-08 Thread Mustafa TUFAN
 Hi there,
1. i get the following error;
c:\>sqlite.exe 1.db
Unable to open database "1.db": database disk image is malformed
so i can't execute pragma integrity_check.
header: ** This file contains an SQLite 2.1 database **
2. this is the corrupted file:
00:  2A 2A 20 54 68 69 73 20 ? 66 69 6C 65 20 63 6F 6E
10:  74 61 69 6E 73 20 61 6E ? 20 53 51 4C 69 74 65 20
20:  32 2E 31 20 64 61 74 61 ? 62 61 73 65 20 2A 2A 00 
30:  28 75 E3 DA 00 00 00 00 ? 00 00 0C 00 00 00 04 00
40:  00 00 D0 07 00 00 02 00 ? 00 00 00 00 00 00 00 00

this is my normal db:
00:  2A 2A 20 54 68 69 73 20 ? 66 69 6C 65 20 63 6F 6E
10:  74 61 69 6E 73 20 61 6E ? 20 53 51 4C 69 74 65 20
20:  32 2E 31 20 64 61 74 61 ? 62 61 73 65 20 2A 2A 00
30:  28 75 E3 DA 00 00 00 00 ? 00 00 00 00 F6 03 00 00
40:  04 00 00 00 D0 07 00 00 ? 02 00 00 00 00 00 00 00
here after 0x34 it seemed to me that there is a 2 bytes shift left so i 
added 2 null bytes,
but it didn't work.
c:\>sqlite.exe 1.db
Unable to open database 1.db

now what? any suggestions?
Mustafa TUFAN