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

[Ron S. <ro...@sa...>]

On Mon, 06 Mar 2006 15:56:00 -0600, Puneet Kishor wrote:

Hi Puneet

> [] [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

I tested SQLite with my module CGI::Application::Demo, which is designed to=
 
probe strange environments, by patching the config file cgi-app-four.conf.

And I get the same error!

It's caused by a bug in SQLite, which emits this error when you create the 
database file (as in dsn=3Ddbi:SQLite:dbname=3D/temp/cgi-app-demo.db) for the=
 first 
time, and then try a command such as
 =09eval{$$self{'_dbh'} -> do("drop table $table_name")};
The program I was running to prove this (under Win2K) is create.pl, which=
 ships 
with CGI::Application::Demo

The error msg is emitted despite the eval.

By running create.pl repeatedly, with and without first deleting 
/temp/cgi-app-demo.db, proves that if the database file is present, SQLite=
 does 
not emit this msg, but if the database file is absent, so that running the 
program must create it, then the error msg is emitted by the drop table 
statement. In your case, some other stmt causes the error, but it's the same=
 
problem. I believe that the problem arises with the very first SQL command 
executed after the database file is created.

I'll report it to the author of SQLite.

Warning: Personally, I would never use SQLite in production, anyway.
-- 
Cheers
Ron Savage, ro...@sa... on 7/03/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company