"MissingPluginException(No implementation found for method getDatabasesPath on channel com.tekartik.sqflite)" when i use floor database

Question

I'm trying to use floor database but when i want to build database i got below error :

E/flutter (26007): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: MissingPluginException(No implementation found for method getDatabasesPath on channel com.tekartik.sqflite)
E/flutter (26007): #0      MethodChannel._invokeMethod (package:flutter/src/services/platform_channel.dart:154:7)
E/flutter (26007): <asynchronous suspension>
E/flutter (26007): #1      MethodChannel.invokeMethod (package:flutter/src/services/platform_channel.dart:329:12)
E/flutter (26007): #2      invokeMethod (package:sqflite/src/sqflite_impl.dart:17:13)
E/flutter (26007): #3      SqfliteDatabaseFactoryImpl.invokeMethod (package:sqflite/src/factory_impl.dart:82:7)
E/flutter (26007): #4      SqfliteDatabaseFactoryMixin.safeInvokeMethod.<anonymous closure> (package:sqflite_common/src/factory_mixin.dart:25:35)
E/flutter (26007): #5      wrapDatabaseException (package:sqflite/src/exception_impl.dart:7:32)
E/flutter (26007): #6      SqfliteDatabaseFactoryImpl.wrapDatabaseException (package:sqflite/src/factory_impl.dart:78:7)
E/flutter (26007): #7      SqfliteDatabaseFactoryMixin.safeInvokeMethod (package:sqflite_common/src/factory_mixin.dart:25:7)
E/flutter (26007): #8      SqfliteDatabaseFactoryMixin.getDatabasesPath (package:sqflite_common/src/factory_mixin.dart:143:26)
E/flutter (26007): #9      getDatabasesPath (package:sqflite/sqflite.dart:168:54)
E/flutter (26007): #10     DatabaseFactoryExtension.getDatabasePath (package:floor/src/sqflite_database_factory.dart:23:23)
E/flutter (26007): #11     _$AppDatabaseBuilder.build (package:fluttermiwallet/db/database.g.dart:46:40)
E/flutter (26007): #12     main (package:fluttermiwallet/main.dart:9:67)
E/flutter (26007): #13     _runMainZoned.<anonymous closure>.<anonymous closure> (dart:ui/hooks.dart:241:25)
E/flutter (26007): #14     _rootRun (dart:async/zone.dart:1184:13)
E/flutter (26007): #15     _CustomZone.run (dart:async/zone.dart:1077:19)
E/flutter (26007): #16     _runZoned (dart:async/zone.dart:1619:10)
E/flutter (26007): #17     runZonedGuarded (dart:async/zone.dart:1608:12)
E/flutter (26007): #18     _runMainZoned.<anonymous closure> (dart:ui/hooks.dart:233:5)
E/flutter (26007): #19     _startIsolate.<anonymous closure> (dart:isolate-patch/isolate_patch.dart:301:19)
E/flutter (26007): #20     _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:168:12)

my flutter version:

Flutter 1.17.5 • channel stable • https://github.com/flutter/flutter.git
Framework • revision 8af6b2f038 (13 days ago) • 2020-06-30 12:53:55 -0700
Engine • revision ee76268252
Tools • Dart 2.8.4

the version of floor,floor_generator and build_runner are as below :

environment:
  sdk: ">=2.7.0 <3.0.0"

dependencies:
  flutter:
    sdk: flutter
  cupertino_icons: ^0.1.3
  floor: ^0.13.0

dev_dependencies:
  flutter_test:
    sdk: flutter
  floor_generator: ^0.13.0
  build_runner: ^1.7.3

in the main.dart i build my database using $FloorAppDatabase :

void main() async {
  WidgetsFlutterBinding.ensureInitialized();
  var db = await $FloorAppDatabase.databaseBuilder('mydb.db').build();
  runApp(MyApp(db));
}

and in the android folder GeneratedPluginRegistrant.java:

package io.flutter.plugins;

import androidx.annotation.Keep;
import androidx.annotation.NonNull;

import io.flutter.embedding.engine.FlutterEngine;
import io.flutter.embedding.engine.plugins.shim.ShimPluginRegistry;

