# Reference to member 'sqlite' cannot be resolved without a contextual type. Vapor course

**URL:** <https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040>\
**Category:** Server Side Swift with Vapor\
**Created:** [February 20, 2020, 10:01pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040 "2020-02-20T22:01:07Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![alfred1963](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/alfred1963/32/81574_2.png) [@alfred1963](https://forums.kodeco.com/u/alfred1963)\
**Post date:** [February 20, 2020, 10:01pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/1 "2020-02-20T22:01:07Z")

</div>

![Untitled](https://files.chunter.kodeco.com/original/3X/1/b/1b403a80cdf59abf7800164816fa2cad827c05de.jpeg) I am running into this issue when trying to build, thanks for any help on this error

Reference to member ‘sqlite’ cannot be resolved without a contextual type

---

<div class="post-metadata">

**Author:** ![0xtim](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/0xtim/32/111111_2.png) [@0xtim](https://forums.kodeco.com/u/0xtim)\
**Post date:** [February 22, 2020, 6:02am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/2 "2020-02-22T06:02:32Z")

</div>

@alfred1963 are you running on Xcode 11.4 Beta? If so, that’s a known issue with the 5.2 compiler and you need to provide the full database identifier.

If not, does `Acronym` conform to `SQLiteModel`?

---

<div class="post-metadata">

**Author:** ![dairan](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/dairan/32/104870_2.png) [@dairan](https://forums.kodeco.com/u/dairan)\
**Post date:** [March 26, 2020, 11:40pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/3 "2020-03-26T23:40:20Z")

</div>

UPDATE: I found the solution at: [Vapor 3: Swift 5.2 Regression - Vapor - Swift Forums](https://forums.swift.org/t/vapor-3-swift-5-2-regression/34764)

~~Please. I upgrade to Swift 5.2 compiler and now I am getting same error. I didn’t figure out how ‘provide full database identifier’. Could you give me a example?  
My Code is  
` migrations.add(model: Todo.self, database: .sqlite)`

---

<div class="post-metadata">

**Author:** ![onurtunalj](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/onurtunalj/32/107963_2.png) [@onurtunalj](https://forums.kodeco.com/u/onurtunalj)\
**Post date:** [March 30, 2020, 7:03am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/5 "2020-03-30T07:03:37Z")

</div>

Try using `DatabaseIdentifier<Todo.Database>.sqlite`

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [April 6, 2020, 8:12am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/6 "2020-04-06T08:12:25Z")

</div>

@alfred1963 Do you still have issues with this?

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [April 6, 2020, 8:14am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/7 "2020-04-06T08:14:13Z")

</div>

@dairan Thank you for sharing the link. Do you still have issues with this?

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [April 6, 2020, 8:14am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/8 "2020-04-06T08:14:29Z")

</div>

@onurtunalj Thank you for sharing this!

---

<div class="post-metadata">

**Author:** ![alfred1963](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/alfred1963/32/81574_2.png) [@alfred1963](https://forums.kodeco.com/u/alfred1963)\
**Post date:** [April 6, 2020, 10:21pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/9 "2020-04-06T22:21:56Z")

</div>

I decided to rework my project in Vapor 4, from scratch. I am still learning how to go about.

Thanks for your help and yes please remove the post!

Regards Alfred Schmidt

---

<div class="post-metadata">

**Author:** ![longnguyen91](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/longnguyen91/32/109507_2.png) [@longnguyen91](https://forums.kodeco.com/u/longnguyen91)\
**Post date:** [April 14, 2020, 8:32pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/10 "2020-04-14T20:32:14Z")

</div>

I have the same issue and your code make it run. Can you explain me why ? It happen after I update xcode 11.4

---

<div class="post-metadata">

**Author:** ![0xtim](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/0xtim/32/111111_2.png) [@0xtim](https://forums.kodeco.com/u/0xtim)\
**Post date:** [April 17, 2020, 12:56pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/11 "2020-04-17T12:56:33Z")

</div>

It’s a bug in the Swift 5.2 compiler - you can read about it in the forum link posted above.

---

<div class="post-metadata">

**Author:** ![quinwoodz](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/quinwoodz/32/81494_2.png) [@quinwoodz](https://forums.kodeco.com/u/quinwoodz)\
**Post date:** [April 20, 2020, 2:39am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/12 "2020-04-20T02:39:26Z")

</div>

Still having issue and the above fix doesnt seem to working. `migrations.add(model: Acronym.self, database: DatabaseIdentifier<SQLiteDatabase>.sqlite)`

Throws the error  
Cannot convert value of type ‘DatabaseIdentifier’ to expected argument type ‘DatabaseIdentifier\<Acronym.Database\>’

---

<div class="post-metadata">

**Author:** ![quinwoodz](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/quinwoodz/32/81494_2.png) [@quinwoodz](https://forums.kodeco.com/u/quinwoodz)\
**Post date:** [April 20, 2020, 2:43am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/13 "2020-04-20T02:43:53Z")

</div>

LOL fixed it this code worked

```
    migrations.add(model: Acronym.self, database: DatabaseIdentifier<Acronym.Database>.sqlite)

```

---

<div class="post-metadata">

**Author:** ![longnguyen91](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/longnguyen91/32/109507_2.png) [@longnguyen91](https://forums.kodeco.com/u/longnguyen91)\
**Post date:** [April 28, 2020, 1:21am UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/14 "2020-04-28T01:21:55Z")

</div>

Thank you your help, I fixed it 😃.

---

<div class="post-metadata">

**Author:** ![rspishock](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/rspishock/32/81494_2.png) [@rspishock](https://forums.kodeco.com/u/rspishock)\
**Post date:** [May 26, 2020, 5:37pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/15 "2020-05-26T17:37:37Z")

</div>

> [@quinwoodz](#):
>
> ` DatabaseIdentifier<Acronym.Database>.sqlite)`

Thanks for the response! I was having the same problem and this solved it.

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [July 4, 2020, 11:58pm UTC](https://forums.kodeco.com/t/reference-to-member-sqlite-cannot-be-resolved-without-a-contextual-type-vapor-course/99040/16 "2020-07-04T23:58:47Z")

</div>

@quinwoodz Thank you for sharing your solution - much appreciated!
