Re: [sqlite] SQL logic error when running vacuum;

This indeed is the problem! I just did a quick test and created a /var/tmp folder and now vacuum works fine. I can hoover databases to my hearts content Thanks again Dan, Scooby Hi Dan, I am running SQLite on an ARM9 target, cross compiled from windows using the OS_UNIX port out-of-the box c

Re: [sqlite] SQL logic error when running vacuum;

Hi Dan, I am running SQLite on an ARM9 target, cross compiled from windows using the OS_UNIX port out-of-the box configuration save for defining SQLITE_OMIT_LOAD_EXTENSION. I am calling into SQLite from a test harness I implemented using the native API. I didn't realise that VACUUM generates a

Re: [sqlite] SQL logic error when running vacuum;

the > > database without error. > > > > --Preston > > - Original Message - > > From: "Preston Zaugg" <[EMAIL PROTECTED]> > > To: > > Sent: Tuesday, October 04, 2005 10:58 AM > > Subject: RE: [sqlite] SQL logic error when r

Re[2]: [sqlite] SQL logic error when running vacuum;

or:) I don't use the command line interface that much. >>> I suspect it has nothing to do with the engine itself, rather with the >>> command-line tool. >>> >>> > -Original Message- >>> > From: Preston Zaugg [mailto:[EMAIL PROTECTED] >>

Re: [sqlite] SQL logic error when running vacuum;

sday, October 04, 2005 10:58 AM > Subject: RE: [sqlite] SQL logic error when running vacuum; > > >> Well, based on your comment i tried a vacuum from the API and i still get >> the error. >> >> Original Message Follows >> From: "Cariotoglou Mike&quo

Re: [sqlite] SQL logic error when running vacuum;

: "Preston Zaugg" <[EMAIL PROTECTED]> To: Sent: Tuesday, October 04, 2005 10:58 AM Subject: RE: [sqlite] SQL logic error when running vacuum; Well, based on your comment i tried a vacuum from the API and i still get the error. Original Message Follows From: "Cari

RE: [sqlite] SQL logic error when running vacuum;

Well, based on your comment i tried a vacuum from the API and i still get the error. Original Message Follows From: "Cariotoglou Mike" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: RE: [sqlite] SQL logic error when running vacuum; Date: Tue, 4 O

RE: [sqlite] SQL logic error when running vacuum;

to do with the engine itself, rather with the command-line tool. > -Original Message- > From: Preston Zaugg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 04, 2005 6:35 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQL logic error when running vacuum; > > I

[sqlite] SQL logic error when running vacuum;

I have a database (encrypted w/ encryption extensions from drh). After run a sql file on this database it gives the error "SQL error: SQL logic error or missing database" after running a vacuum. it also seems to give this error sporadically on other statements. the sql file that i run does the fo