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

2007-07-24 Thread scoobyjh
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;

2007-07-24 Thread scoobyjh
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;

2007-07-24 Thread Dan Kennedy
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: [sqlite] SQL logic error when running vacuum;

2007-07-24 Thread scoobyjh
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;

2005-10-06 Thread Preston Zaugg
: "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;

2005-10-04 Thread Preston Zaugg
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;

2005-10-04 Thread Cariotoglou Mike
as a matter of fact, I have also noticed that using the vaccum command from the command-line interface does bring this error up sometimes. however, since I use the graphical UI most of the time (being its author:) I don't use the command line interface that much. I suspect it has nothing to do wit