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 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 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 following: > drops a table > creates a new table (same name different structure from the > the table that was just dropped) adds a unique constraint > runs 7000+ insert statements > > the file is executed using the .read of the command line > utility, and runs without error/warning. > > As a side note i am able to run this same script against a MS > SQL Server database without error. > > Between the fact that i can run this script on sql server and > don't get any errors on the .read, makes me think that my > script is valid/well formed. > > Oh.. other important stuff... i was on 3.2.2 when i started > running into this problem. Upgraded to 3.2.7 with the same > results. I'm on Windows 2003 and using a local database. > > Any suggestions? > --Preston > > > > >