Re: [Cgi-session-user] Trouble with C::S::SQLite

[Puneet K. <pu...@ei...>]

Mark Stosberg wrote:
..
> 
> You could try DBI->trace(3) to turn on very verbose database debugging.
> 


Thanks for you help Mark. I turned on the trace, and got the following
relevant lines in the error log (I've taken out the datetime stamp
between the [] for brevity). I hope this sheds some light to you (or
anyone else)... it has me completely stumped, and has brought my work to
a standstill :-(. Still, thanks a ton for your assistance thus far.



[]     DBI 1.48-ithread default trace level set to 0x0/3 (pid 4832)\r,
referer: http://localhost/punkish/index.cgi
[]     -> STORE for DBD::SQLite::db (DBI::db=HASH(0x1e0a488)~INNER
'sqlite_handle_binary_nulls' 1) thr#22434c\r, referer:
http://localhost/punkish/index.cgi
[]     STORE DBI::db=HASH(0x1e0a488) 'sqlite_handle_binary_nulls' =>
1\r, referer: http://localhost/punkish/index.cgi
[] $h->{'sqlite_handle_binary_nulls'}=1 ignored for invalid
driver-specific attribute\r, referer: http://localhost/punkish/index.cgi
[]     <- STORE= '' at sqlite.pm line 18 via
C:/Perl/site/lib/CGI/Session/Driver.pm line 27\r, referer:
http://localhost/punkish/index.cgi
[]     -> prepare_cached in DBD::_::db for DBD::SQLite::db
(DBI::db=HASH(0x1e0110c)~0x1e0a488 'SELECT a_session FROM sessions WHERE
id=?' undef 3) thr#22434c\r, referer: http://localhost/punkish/index.cgi
[] 1   -> FETCH for DBD::SQLite::db (DBI::db=HASH(0x1e0a488)~INNER
'CachedKids') thr#22434c\r, referer: http://localhost/punkish/index.cgi
[]     .. FETCH DBI::db=HASH(0x1e0a488) 'CachedKids' = undef\r, referer:
http://localhost/punkish/index.cgi
[] 1   <- FETCH= undef at DBI.pm line 1606 via
C:/Perl/site/lib/CGI/Session/Driver/DBI.pm line 61\r, referer:
http://localhost/punkish/index.cgi
[] 1   -> STORE for DBD::SQLite::db (DBI::db=HASH(0x1e0a488)~INNER
'CachedKids' HASH(0x1e27124)) thr#22434c\r, referer:
http://localhost/punkish/index.cgi
[]     STORE DBI::db=HASH(0x1e0a488) 'CachedKids' => HASH(0x1e27124)\r,
referer: http://localhost/punkish/index.cgi
[] 1   <- STORE= 1 at DBI.pm line 1607 via
C:/Perl/site/lib/CGI/Session/Driver/DBI.pm line 61\r, referer:
http://localhost/punkish/index.cgi
[] 1   -> prepare for DBD::SQLite::db (DBI::db=HASH(0x1e0a488)~INNER
'SELECT a_session FROM sessions WHERE id=?' undef) thr#22434c\r,
referer: http://localhost/punkish/index.cgi
[]     New DBI::st (for DBD::SQLite::st, parent=DBI::db=HASH(0x1e0a488),
id=)\r, referer: http://localhost/punkish/index.cgi
[]
dbih_setup_handle(DBI::st=HASH(0x1e0a5a8)=>DBI::st=HASH(0x1e27154),
DBD::SQLite::st, 1e0a5b4, Null!)\r, referer:
http://localhost/punkish/index.cgi
[]     dbih_make_com(DBI::db=HASH(0x1e0a488), 1d53484, DBD::SQLite::st,
124, 0) thr#22434c\r, referer: http://localhost/punkish/index.cgi
[] sqlite trace: prepare statement: SELECT a_session FROM sessions WHERE
id=?\r, referer: http://localhost/punkish/index.cgi
[] 1   <- prepare= DBI::st=HASH(0x1e0a5a8) at DBI.pm line 1618 via
C:/Perl/site/lib/CGI/Session/Driver/DBI.pm line 61\r, referer:
http://localhost/punkish/index.cgi
[]     <- prepare_cached= DBI::st=HASH(0x1e0a5a8) at DBI.pm line 61 via
C:/Perl/site/lib/CGI/Session.pm line 662\r, referer:
http://localhost/punkish/index.cgi
[]     -> execute for DBD::SQLite::st (DBI::st=HASH(0x1e0a5a8)~0x1e27154
'009b29d8d7db6a9ae0239dcbd7c61c3c') thr#22434c\r, referer:
http://localhost/punkish/index.cgi
[] sqlite trace: bind into 0x1e2719c: 1 =>
009b29d8d7db6a9ae0239dcbd7c61c3c (0) pos 0\r, referer:
http://localhost/punkish/index.cgi
[] \r, referer: http://localhost/punkish/index.cgi
[] sqlite trace: Execute returned 1 cols\r, referer:
http://localhost/punkish/index.cgi
[] \r, referer: http://localhost/punkish/index.cgi
[]     <- execute= '0E0' at DBI.pm line 65 via
C:/Perl/site/lib/CGI/Session.pm line 662\r, referer:
http://localhost/punkish/index.cgi
[]     -> fetchrow_array for DBD::SQLite::st
(DBI::st=HASH(0x1e0a5a8)~0x1e27154) thr#22434c\r, referer:
http://localhost/punkish/index.cgi
[]     <- fetchrow_array= ( ) [0 items] row-1 at DBI.pm line 67 via
C:/Perl/site/lib/CGI/Session.pm line 662\r, referer:
http://localhost/punkish/index.cgi
[] [Mon Mar  6 15:44:04 2006] index.cgi: DBD::SQLite::db prepare failed:
no such table: sessions(1) at dbdimp.c line 269 at
C:/Perl/site/lib/CGI/Session/Driver/sqlite.pm line 43 during global
destruction.\r, referer: http://localhost/punkish/index.cgi
[] [Mon Mar  6 15:44:04 2006] index.cgi: \t(in cleanup) DBD::SQLite::db
prepare failed: no such table: sessions(1) at dbdimp.c line 269 at
C:/Perl/site/lib/CGI/Session/Driver/sqlite.pm line 43 during global
destruction.\r, referer: http://localhost/punkish/index.cgi