I have had an issue with my databases. I currently run 2 for our business and am in the process of "testing" a third. All 3 are split databases (I had an issue before and someone mentioned that I should not have an issue recovering the tables because of this.)
This morning I opened all 3 databases and have an error message from one, no tables appear in the second and the new database appears to be fine. All 3 databases should have tables with over 3200 rows of data. When I opened the first database with the error, the "save" icon was highlighted as if I had made changes so I haven't done anything (haven't closed it or pressed save).
The error message is
I don't have a table called Engineer List, so am not sure why this has happened. I did have one but deleted it a while ago. I am not sure if this helps, but when I went into the database folder, there are several files with "Conflict" in the title (e.g. Jobs (Conflict - 2014-01-26 12-36-40)(Conflict - 2014-01-26 12-36-42.script) So there are 3 x .properties files, 3 x .data files and 3x .script files. Is this something to do with my Cloud backup?error in script file line: 48 org.hsqldb.HsqlException: java.io.EOFException in statement [SET TABLE PUBLIC."Engineer List" INDEX '7 0 7'
Can someone help me recover them? What do I need to do? I need to recover this data to run this month's invoices... HELP!!
Thanks in advance if you can provide any insight or advice.
x