Re: DB_DataObject and SQLite
| From: | Nikhil G. Daddikar | Date: | Tue, 27 Jul 2004 05:25:12 +0000 |
| Subject: | Re: DB_DataObject and SQLite | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-13862@lists.php.net to get a copy of this message | ||
Just wanted to clairify that I am getting this error while running createTables. If i replace the dsn with a mysql one it works so there is nothing wrong with the configuration.
I also tried executing the sql query using sqlite commandline and it works too.
I also don't think there are any issues with permissions, I own the file and it's 0666
1) Has anybody got DB_DataObject to work with SQLite? I tried to use it but I get the following 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;"]