Ionic-framework: No provider for SQLite

[RahulChamle]

Ionic version: (check one with "x")
ionic -3.0.1
Ionic App Scripts: 1.3.0
Angular Core: 4.0.0
Angular Compiler CLI: 4.0.0
Node: 7.5.0
OS Platform: Linux 4.4

I follow all instructions form main ionic website i.e https://ionicframework.com/docs/native/sqlite/

but still i get error "No providers for SQLite"

Related code:
this.sqlite.create({
name: 'data.db',
location: 'default'
})
.then((db: SQLiteObject) => {
db.executeSql('create table danceMoves(name VARCHAR(32))', {})
.then(() => console.log('Executed SQL'))
.catch(e => console.log(e));

    })
    .catch(e => console.log(e));

-

[jgw96]

Hello! Thanks for opening an issue with us! As this seems like more of a support question I will urge that you ask this question on our forum or on our slack channel. Thanks for using Ionic!

[matejuh]

I have the same problem. I don't think it's support question but most probably a regression after ionic-native update.

[RahulChamle]

Ya It works for me. Actually i forget to import dependency in ngModule
array of app.module.ts.

Thank You
Chamle Rahul

On Fri, Apr 21, 2017 at 12:04 AM, matejuh [e-mail] wrote:

I have the same problem. I don't think it's support question but most
probably a regression after ionic-native update.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/driftyco/ionic/issues/11270#issuecomment-295848883,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AM7HUkD3e2FCp5Zf5BnX9vCj16Ux4N4cks5rx6UrgaJpZM4NBogL
.

[mst1903]

I have the same problem, what's the solution? @RahulChamle what import dependency do you mean? In the instructions (https://ionicframework.com/docs/native/sqlite/) there is nothing about an import dependency?!

[matejuh]

@mst1903 Put into providers in app.module.ts the SQLite provider. How to add each provider is mentioned here: https://ionicframework.com/docs/native/.

[raphaelluiz128]

hello guys whats the directory ?

[yogeshbansal]

In the app.module.ts, Add 'SQLite' in the Provider section like below and import {SQLite} from '@ionic-native/sqlite'. Hope it should resolve the issue
providers: [
StatusBar,
SplashScreen,
Camera,
SQLite
]

[BonnerAthos]

Adding SQLite in the Provider, salving my day!

Thanks guys

[ionitron-bot[bot]]

Thanks for the issue! This issue is being locked to prevent comments that are not relevant to the original issue. If this is still an issue with the latest version of Ionic, please create a new issue and ensure the template is fully filled out.