/**
 * Generated file. Do not edit.
 * This file is generated by the Flutter tool based on the
 * plugins that support the Android platform.
 */
@Keep
public final class GeneratedPluginRegistrant {
  public static void registerWith(@NonNull FlutterEngine flutterEngine) {
    ShimPluginRegistry shimPluginRegistry = new ShimPluginRegistry(flutterEngine);
      io.flutter.plugins.flutter_plugin_android_lifecycle.FlutterAndroidLifecyclePlugin.registerWith(shimPluginRegistry.registrarFor("io.flutter.plugins.flutter_plugin_android_lifecycle.FlutterAndroidLifecyclePlugin"));
    flutterEngine.getPlugins().add(new io.flutter.plugins.imagepicker.ImagePickerPlugin());
    flutterEngine.getPlugins().add(new io.flutter.plugins.pathprovider.PathProviderPlugin());
    flutterEngine.getPlugins().add(new io.flutter.plugins.sharedpreferences.SharedPreferencesPlugin());
    flutterEngine.getPlugins().add(new com.tekartik.sqflite.SqflitePlugin());
  }
}

and MainActivity.kt:

import android.os.Bundle
import io.flutter.app.FlutterActivity
import io.flutter.plugins.imagepicker.ImagePickerPlugin


class MainActivity : FlutterActivity() {
    override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        ImagePickerPlugin.registerWith(
                registrarFor("io.flutter.plugins.imagepicker.ImagePickerPlugin"))

    }

}

score 31 · Answer 1 · answered Oct 25 '20 at 07:18

31

This happen due to the newly added dependencies, where in my case the following command worked. Go to the terminal and then

flutter clean

And re run the project

answered Oct 25 '20 at 07:18

Niroshan Ratnayake

3,433
3
20
18

1

This is solved my same problem <3 – Abdullah Bahattab Nov 27 '21 at 20:54
1

This solved my problem as well – daydreamer Jun 21 '22 at 23:57

score 13 · Answer 2 · answered Dec 29 '21 at 16:50

13

Silly me, I ran into this error when trying to run my sqflite app in Chrome. Of course sqflite does not support web, so I shouldn't be surprised it's throwing an error! Running in a mobile emulator (or macos) should work.

answered Dec 29 '21 at 16:50

qix

7,228
1
55
65

score 11 · Accepted Answer · edited Jun 08 '21 at 13:16

I finally found my answer. I must add Sqflite plugin in my MainActivity: SqflitePlugin.registerWith(registrarFor("com.tekartik.sqflite.SqflitePlugin"))

my MainActivity changed as below:

import android.os.Bundle
import io.flutter.app.FlutterActivity
import io.flutter.plugins.imagepicker.ImagePickerPlugin
import com.tekartik.sqflite.SqflitePlugin


class MainActivity : FlutterActivity() {
    override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        ImagePickerPlugin.registerWith(
                registrarFor("io.flutter.plugins.imagepicker.ImagePickerPlugin"))
        SqflitePlugin.registerWith(registrarFor("com.tekartik.sqflite.SqflitePlugin"))

    }

}

this now throws error : `Unresolved reference: registrarFor`. how do one resolve this? — Raines, Dec 23 '20 at 19:45

score 9 · Answer 4 · edited Feb 08 '21 at 08:13

9

flutter clean
flutter run

This worked for me.

edited Feb 08 '21 at 08:13

Jin Lee

3,194
12
46
86

answered Feb 08 '21 at 07:33

Shashimal

91
2
2

score 7 · Answer 5 · answered Apr 01 '21 at 07:47

7

If you are facing this only on release build then build your release app with proguard rules

    buildTypes {
        release {
            signingConfig signingConfigs.debug
            minifyEnabled true
            useProguard true
            proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), 'proguard-rules.pro'
        }
    }

Create a file on the directory android/app/ name the file as proguard-rules.pro and write inside:

