Re: [sqlite] SQL error: database disk image is malformed - other possibility than dump/load

> So if the corruption problem is > confined to an index or indexes, an export/import will fix > problem but a vacuum will not. > Dan. I ran into exactly that problem with Sqlite database used by Trac (http://trac.edgewall.org/). The solution Dan proposed here worked fine for me. That's what I

Re: [sqlite] SQL error: database disk image is malformed - other possibility than dump/load

e 39762: sqlite3BtreeInitPage() returns error code 11 > On tree page 39768 cell 0: 2nd reference to page 39762 > Page 39763 is never used > Page 39764 is never used > Page 39765 is never used > Page 39766 is never used > Page 39767 is never used > SQL error: database disk ima

[sqlite] SQL error: database disk image is malformed - other possibility than dump/load

ver used SQL error: database disk image is malformed sqlite> vacuum; SQL error: database disk image is malformed # sqlite3 trac.db .dump .quit >> trac.db.dump # mv trac.db trac.db.orig # sqlite3 trac.db < trac.db.dump ___ sqlite-users mailing li

Re: [sqlite] SQL error: database disk image is malformed

On Wed, 6 May 2009 00:40:22 -0500, "Jay A. Kreibich" wrote: >On Tue, May 05, 2009 at 11:46:38PM +0200, Kees Nuyt scratched on the wall: >> On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov >> wrote: >> >> >Is it just me or somebody else is >> >seeing too that

Re: [sqlite] SQL error: database disk image is malformed

On Tue, May 05, 2009 at 11:46:38PM +0200, Kees Nuyt scratched on the wall: > On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov > wrote: > > >Is it just me or somebody else is > >seeing too that the sql statement > > "select blobid, fbid from sig group by peerid" > >is invalid

Re: [sqlite] SQL error: database disk image is malformed

On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov wrote: >Is it just me or somebody else is >seeing too that the sql statement > "select blobid, fbid from sig group by peerid" >is invalid and shouldn't be >executed or prepared at all? You are right, it doesn't make sense.

Re: [sqlite] SQL error: database disk image is malformed

Is it just me or somebody else is seeing too that the sql statement "select blobid, fbid from sig group by peerid" is invalid and shouldn't be executed or prepared at all? Pavel On Mon, May 4, 2009 at 2:51 PM, Joanne Pham wrote: > Hi All, > I ran the following sql

Re: [sqlite] SQL error: database disk image is malformed

Hi Joanne, It's possible you'll have to resort to your most recent backup. But before doing that, I wasn't sure from your reply that you saw the other points I listed. -- Hold tight to my backups of my data. -- Run "PRAGMA integrity_check;" as soon as possible. -- See if the problem can be

Re: [sqlite] SQL error: database disk image is malformed

ussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, May 4, 2009 4:26:58 PM Subject: Re: [sqlite] SQL error: database disk image is malformed -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne Pham Sent:

Re: [sqlite] SQL error: database disk image is malformed

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne Pham Sent: Monday, May 04, 2009 2:51 PM To: General Discussion of SQLite Database Subject: [sqlite] SQL error: database disk image is malformed Hi All, I ran

[sqlite] SQL error: database disk image is malformed

Hi All, I ran the following sql statement:     select blobid, fbid from sig group by peerid; return about 10 rows         22    ...    33 return about 10 rows and I got the error message:  SQL error: database disk image is malformed but when I ran the following

Re: [sqlite] SQL error: database disk image is malformed

above... 1006|1006|1006|NEW||...ASCII data deleted...|||||| SQL error: database disk image is malformed sqlite> How can I recover the data all the way to record 1006? thanks, josé You can try to use the .dump command of the command line tool to recover what's left. Sometimes it works. I had to go ba

Re: [sqlite] SQL error: database disk image is malformed

gt;>>select * from LSOpenProjects; >>> >>>and goes and display 1006 records and then I get that error above... >>> >>>1006|1006|1006|NEW||...ASCII data deleted...|| >>>SQL error: database disk image is malformed >>>sqlite>

Re: [sqlite] SQL error: database disk image is malformed

malformed that is after I do a, select * from LSOpenProjects; and goes and display 1006 records and then I get that error above... 1006|1006|1006|NEW||...ASCII data deleted...|||||| SQL error: database disk image is malformed sqlite> How can I recover the data all the way to reco

Re: [sqlite] SQL error: database disk image is malformed

>that is after I do a, > >select * from LSOpenProjects; > >and goes and display 1006 records and then I get that error above... > >1006|1006|1006|NEW||...ASCII data deleted...|||||| >SQL error: database disk image is malformed >sqlite> > >How can I recover

[sqlite] SQL error: database disk image is malformed

||...ASCII data deleted...|| SQL error: database disk image is malformed sqlite> How can I recover the data all the way to record 1006? thanks, josé - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] SQL error: database disk image is malformed - SQLITE3.5.1

-Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 22 de novembro de 2007 12:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL error: database disk image is malformed - SQLITE3.5.1 > > > There is a good description of the things that

Re: [sqlite] SQL error: database disk image is malformed - SQLITE 3.5.1

Salles, Joaquim Campos wrote: Now running the command "PRAGMA integrity_check": sqlite> PRAGMA integrity_check; *** in database main *** Main freelist: 138691677 of 4 pages missing from overflow list starting at 2972 On tree page 322 cell 0: 3 of 4 pages missing from overflow list starting at

[sqlite] SQL error: database disk image is malformed - SQLITE 3.5.1

I'm using SQLITE 3.5.1 - in Linux, Had Red 7.1, with a single thread application - and 2 different programs accessing the same database. I am getting the following message: SQL error: database disk image is malformed. I copy the database to windows and run with sqlite and also get the same

Re: [sqlite] SQL error: database disk image is malformed

First of, thank you very much Christian for replying so precisely to my message. Things to check: - Multiple processes accessing the database file. SQLite will arbitrate access using a well defined locking protocol. If a process does not respect this protocol, or locking is defective (NFS

Re: [sqlite] SQL error: database disk image is malformed

Bull219 uttered: Dear all, I am developping a freeware which uses SQLite. One of my beta testers informed me about an issue he had: with his DB, following the query which is sent to the DB, I have the error in the subject of this email. I did some testing, and when I succeeded in

Re: [sqlite] SQL error: database disk image is malformed

I am developping a freeware which uses SQLite. One of my beta testers informed me about an issue he had: with his DB, following the query which is sent to the DB, I have the error in the subject of this email. I did some testing, and when I succeeded in reproducing the error just by doing a

[sqlite] SQL error: database disk image is malformed

Dear all, I am developping a freeware which uses SQLite. One of my beta testers informed me about an issue he had: with his DB, following the query which is sent to the DB, I have the error in the subject of this email. I did some testing, and when I succeeded in reproducing the error just