Welcome Guest, Not a member yet? Register   Sign In
sqlite3 via pdo for php5 on CI 1.6.1?
#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.
#2

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

[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
#4

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

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




Theme © iAndrew 2016 - Forum software by © MyBB