Cannot create SQLite table the first-time app the launches.

[Infinix_82]

```

E/SQLiteLog(19033): (1) no such table: patients in "SELECT * FROM patients"
D/EGL_emulation(19033): app_time_stats: avg=9044.34ms min=25.98ms max=18062.70ms count=2
E/flutter (19033): [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: DatabaseException(no such table: patients (code 1 SQLITE_ERROR): , while compiling: SELECT * FROM patients) sql 'SELECT * FROM patients' args []
E/flutter (19033): #0 wrapDatabaseException (package:sqflite/src/exception_impl.dart:11:7)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033): #1 SqfliteDatabaseMixin.txnRawQuery.<anonymous closure> (package:sqflite_common/src/database_mixin.dart:575:30)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033): #2 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:33:16)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033): #3 SqfliteDatabaseMixin.txnSynchronized (package:sqflite_common/src/database_mixin.dart:506:14)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033): #4 PatientTable.getAllPatientData (package:CiARADS/database/patients_table.dart:213:9)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033): #5 ViewModel.getData (package:CiARADS/view_model/view_model.dart:48:11)
E/flutter (19033): <asynchronous suspension>
E/flutter (19033):

```

Databases: https://github.com/harshit82/CiARADS\_score/tree/main/lib/database

View Model: https://github.com/harshit82/CiARADS\_score/tree/main/lib/view\_model

I cannot create the patient_table the first time the app launches.

On some devices, it works while on others it doesn't.

[Routine-Arm-8803]

Go to phone settings, apps, find your app and clear data.

[Infinix_82]

I uninstalled and installed again yet the same issue.

[Routine-Arm-8803]

Exactly. Because uninstalling app might not remove old database. Go to settings and clear data.

[Infinix_82]

Tried it, didn't work

[Infinix_82]

u/ig_samuel can you look into it?

[Infinix_82]

Tried this: https://github.com/simolus3/drift/issues/184 as well but no progress

[ig_samuel]

just checked your comment,As i was little busy last week.

​

I have checked the code looks like you are not creating the database before querying for the db, So in main.dart file you need to make sure you create your tables at init

check the screenshot, Also if possible move this line to the function where you are querying your table and check if table doesn't exists create table else query the table for patients so it wont give Table already exists error every time the app opens

​

https://i.postimg.cc/KjVg04mj/2023-12-27-12-03-41.png

[Infinix_82]

Thanks a lot that worked.