Posted by Andy Hassall on 01/24/07 00:08

On Tue, 23 Jan 2007 18:29:59 -0500, "Jim Carlock" <anonymous@127.0.0.1> wrote:

>"Jim Carlock" wrote:
>: I added the following lines to PHP.INI.
>:
>: extension=php_pdo.dll
>: extension=php_pdo_sqlite.dll
>: extension=php_sqlite.dll
>:
>: specifically in that order. I noticed the extensions getting loaded
>: are alphabetally listed, so I'm thinking that the order of the load
>: doesn't matter.
>:
>: Is that true?
>
>I don't have an answer to that question.

It doesn't appear to matter what order they're listed.

>: And when I use the following statements to create a test.db file...
>
>I forgot to type in the statements. The [extension=php_sqlite.dll]
>line above provides the mechanisms...
>
[snip]

Possibly just to add to the confusion, it appears that php_pdo_sqlite.dll is
linked against SQLite 3.x, but php_sqlite.dll is linked against 2.x:

$ strings php_sqlite.dll | grep -i sqlite[23]
sqlite2
sqlite2_create_function
ext\sqlite\pdo_sqlite2.c

$ strings php_pdo_sqlite.dll | grep -i sqlite[23]
sqlite3_extension_init
sqlite3_get_table() called with two or more incompatible queries

See also:
http://bugs.php.net/bug.php?id=34010
http://bugs.php.net/bug.php?id=31848

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]