verynoob Posted October 26, 2018 Share Posted October 26, 2018 Hello,I tried to upload my site that was built on CodeIgniter 3 and using SQLite DB,But When I am loading it, it shows error: SQLite3::query(): Unable to prepare statementsqlite3/sqlite3_driver.php It works on my PC (Wamp), but I had the same issue on Xampp and to fix it I had to edit the php.ini file to enable Sqlite 3.can you check if Tommy support SQLIte 3? Thank you! Link to comment Share on other sites More sharing options...
Luigi123 Posted October 27, 2018 Share Posted October 27, 2018 Moved to Customer Service. Link to comment Share on other sites More sharing options...
wolstech Posted October 27, 2018 Share Posted October 27, 2018 I know it's supported on 5.4, not sure if it's enabled on newer versions. What version of PHP are you using? Link to comment Share on other sites More sharing options...
verynoob Posted October 27, 2018 Author Share Posted October 27, 2018 (edited) PHP version 7.2 (ea-php72),tried to switch to php 5.4 and had the same error Edited October 27, 2018 by verynoob Link to comment Share on other sites More sharing options...
wolstech Posted October 28, 2018 Share Posted October 28, 2018 I used to use SQLite, and thought it definitely worked on 5.4...maybe that was 5.3 back when we had Stevie. Either way, Krydos should be able to see this up. Moving so he sees this. Link to comment Share on other sites More sharing options...
Krydos Posted October 28, 2018 Share Posted October 28, 2018 Sqlite is already enabled on Tommy php 7.2 https://krydos.heliohost.org/72/phpinfo.php I just used php 7.2 on Tommy to create a new sqlite database, created a table, inserted some data into the table, and selected the data back out. It all worked and gave no errors. Can you link to the script you're getting that error with? Link to comment Share on other sites More sharing options...
verynoob Posted October 28, 2018 Author Share Posted October 28, 2018 (edited) hmm, I had Sqlite query with 'WITH' clause in it and after removing it, it seems to work, but on my PC (wamp) it works with 'WITH'maybe sqlite driver on server is older version or something? Edited October 28, 2018 by verynoob Link to comment Share on other sites More sharing options...
Recommended Posts