Updated to Version: 18.104.22.168 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
First visit to a HSQL database since update I get the migration message, click yes, get a blank error message box.
Click on more get message
SQL Status: invalid map<K, T> key
The tables are still there, the fields (column headings) are still there but all the data in some of the tables has disappeared.
If I click on a query (of one of the blank tables) I get
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 135
Thankfully I found if I close (without saving) and exit LO completely when I reopen as long as I click to migrate later data is back and seems intact.
This is a kind of expenses database - so mix of dates, text, currency, boolean.
Some of the tables just contain data for drop down lists (combo boxes) for a form which produces a ‘main’ outgoings table. On the form, out of 5 of these 3 still work/ their source table still contains data.
And it seems random - eg 3 of the drop downs are to categorise the expense so Main (personal), Minor (car) Detail (fuel) - the main and minor tables are now empty but the detail one isn’t - even though all 3 contain similar type of data - text.
Main table is completely empty.
Any idea what the issue is? Obviously I can just keep on using HSQL for now, until it is phased out completely and this database isn’t really important -it is a bit of a learning project for me really.
But I am planning a major overhaul of an important existing split embedded database - I guess I need to do that as Firebird but wasn’t planning on re entering all the data from scratch.