sqlite3 via pdo for php5 on CI 1.6.1? |
[eluser]Kenzie[/eluser]
Has anyone been able to get sqlite3 up and running on the latest release of CI (1.6.1)? I've tried adding the PDO drivers from the wiki, which worked in the past, but no luck on a new PHP 5.2.4 host that seems to have everything I need.
[eluser]quindo[/eluser]
It seems that sqlite3 is not important enough I'm using sqlite3 on my debian system with PHP 5.2.0 and CI 1.6.1. In this post I explain (a bit) what I've done to get sqlite3 working: http://ellislab.com/forums/viewthread/72420/ It works for me while doing selects, doing an insert seems to give the following error: SQL logic error or missing database When I do $this->db->query('SELECT * FROM kado') it works good. When I do $this->db->query("INSERT INTO kado (naam, omschrijving , jarige) VALUES ('22', '3', 1)") it gives the above error. Running the query directly on the database from the commandline works good.
[eluser]quindo[/eluser]
OK, found the problem reported above. The directory the sqlite3 db file was located in didn't have the correct rights assigned to it :-S
[eluser]Kenzie[/eluser]
Is it possible to update the wiki PDO files with the changes you made to get this working? Thanks.
|
Welcome Guest, Not a member yet? Register Sign In |