verynoob Posted October 26, 2018 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!
wolstech Posted October 27, 2018 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?
verynoob Posted October 27, 2018 Author 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
wolstech Posted October 28, 2018 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.
Krydos Posted October 28, 2018 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?
verynoob Posted October 28, 2018 Author 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
Recommended Posts