Not sure if this will help, running this through the debugger the
error is being generated from DBD::SQLite::db::_login which is in the
XS/C code.
main::getDBConnection(projectory.cgi:1577):
1577: $dbh =
DBI->connect("dbi:SQLite:dbname=projectory.sqlite3","","") or die
"$DBI::errstr\n";
.
.
.
DBI::connect(/home/talbert/lib/perl5/sun4-solaris/DBI.pm:471):
471: unless ($dbh = $drh->$connect_meth($dsn, $user, $pass, $attr)) {
DB<2> p $drh
DBI::dr=HASH(0x5d069c)
DB<3> p $dsn
dbname=projectory.sqlite3
DB<4> p $user
DB<5> p $pass
DB<6> p $attr
HASH(0x5a5b04)
.
.
.
DBD::SQLite::dr::connect(/home/talbert/lib/perl5/sun4-solaris/DBD/SQLite.pm:57):
57: DBD::SQLite::db::_login($dbh, $real_dbname, $user, $auth)
58: or return undef;
.
.
.
DB<7> p $dbh
DBI::db=HASH(0x9c92bc)
DB<8> p $real_dbname
projectory.sqlite3
DB<9> p $user
DB<10> p $auth
DB<11>
On Tue, Jun 23, 2009 at 5:27 PM, Craig Talbert<craig.talb...@gmail.com> wrote:
> From Perl, when I attempt to make a database connection using SQLite,
> I get the following error:
>
> [Tue Jun 23 17:10:22 2009] projectory.cgi:
> DBI->connect(dbname=projectory.sqlite3) failed: database disk image is
> malformed at ./projectory.cgi line 1577
>
> At line 1577 it is executing this code
>
> $dbh = DBI->connect("dbi:SQLite:dbname=projectory.sqlite3","","") or
> die "$DBI::errstr\n";
>
> When I use the sqlite3 tool to do an integrity check, I get the following:
>
> rintintin> sqlite3 projectory.sqlite3
> SQLite version 3.6.15
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> PRAGMA integrity_check;
> ok
> sqlite> .exit
>
> What are some other reasons why from perl it may get the database disk
> image malformed error?
>
> - Craig
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
