+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: sqlite3 via pdo for php5 on CI 1.6.1? (/showthread.php?tid=7970)
sqlite3 via pdo for php5 on CI 1.6.1? - El Forum - 04-29-2008
[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.
sqlite3 via pdo for php5 on CI 1.6.1? - El Forum - 05-06-2008
[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.
sqlite3 via pdo for php5 on CI 1.6.1? - El Forum - 05-07-2008
[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
sqlite3 via pdo for php5 on CI 1.6.1? - El Forum - 05-07-2008
[eluser]Kenzie[/eluser]
Is it possible to update the wiki PDO files with the changes you made to get this working? Thanks.
sqlite3 via pdo for php5 on CI 1.6.1? - El Forum - 05-07-2008
[eluser]quindo[/eluser]
Added to Wiki.