#Flutter Wrapper
-keep class io.flutter.app.** { *; }
-keep class io.flutter.plugin.**  { *; }
-keep class io.flutter.util.**  { *; }
-keep class io.flutter.view.**  { *; }
-keep class io.flutter.**  { *; }
-keep class io.flutter.plugins.**  { *; }
-keep class androidx.lifecycle.DefaultLifecycleObserver

answered Apr 01 '21 at 07:47

SK. Fuad

371
4
9

This is the only thing that worked for me! Thanks! You've just saved my day. Though I still don't really understand why it works... – Michael Miriti May 02 '21 at 19:12
2

Built-in code shrinker on Gradle obfuscate some classes and remove some dead code. Built-in code shrinker removes third party plugin's classes also. For that reason we had to add proguard-rules for prevent obfuscate of our third party plugin's classes. – SK. Fuad Jun 18 '21 at 09:10
You just made my day :) I had the same issue and this fixed it. Thank you! – Felix Aug 20 '21 at 11:51

score 5 · Answer 6 · answered Apr 05 '21 at 14:03

5

Instead of using HotReload / Run, stop the application and start again.

answered Apr 05 '21 at 14:03

Eder Rodrigues

51
1
1

alextk · Answer 7 · 2020-07-16T05:59:04.230

I would try several things:

first ensure that all plugins are indeed registered by trying for example to use SharedPreferences instead of sqflite
Follow the plugin migration guide: https://flutter.dev/docs/development/packages-and-plugins/plugin-api-migration if your app was not created recently
Try to remove the ImagePickerPlugin registration in onCreate (or basically get rid of the onCreate in your MainActivity).
Try to delete the android folder and create the project again

score 3 · Answer 8 · answered Jan 26 '21 at 13:03

In my case, I have done below steps to make it work:

Create Application class (if not already created) for android in the same package where you have MainActivity.

MyApp.kt

package com.example.flutter_example

import io.flutter.app.FlutterApplication;
import io.flutter.plugin.common.PluginRegistry;
import io.flutter.plugin.common.PluginRegistry.PluginRegistrantCallback;
import com.tekartik.sqflite.SqflitePlugin

class MyApp : FlutterApplication(), PluginRegistrantCallback {

    override fun registerWith(registry: PluginRegistry) {
        com.tekartik.sqflite.SqflitePlugin.registerWith(
                registry.registrarFor("com.tekartik.sqflite.SqflitePlugin"))
    }
}

Now update your Android manifest file and provide your Application class.

<application
        android:name=".MyApp"

Now clean and run the project.

score 2 · Answer 9 · answered Jan 06 '23 at 08:42

2

when you run project on chrome, it's normal that the program show an error because sqflite doesn't support on chrome, just re run the project on android/iOs and the error will disappear.

answered Jan 06 '23 at 08:42

Dropped Out

23
2

Needs more clarity – Tejaswini Dev Jan 09 '23 at 13:27

VISHAL VINAYRAM · Answer 10 · 2022-09-26T09:42:07.047

1

This happended even to me a,just stop the app and rebuild it and it may work as it means that the dependencies are not present.If even that doesn't work ,then "flutter clean" will do your job

edited Sep 26 '22 at 09:42

answered Sep 26 '22 at 09:41

VISHAL VINAYRAM

11
2

rubStackOverflow · Answer 11 · 2022-10-07T11:50:20.000

I got this error on Flutter Windows and solved by following the docs.

flutter pub add sqflite_common_ffi

Linux/Windows users: https://pub.dev/packages/sqflite_common_ffi

Future<Database>? getDb() {
    _db ??= _initDb();
    return _db;
  }

  // Guaranteed to be called only once.
  Future<Database> _initDb() async {
    Database db;

    if (Platform.isWindows || Platform.isLinux) {
      sqfliteFfiInit();
      var databaseFactory = databaseFactoryFfi;
      db = await databaseFactory.openDatabase(inMemoryDatabasePath);
    } else {
      var databasesPath = await getDatabasesPath();
      final path = '${databasesPath}my_database.db';
      db = await openDatabase(
        path,
        version: 1,
      );
    }
    return db;
  }

"MissingPluginException(No implementation found for method getDatabasesPath on channel com.tekartik.sqflite)" when i use floor database

11 Answers11

Linked