liigo wrote: > > VACUUM got error... > > sqlite3_open(...) > sqlite3_exec("VACUUM") //maybe got error > sqlite3_close(...) > > If my database has a table that created before sqlite3_open(), > I got the errcode=1, errmsg="SQL logic error or missing the database" > > > I also get this error, whether I supply a table name or not. I am using SQLite version: 3.4.0 (AMALGAMATION) and built it with OS_UNIX and SQLITE_OMIT_LOAD_EXTENSION defined:
char *fileName = "/home/databases/sqlite/sqlite_sample.db"; sqlite3 *db = NULL; char *zErrMsg = 0; int error; error = sqlite3_open( fileName, &db ); if( error ) { fprintf(stderr, "Can't open database %s: %s\n", fileName, sqlite3_errmsg( db )); exit( 1 ); } error = sqlite3_exec( db, "VACUUM", callbackFunc, 0, &zErrMsg ); if( error != SQLITE_OK ) { fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free( zErrMsg ); closeDatabase(); exit( 1 ); } error = sqlite3_close( db ); if( error != SQLITE_OK ) { fprintf(stderr, "Can't close database handle :%P %s\n", db, sqlite3_errmsg(db)); exit( 1 ); } db = NULL; Has anybody got any comments on this? -- View this message in context: http://www.nabble.com/Can%27t-run-VACUUM-command%21-tf30544.html#a11760892 Sent from the SQLite mailing list archive at Nabble.com.