#49518 [Opn->Fbk]: can't open encrypted sqlite3 database
| From: | sjoerd@php.net | Date: | Thu, 10 Sep 2009 09:58:52 +0000 |
| Subject: | #49518 [Opn->Fbk]: can't open encrypted sqlite3 database | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-142209@lists.php.net to get a copy of this message | ||
ID: 49518
Updated by: sjoerd@php.net
Reported By: wjzhhr at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: SQLite related
Operating System: windwos xp
PHP Version: 5.3.0
New Comment:
Does it work when you supply the right encryption key as the third
parameter?
SQLite3::__construct ( string $filename [, int $flags [, string
$encryption_key ]] )
Previous Comments:
------------------------------------------------------------------------
[2009-09-10 08:15:49] wjzhhr at gmail dot com
Description:
------------
can't open encrypted database which created by wxSQLite.
<?php
$db = new SQLite3('x.db',SQLITE3_OPEN_READONLY,"1");
$db->exec("PRAGMA KEY='1'");
$result = $db->query('SELECT * FROM xxx');
var_dump($result->fetchArray());
?>
Warning: SQLite3::query(): Unable to prepare statement: 26, file is
encrypted or is not a database
Reproduce code:
---------------
---
From manual page: sqlite3.open
---
Expected result:
----------------
my table: CREATE TABLE xxx(iswho text,itimes int);
liming|1
xiaojie|2
two records.
Expected result:
array(4) {
[0]=>
string(6) "liming"
["iswho"]=>
string(6) "liming"
[1]=>
int(1)
["itimes"]=>
int(1)
}
Actual result:
--------------
Warning: SQLite3::query(): Unable to prepare statement: 26, file is
encrypted or is not a database
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=49518&edit=1