Re: [sqlite] Malformed database disk image, only when running VACUUM

On Fri, Aug 13, 2010 at 10:34 PM, Colin Wetherbee wrote: > Hello. > > I believe the sqlite shell client is incorrectly telling me I have a > malformed > database image when I run VACUUM. As far as I can tell, the database is, > in > fact, uncorrupted, but the message is a

Re: [sqlite] Strange error

On Sat, Aug 14, 2010 at 12:23 PM, Marco Bambini wrote: > I have a strange error with sqlite 3.6.23.1, does anyone have an > explanation? > > CREATE TABLE 'tblMoneyFlow' > ( > 'id' INTEGER DEFAULT '0' NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, > 'RekeningNrEigenaar' INTEGER

[sqlite] Strange error

I have a strange error with sqlite 3.6.23.1, does anyone have an explanation? CREATE TABLE 'tblMoneyFlow' ( 'id' INTEGER DEFAULT '0' NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, 'RekeningNrEigenaar' INTEGER DEFAULT '0' NOT NULL REFERENCES 'tblBankAccount' ('idAccountNr'), 'Valuta' VARCHAR(4),

Re: [sqlite] Malformed database disk image, only when running VACUUM

On 14 Aug 2010, at 3:34am, Colin Wetherbee wrote: > The error message appears every time I've tried to run VACUUM, but I'm able to > continue executing queries in the same session afterward, and they always > succeed. Running VACUUM is the only time I've seen this error message. > > Why might

Re: [sqlite] Database.

On 13 Aug 2010, at 7:45pm, Kirk Clemons wrote: > Is there a way to parse my database by row id? In other words incase there is > an error I don't want SQLite stop parsing. I have bailing turned off What is 'bailing' ? > but it still does not continue on through the database when doing a

[sqlite] Malformed database disk image, only when running VACUUM

Hello. I believe the sqlite shell client is incorrectly telling me I have a malformed database image when I run VACUUM. As far as I can tell, the database is, in fact, uncorrupted, but the message is a bit scary. I'm using SQLite 3.7.0 (as packaged by the Debian maintainers), and the database,

[sqlite] Database.

Is there a way to parse my database by row id? In other words incase there is an error I don't want SQLite stop parsing. I have bailing turned off but it still does not continue on through the database when doing a 'select *' on each row. Regards ~Kirk.