--- In metabase-dev@yahoogroups.com, Manuel Lemos <mlemos@a...> wrote:
>
> Hello,
>
> on 11/01/2005 05:42 PM jonbouyw said the following:
> > OK the last update, for now, until someone who knows what they are
> > doing can verify what I've done.
> >
> > This one is completing all 16 conformance tests. And now supports
> > persistent connections which I should have done first being as I'm
> > running PHP as an apache module :(
> >
> > It requires the addition of this function to 'manager_sqlite.php'
> > which is meant to stop the duplication of the sqlite native PRIMARY
> > KEY definition for autoincrement.
>
> I am finally integrating your update of the SQLite driver under PHP
> 4.3.11 using the extension from PECL.
>
> I am experiencing a few glitches with the driver test script. Right
> after trying to create tables for the articles and files tables the
> script attempts to delete all the rows in those tables. However, it is
> failing saying that the table does not exist. If I restart the
script it
> succeeds in deleting the rows . Do you have any idea regarding why
> this happens?
>
No I have no idea why that happens.

I'm am aware of it though, strangely it runs right through the test
script, first time, when using a persistent connection without those
problems. But it doesn't let go of the persistent connection to the
resultant database. Which is probably related to the non persistent
connection problem.

It's strange though, even with a non-persistent connection, because
after repeating the script a couple of times it works fine.

Apologies, I would have replied sooner but I have spent the last few
days in hospital.

> Another matter, why do you touch the database file and test whether it
> is readable and writable before creating the database file? Is it to
> test whether you can write to the database file directory?
>

Yes it's just another layer to assure that file permissions are set
(or can be set) correctly on the server, thereby giving the user a
better clue why they are unable to create a database. It's just a
habit I've got into with SQLite databases.

> --
>
> Regards,
> Manuel Lemos
>
> Metastorage - Data object relational mapping layer generator
> http://www.metastorage.net/
>
> PHP Classes - Free ready to use OOP components written in PHP
> http://www.phpclasses.org/
>