What string are you using to connect to your database? // My sqlite 3 connection string $db = new PDO('sqlite:stats.sqlite');
// My sqlite 2 connection string $db = new PDO('sqlite2:test.sqlite'); Also, I had to uncomment an extension from php.ini (extension=php_pdo_sqlite.dll), but I don't really know how that translates to a *nix box (since I just mess around with sqlite on a windows machine with apached installed). On Wed, Jan 28, 2009 at 2:10 PM, Tony Bibbs <t...@tonybibbs.com> wrote: > One other note of interest is if I go at the database with sqlite3 from > command line not only can I get in I can run queries jut fine. > > On Wed, Jan 28, 2009 at 12:59 PM, Tony Bibbs <t...@tonybibbs.com> wrote: > >> I have a PHP/SQLite issue. I'm on Kubuntu with PHP 5.2.8. PHPInfo() >> gives: >> >> PDO->PDO drivers: sqlite, mysql, sqlite2 >> pdo_sqlite->SQLite Library: 3.4.2 >> >> Running a very simple query I get an error with the following (via >> print_r): >> Array ( [0] => HY000 [1] => 26 [2] => file is encrypted or is not a >> database ) >> >> What am I missing here? My hunch is the "sqlite2" in the PDO->PDO Drivers >> is causing the problem. Thing is Adept shows me I have all sqlite3 >> packages. > > > -- > Tony Bibbs > Email: t...@tonybibbs.com Phone: 515.554.8046 > Twitter: tonybibbs Skype: tonybibbs > Web: http://www.tonybibbs.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ~Ty _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users