use sqlite3,why is there error??

[eluser]Unknown[/eluser]

Code:

Fatal error: Call to a member function execute() on a non-object in E:\PHP\OUR\ou118.com\system\database\drivers\pdo\pdo_driver.php on line 193

why is there errror??

[eluser]Beginers[/eluser]
how did you call this function?

[eluser]alexwenzel[/eluser]
today i tried again to get CI work with sqlite and i ended up with the above error.

Here is my config and the controller i use: http://pastebin.com/84drvHaX

[eluser]versatek[/eluser]
Take a look at this link: http://khromov.wordpress.com/2012/06/22/...databases/ Hopefully it helps. Also, have you made changes to your mod to support sqlite3?

[eluser]mrgswift[/eluser]
[quote author="theworld" date="1346331503"]

Code:

Fatal error: Call to a member function execute() on a non-object in E:\PHP\OUR\ou118.com\system\database\drivers\pdo\pdo_driver.php on line 193

why is there errror??[/quote]

I was wondering if you ever figured out what the problem was? I am getting the exact same error.


Thanks!

[eluser]alexwenzel[/eluser]
[quote author="mrgswift" date="1368497982"][quote author="theworld" date="1346331503"]

Code:

Fatal error: Call to a member function execute() on a non-object in E:\PHP\OUR\ou118.com\system\database\drivers\pdo\pdo_driver.php on line 193

why is there errror??[/quote]

I was wondering if you ever figured out what the problem was? I am getting the exact same error.


Thanks![/quote]

Use a database manager for sqlite and create a database (if not already there) and your tables.

Check out my blog post at http://codeigniter-blog.de/110/sqlite-with-codeigniter/ for more details

[eluser]mrgswift[/eluser]
[quote author="alexwenzel" date="1368508634"][quote author="mrgswift" date="1368497982"][quote author="theworld" date="1346331503"]

Code:

Fatal error: Call to a member function execute() on a non-object in E:\PHP\OUR\ou118.com\system\database\drivers\pdo\pdo_driver.php on line 193

why is there errror??[/quote]

I was wondering if you ever figured out what the problem was? I am getting the exact same error.


Thanks![/quote]

Use a database manager for sqlite and create a database (if not already there) and your tables.

Check out my blog post at http://codeigniter-blog.de/110/sqlite-with-codeigniter/ for more details[/quote]


Thanks so much for the reply! I went ahead and did what you said. I created my sqlite3 database and all my tables in adminer and even inserted the necessary data using adminer, but I am still getting the same error message.

Fatal error: Call to a member function execute() on a non-object in ...\system\database\drivers\pdo\pdo_driver.php on line 193

My application/config/database.php is identical to yours with the exception of the sqlite filename.

I am not sure what I am doing wrong. I am assuming that if adminer accepts the tables and insert commands I give to it, there shouldn't be any problems.

I am wondering if the CMS I am trying to run on top of Codeigniter just won't work with SQLite.

Thanks again for your help!