Data base is getting copied but queries are not working about cordova-plugin-dbcopy

[an-rahulpandey]

I think renaming the db from mysql to .db will not work.
That's why you are getting this -

message: "sqlite3_prepare_v2 failure: file is encrypted or is not a database"

Check these out for the utility -

http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

[khanSufiyan]

I made a test db with DB Browser for SQLite and still got that same error

[an-rahulpandey]

Can you post some code?

[khanSufiyan]

DB COPY CODE
if (window.cordova) {
window.plugins.sqlDB.copy("CSIR_DB.db",0, function() {
console.log("done coping");
db = $cordovaSQLite.openDB({name: "CSIR_DB.db", location:'default'});
}, function(error) {
console.error("There was an error copying the database: " +JSON.stringify(error) );
db = $cordovaSQLite.openDB({name: "CSIR_DB.db", location: 'default'});
});
console.log("Android");
}else{
//db = $cordovaSQLite.openDB({name: "CSIR_DB .db", location: 0});
db = window.openDatabase("CSIR_DB.db", '1', 'CSIR_DB', 1024 * 1024 * 100); // browser
console.log("browser");
}

SELECT QUERY
var query = "select lab_id,lab_name,lab_abbr from lab_master";
$scope.lablist = new Array();

    $cordovaSQLite.execute(db, query, []).then(function(res)
     {
      if(res.rows.length > 0)
       {
        console.log("in for", res.rows.item(i).lab_id,
                  res.rows.item(i).lab_name,
                  res.rows.item(i).lab_abbr);
          for(var i = 0; i < res.rows.length; i++) 
            {
                var obj = {
                  lab_id: res.rows.item(i).lab_id,
                  lab_name: res.rows.item(i).lab_name,
                  lab_abbr:res.rows.item(i).lab_abbr
                };
                 $scope.lablist.push(obj);
            }
       } else 
        {
          console.log("No results found");
        }
    });

[an-rahulpandey]

Are you getting this error -

message: "sqlite3_prepare_v2 failure: file is encrypted or is not a database"

Can you check the native error log in monitor (if using Android) or Xcode?

[khanSufiyan]

Hi Rahul
I reinstalled the plugin and and made a new db file with DB Browser for SQLite and it started to work!!!
I think there was an error with the db.
Thanks for the support man...