When I tried importing my kmm file into Skrooge (2.4) it churns for a while then it stops, but the file remains empty. When running from command-line shows these messages:

Code: Select all

##WARNING: SKGServices::stringToInt(8.04831E+11) failed
##WARNING: SKGServices::stringToInt(7.0457E+11) failed
.
.
.
(100's of similar messages)
##WARNING: INSERT INTO suboperation ('t_comment','d_date','rd_operation_id','f_value','r_category_id') VALUES ('Online Bill Payment Debit on 4/20ECU Billing Services,XXXXXXXX,XX
Ref# 000000000','2015-04-20','22582','-160.39','347')
##         returns :unrecognized token: "'Online Bill Payment Debit on 4/20ECU Billing Services,XXXXXXXX,XX
Ref# 000000000" Unable to execute statement
##WARNING: Audio notification requested, but sound file from notifyrc file was not found, aborting audio notification


Hi,

I think this error is due to a comment having more than one line.
A possible workaround is to change the comment of the transaction having the comment "Online Bill Payment Debit on 4/20ECU Billing Services".

In parallel, I will try to find a fix for Skrooge.

Thank you. Please explore the possibility of using prepared statements. Skrooge may be vulnerable to SQL injection attacks.

Hi,

SQL Ingection is taken into account by adding quotes when needed.
But, the multi lines is not taken into account, causing failure.

That's why I will fix Skrooge.