DatabaseException(error code 8: attempt to write a readonly database)

Question

DatabaseException(error code 8: attempt to write a readonly database)

prabavgts opened this issue 3 years ago · 8 comments

DatabaseException(error code 8: attempt to write a readonly database) sql 'INSERT INTO table name ?

_database = await openDatabase(_databaseName,
password: _databaseName,
readOnly: false,
version: 1, // TODO: Change the version method dynamically
onConfigure: onConfigure,
onCreate: onCreate,
onOpen: onOpen,
onUpgrade: onUpgrade
);

Already read only database is false. but why this error?

Answer 1 · 2022-01-28T15:12:07.000Z

What's the value of _databaseName?

Answer 2 · 2022-01-28T15:19:41.000Z

Ex:praba.db

Answer 3 · 2022-01-28T15:21:59.000Z

It's possible that the colon (:) is not valid as a file path. Have you tried using something like "myDatabase.db" for the first argument?

Answer 4 · 2022-01-28T15:23:23.000Z

I am not using the colon.I am just show for an example

the name of db is praba.db

Answer 5 · 2022-01-28T15:24:56.000Z

Could you share the rest of the code?

Answer 6 · 2022-01-29T11:43:49.000Z

Works well now..I don't know what the problem is

Answer 7 · 2022-01-31T12:23:03.000Z

Show this error sometimes. Will you please help me to solve it?

Answer 8 · 2022-01-31T12:31:29.000Z

@PrabavathiKalidoss Without a reproducible sample I wouldn't be able to help you. Could you try creating a repo with a demo that produces the same error?