Re: DB_DataObject with SQLite
| From: | Alan Knowles | Date: | Thu, 09 Sep 2004 08:43:48 +0000 |
| Subject: | Re: DB_DataObject with SQLite | ||
| References: | 1 | Groups: | php.pear.general php.pear.general |
| Request: | Send a blank email to pear-general+get-14469@lists.php.net to get a copy of this message | ||
have a look at the bugs database for Dataobjects and DB - there have been some patches for this. - maybe add notes to the DB bug report.
For the time being the best work around is to create your database in mysql, generate the schema/files, then change the config to point at the sqlite file.
Regards
Alan
maurício m. maia wrote:
I'm tring DB_DataObject with SQLite, but get this error: [db_error: message="DB Error: DB backend not capable" code=-9 mode=return level=notice prefix="" info="SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name;"] My INI file contains: [DB_DataObject] database = sqlite:////var/www/xml/db/DataObjects/data.db schema_location = /var/www/xml/db/DataObjects/ class_location = /var/www/xml/db/DataObjects/ require_prefix = DataObjects/ class_prefix = DataObjects_ With MySQL all works fine! Any help are welcome. Thanks, Maurício.