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
– Anbu.Karthik

2018-07-19 09:48:14 +00:00
Commented Jul 19, 2018 at 9:48 — Anbu.Karthik
– Anbu.Karthik, Commented Jul 19, 2018 at 9:48

Tim · Accepted Answer · 2018-07-20 03:39:25Z

3

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.

answered Jul 20, 2018 at 3:39

Tim

662 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user10100968 · Accepted Answer · 2018-07-19 09:54:38Z

1

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. ;)

answered Jul 19, 2018 at 9:54

user10100968

Collectives™ on Stack Overflow

SQLite error 14 in ViewController

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related