CodeIgniter Forums

Full Version: sqlite3 via pdo for php5 on CI 1.6.1?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[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.

El Forum

[eluser]quindo[/eluser]
It seems that sqlite3 is not important enough Sad

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.

El Forum

[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

El Forum

[eluser]Kenzie[/eluser]
Is it possible to update the wiki PDO files with the changes you made to get this working? Thanks.

El Forum

[eluser]quindo[/eluser]
Added to Wiki.