Subject: | Vacuum failed.DBD::SQLite::db do failed: SQL logic error or missing database at E:\sql.pl |
DBD-SQLite 2.8.6
ActiveState v5.8.0 built for MSWin32-x86-multi-thread
tested on Windows2000 SP3 German and WindowsXP SP1 German
I can't vacuum database from script. I get following error:
DBD::SQLite::db do failed: SQL logic error or missing database at
H:\test.pl line 5.
test.pl:
------------------------------
#!/usr/bin/perl -w
use strict;
use DBI;
my $dbh = 'DBI'->connect('dbi:SQLite:dbname=sql');
$dbh->do("vacuum");
$dbh->disconnect;
--------------------------------
other methods (select etc) is ok, only vacuum fails. With command line
sqlite.exe I can vacuum without problem.
my sql-file:
------------------------------------------------
E:\sqlite\2>sqlite.exe sql
SQLite version 2.8.6
Enter ".help" for instructions
Show quoted text
sqlite> create table tab1 (a,b,c,d);
sqlite> insert into tab1 values ('q','e','e','e');
sqlite> select * from tab1;
q|e|e|e
----------------------------------------------
other methods (select etc) is ok, only vacuum fails. With command line
sqlite.exe I can vacuum without problem.
-------------------------------------------------
Show quoted textsqlite> delete from tab1 where a like '%';
sqlite> select * from tab1;
sqlite> vacuum;
sqlite>