SQLite error 14 in ViewController

Question

import GRDB

class MyView: UIViewController{
    override func viewDidLoad() {
    super.viewDidLoad()
        do{
            let dbPool = try DatabasePool(path: "/path/to/database.sqlite")
        }catch let error{
        print(error)
    }
    }
}

error is print SQLite error 14

what is SQLite error 14?

first use GRDB and first Call SqlLite

Why raise Error?

Ios 11.0 Swift 4.0 Grdb 2.10.0

Build to Iphone8 Simulater

check your temp location. – Anbu.Karthik Jul 19 '18 at 09:48 — Anbu.Karthik, Jul 19 '18 at 09:48

score 3 · Accepted Answer · answered Jul 20 '18 at 03:39

SQLite error code 14 means

Unable to open the database file.

You can get the description from there: https://sqlite.org/c3ref/c_abort.html

For your question, what exactly the path is? Are you hard coded the path? Don't hard code the path, use pattern like

let path = NSHomeDirectory() + "/Documents/database.sqlite"

to get your database's path to see if your issue can be solved.

score 1 · Answer 2 · answered Jul 19 '18 at 09:54

The best solution for error 14 is to change the settings in the directory where the database file is stored so that write access is provided to the database file. In order to do so, you can run the following commands in case the web server you are using runs as www-data. ;)

SQLite error 14 in ViewController

2 Answers2