There was an error "Invalid Password! Please check your password or database name." when I catch connection error.
But connection was successful.
Finally I found the problem. There is a table named "jayr" created in my encrypted database.
I added SQL "DROP TABLE IF EXISTS jayr;" to beginning of my code then problem is gone.
It might help someone.
I found below code in line 150 of /sqlite.js file. In my case something strange happened and table created but there was an error.
And next time tried to connect then this code does not work as expected. Might need to add IF NOT EXISTS check to this
create SQL.
Also might need to find why SQL result was not success.
var res = this.run("CREATE TABLE jayr(name TEXT)");
if(res.error){
throw "Invalid Password! Please check your password or database name.";
}else{
this.run("DROP TABLE jayr")
}
There was an error "Invalid Password! Please check your password or database name." when I catch connection error.
But connection was successful.
Finally I found the problem. There is a table named "jayr" created in my encrypted database.
I added SQL "DROP TABLE IF EXISTS jayr;" to beginning of my code then problem is gone.
It might help someone.
I found below code in line 150 of /sqlite.js file. In my case something strange happened and table created but there was an error.
And next time tried to connect then this code does not work as expected. Might need to add IF NOT EXISTS check to this
create SQL.
Also might need to find why SQL result was not success.