[DBD-SQLite] problems using sqlite with mod_perl in apache

2009-12-01 Thread Mike Campbell
I've developed a small app that uses a webpage to insert/delete data into a sqlite database. The script work find when I run them from the command line but not when run from the webpage. For example, using the following code: $db =

Re: [DBD-SQLite] problems using sqlite with mod_perl in apache

2009-12-01 Thread Darren Duncan
Mike, off-hand it looks like you're trying to use SQLite 2.x and SQLite 3.x on the same database. You can't do this as these 2 SQLite major versions are incompatible with each other, with different file formats, and SQLite 3 won't work with SQLite 2 files. Make sure you are using just

Re: [DBD-SQLite] problems using sqlite with mod_perl in apache

2009-12-01 Thread Mike Campbell
Ok here is what I get. Test using DBD::SQLite (same output when used command-line and via webpage) = the SQLite v3 is 1.27 Test using DBD::SQLite2 (same output when used command-line and via webpage) the SQLite v2 is 0.33 So definately a difference in sqlite versions. I did

Re: [DBD-SQLite] problems using sqlite with mod_perl in apache

2009-12-01 Thread Darren Duncan
Mike Campbell wrote: Ok here is what I get. Test using DBD::SQLite (same output when used command-line and via webpage) = the SQLite v3 is 1.27 Test using DBD::SQLite2 (same output when used command-line and via webpage) the SQLite v2 is 0.33 snip At first glance you seem