Adobe-Runtime-Support icon indicating copy to clipboard operation
Adobe-Runtime-Support copied to clipboard

With Air51.1.1.3 I can no longer open CustomSQLConnection databases

Open Devin-Licastro opened this issue 5 months ago • 8 comments

My app stores important information in a SQL database (flash.data.SQLConnection) located in in applicationStorageDirectory.

This previously worked fine with Air 50.2.4.3 however after updating to Air 51.1.1.3 the databases can no longer be opened, and show message: Error #3138: File opened is not a database file.

Remaking the database works and I can use it for that session, but on the next load I can not reopen them and the error appears again.

After some testing I found the databases can still be opened repeatedly if they arent encrypted: dbConnection = new SQLConnection(); dbConnection.openAsync(dbFile);

However, with encryption they can not be reopened a 2nd time: dbConnection = new SQLConnection(); dbConnection.openAsync(dbFile, SQLMode.CREATE, null, false, 1024, encryptionKey); -> Error #3138: File opened is not a database file.

Likely related, it seems that also the EncryptedLocalStore is no longer functioning in a similar way? Values can only be stored for the current session, and the next time the app opens they are all reset.

Has something changes here? So far I have just tested this on Windows.

I need to update to 51.1.1.3 soon due to the iOS Chinese language issue so this is making me a bit nervous.

Devin-Licastro avatar Aug 29 '24 16:08 Devin-Licastro