ports/159209: the MDB2 SQLite driver only supports SQLite 2

[Mark Johnston]

>Number:         159209
>Category:       ports
>Synopsis:       the MDB2 SQLite driver only supports SQLite 2
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          doc-bug
>Submitter-Id:   current-users
>Arrival-Date:   Tue Jul 26 14:40:06 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator:     Mark Johnston
>Release:        8.2
>Organization:
>Environment:
FreeBSD oddish.mark-home 8.2-STABLE FreeBSD 8.2-STABLE #0: Mon May 16 18:43:29 EDT 2011     root at oddish.mark-home:/usr/obj/usr/src/sys/GENERIC  i386
>Description:
The MDB2 driver for SQLite (databases/pear-MDB2_Driver_sqlite) only supports SQLite 2; in particular, it doesn't work with SQLite 3. The driver documentation itself doesn't go out of its way to make this obvious, and I thought it would be good to document this in the pkg-descr so that other people don't waste too much time trying to figure out why it doesn't work with SQLite 3.
>How-To-Repeat:
Try the following script with a SQLite 3 database called "./db".

<?php

require_once 'MDB2.php';

$dsn = 'sqlite:///db';
$db = MDB2::factory($dsn);
if (MDB2::isError($db)) {
        die("Error: " . $db->getMessage() . "\n");
}

$db->connect();
if (MDB2::isError($db)) {
        die("Error: " . $db->getMessage() . "\n");
}

?>

When I run this, I get

$ php mdb2_sqlite.php 
Opening dberror is sqlite_open(): file is encrypted or is not a database
>Fix:
I don't think this driver will ever support SQLite 3 since it would need to use PDO. Hopefully the extra note in the pkg-descr will help.

Patch attached with submission follows:

--- pkg-descr	2007-02-08 02:41:29.000000000 -0500
+++ pkg-descr.new	2011-07-26 10:04:44.000000000 -0400
@@ -1,3 +1,3 @@
-This is the SQLite MDB2 driver.
+This is the SQLite MDB2 driver. It currently only supports SQLite 2.
 
 WWW: http://pear.php.net/package/MDB2_Driver_sqlite/


>Release-Note:
>Audit-Trail:
>Unformatted: