Error: Database location or iosDatabaseLocation value is now mandatory in openDatabase call

if you are using Cordova sqlite plugin you may have this issue while open local DB file.

 _sqlLiteDB = $cordovaSQLite.openDB({ name: "testDB.db", iosDatabaseLocation:'default'}); 
// Works on android but not in iOS

                   

Error: Database location or iosDatabaseLocation value is now mandatory in openDatabase call

Use below to open DB:
window.sqlitePlugin.openDatabase({ name: "testDB.db", location: 2, createFromLocation: 1});

Solution:

if(isAndroid){
                    // Works on android but not in iOS

                    _sqlLiteDB = $cordovaSQLite.openDB({ name: "testDB.db", iosDatabaseLocation:'default'}); 

} else{
                    // Works on iOS 

                    _sqlLiteDB = window.sqlitePlugin.openDatabase({ name: "testDB.db", location: 2, createFromLocation: 1}); 

 }

Warning: sqlite3.c Ambiguous expansion of macro - Xcode - iOS

Plugin: cordova-sqlite-storage

Version: 1.4.1

Warning: sqlite3.c Ambiguous expansion of macro - Xcode - iOS

This issue also helps on native app code. 

Issue Solution:

Open Xcode project Build settings

add “-Wno-ambiguous-macro” into  “Other C flags” 

error JSON.stringify()ing argument: RangeError: Invalid Date

There is minor bug in contact plugin in cordova ionic. contact list is loaded with error due to the birthdate field in contact card. Its bad practice to keep minor error in execution of code, It may effect to different OS versions.

error JSON.stringify()ing argument: RangeError: Invalid Date

Cordova Plugin: cordova-plugin-contacts
Verison: 2.1.0 "Contacts"

Open convertUtils.js file  

File Path: plugins/cordova-plugin-contacts/www/convertUtils.js

Find function "toCordovaFormat" and remove below try-catch code.

 try {
         contact.birthday = new Date(parseFloat(value));
} catch (exception){
          console.log("Cordova Contact toCordovaFormat error: exception creating date.");
}

add below code instead of try-catch

if (value !== null) {

        try {

                contact.birthday = new Date(parseFloat(value));

               

                //we might get 'Invalid Date' which does not throw an error

                //and is an instance of Date.

                if (isNaN(contact.birthday.getTime())) {

                       contact.birthday = null;

               }

               

        } catch (exception){

                console.log("Cordova Contact toCordovaFormat error: exception creating date.");

        }

}

Check below screenshot for better understand.

iOS contact card does not have value for "displayName". "displayName" is used for the android devices. So For iOS device, use "name.formatted" instead of "displayName".

Cheers.... Keep Coding... :)