andres felipe tamayo cortes
2010-07-06 22:23:04 UTC
hi,
i installed php5 making:
apt-get install php5-cgi and after this i did apt-get install php5-sqlite3 now im tring to read some data from a sqlite3 database, it appears me this mistake:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in /www/sqlite.php on line 8
file is encrypted or is not a database.
i have been reading and i found that i have to work with PDO so i checked what i have enable with my php opening this code on my browser:
<?php
// Show all information, defaults to INFO_ALL
phpinfo();
// Show just the module information.
// phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);
?>
i found this:
PDO
PDO supportenabled
PDO drivers sqlite, sqlite2, mysql
pdo_mysql
PDO Driver for MySQL, client library version5.1.37
pdo_sqlite
PDO Driver for SQLite 3.xenabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $
SQLite Library 3.6.16
that means that i already have install PDO
after this i looked for php.ini file and add this lines:
extension_dir = "/usr/lib/php5/20060613+lfs" //this its the route where i have the following lines: pdo, pdo_sqlite, sqlite.so
extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
after this i have the same mistake:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in /www/sqlite.php on line 8
file is encrypted or is not a database.
what am i doing wrong? help!!!
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
i installed php5 making:
apt-get install php5-cgi and after this i did apt-get install php5-sqlite3 now im tring to read some data from a sqlite3 database, it appears me this mistake:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in /www/sqlite.php on line 8
file is encrypted or is not a database.
i have been reading and i found that i have to work with PDO so i checked what i have enable with my php opening this code on my browser:
<?php
// Show all information, defaults to INFO_ALL
phpinfo();
// Show just the module information.
// phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);
?>
i found this:
PDO
PDO supportenabled
PDO drivers sqlite, sqlite2, mysql
pdo_mysql
PDO Driver for MySQL, client library version5.1.37
pdo_sqlite
PDO Driver for SQLite 3.xenabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $
SQLite Library 3.6.16
that means that i already have install PDO
after this i looked for php.ini file and add this lines:
extension_dir = "/usr/lib/php5/20060613+lfs" //this its the route where i have the following lines: pdo, pdo_sqlite, sqlite.so
extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
after this i have the same mistake:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in /www/sqlite.php on line 8
file is encrypted or is not a database.
what am i doing wrong? help!!!
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE