Hi,

I have been using skrooge for over 4 years now, and I have never had this problem before. I think I last updated my skrooge file on April 25th, and saved and exited skrooge once I was done. I tried to open skrooge today and got this error message upon start:

Code: Select all

[ERR-5]: Failed to open '/home/srthk/Documents/skrooge/srthk.skg'.

Hitting the "History" button gives this message:

Code: Select all

[ERR-5]: Failed to open '/home/srthk/Documents/skrooge/srthk.skg'.
[ERR-10001]: no such table: doctransaction Unable to execute statement
[ERR-10001]: insert into doctransaction (d_date, t_name, i_parent) values ('2016-04-30 14:49:12','#INTERNAL#Migrate document', 0);


Hitting OK takes me to the main page of skrooge, but all operations are lost, and it opens a blank file.
Upon further investigation I found somehow my skrooge file is empty:

Code: Select all

srthk@srthk:~/Documents/skrooge$ ls -l
total 188
-rw-rw-r-- 1 srthk srthk      0 Apr 25 08:44 srthk.skg
-rw-rw-r-- 1 srthk srthk      0 Apr 25 08:44 srthk.skg.old


Additionally, I noticed that the file type of my .skg file is "Encrypted Skrooge bank document (application/x-skgc)". I don't recall encrypting my file. In fact, I have some back-up files from last year, and none of them are encrypted. They are all of the type "Skrooge bank document (application/x-skg)" and are working properly upon opening in skrooge.

Can someone guide me on how to recover my latest skrooge file? It contains important financial data from the last four months which I absolutely do not want to lose this way!

I'm on version:

Code: Select all

skrooge -version
Qt: 4.8.1
KDE Development Platform: 4.8.5 (4.8.5)
Skrooge: 1.7.1


and here's the terminal output on opening skrooge and trying to open my 'corrupted' file

Code: Select all

QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
void DBusMenuExporterPrivate::addAction(QAction*, int): Already tracking action "F&ull Screen Mode" under id 24
##WARNING: insert into doctransaction (d_date, t_name, i_parent) values ('2016-04-30 14:57:41','#INTERNAL#Migrate document', 0);
##         returns :no such table: doctransaction Unable to execute statement


Any help will be greatly appreciated!

Hi,

As you can see, the size of the srthk.skg and srthk.skg.old is 0.
It means that your files are completely empty!!!
Nothing is recoverable.
You just have to use your backup.

I recommend you to use the last version of skrooge (1.7.0 is very old).

Hi smankowski,

Thanks but my hope was there would be a way to recover, or at least find out the reason why this happened. Is there no way to figure what went wrong?

The fact that all my data could just disappear like that for no apparent reason is very unsettling, and leaves me wondering why I should trust skrooge with my data any more - without resorting to backing up the skrooge data file every single day from now on. I have been a staunch skrooge enthusiast for the last four years, but this unexplainable disaster of losing over four months of important data is going to be hard for me to forget..

I already corrected a bug generating the same king of corruption (empty file).
This was due to a save of Skrooge document when the file system is full.

This is now corrected but not on Skrooge 1.7.0.

OK thanks.

In my case, the file system is not full - I have tens of gigs of empty space available on the skrooge partition. Also, I'm on Ubuntu 12.04 and the skrooge ppa only offers Skrooge 1.7.0 as the most recent version available.