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

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

Rats... exactly the same message as below on Mac OS X 10.3.9 with  
AciveState Perl 5.8.7 and CGI::Session 4.05 downloaded from CPAN using  
DBD::SQLite 1.11 (first instance was on a WinXP box). Here is the  
message --

[Mon Mar  6 18:23:27 2006] index.cgi: DBD::SQLite::db prepare failed:  
no such table: sessions(1) at dbdimp.c line 269 at  
/usr/local/ActivePerl-5.8/lib/site_perl/5.8.7/CGI/Session/Driver/ 
sqlite.pm line 41 during global destruction.
[Mon Mar  6 18:23:27 2006] index.cgi: 	(in cleanup) DBD::SQLite::db  
prepare failed: no such table: sessions(1) at dbdimp.c line 269 at  
/usr/local/ActivePerl-5.8/lib/site_perl/5.8.7/CGI/Session/Driver/ 
sqlite.pm line 41 during global destruction.
[Mon Mar  6 18:23:44 2006] index.cgi: DBD::SQLite::db prepare failed:  
no such table: sessions(1) at dbdimp.c line 269 at  
/usr/local/ActivePerl-5.8/lib/site_perl/5.8.7/CGI/Session/Driver/ 
sqlite.pm line 41 during global destruction.
[Mon Mar  6 18:23:44 2006] index.cgi: 	(in cleanup) DBD::SQLite::db  
prepare failed: no such table: sessions(1) at dbdimp.c line 269 at  
/usr/local/ActivePerl-5.8/lib/site_perl/5.8.7/CGI/Session/Driver/ 
sqlite.pm line 41 during global destruction.

This is very frustrating, and I am at my wits end, so any help/guidance  
from anyone would be very welcome.

Many thanks.


On Mar 6, 2006, at 2:10 PM, Puneet Kishor wrote:

> I upgraded from C::S 3.95 to 4.03 with the hopes of storing the session
> info in SQLite. Have run into a problem that has occupied me for a
> couple of days now. I get the following message that I can't go past --
>
> [Mon Mar 06 13:20:24 2006] [error] 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: ..
>
> [Mon Mar 06 13:20:24 2006] [error] 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: ..
>
> Some background -- using ActiveState Perl 5.8.7. Got the 4.03 ppd from
> Randy Kobes website (I can't find a 4.05 ppd anywhere). I am using
> DBD::SQLite 1.11 (latest version). Other than the problem with the
> session, DBD::SQLite works just fine. I have the requisite table
> "sessions" in my database with the requisite schema.
>
> sqlite> .schema sessions
> CREATE TABLE 'sessions' (
>         id CHAR(32) NOT NULL PRIMARY KEY,
>         a_session TEXT NOT NULL
>     );
> sqlite>
>
>
> Many thanks in advance,


--
Puneet Kishor