Reply to topic

Skrooge stopped working after upgrade

turin
Registered Member
Posts
2
Karma
0
Hi, after upgrade from 1.9.3 to 2.15 I get the following in console:

##WARNING: Icon theme "crystalsvg" not found.
##WARNING: KServiceTypeTrader: serviceType "ThumbCreator" not found
##WARNING: CREATE VIEW v_unitvalue_displayname AS SELECT *, (SELECT t_displayname FROM v_unit_displayname WHERE unitvalue.rd_unit_id=v_unit_displayname.id)||' '||IFNULL(TOFORMATTEDDATE(d_date,'d.MM.yy 'г'.'),STRFTIME('%Y-%m-%d',d_date)) AS t_displayname FROM unitvalue
## returns :near "г": syntax error Unable to execute statement
##WARNING: SELECT t_name, t_symbol, i_nbdecimal FROM unit WHERE t_type='1'
## returns :no such table: unit Unable to execute statement
##WARNING: SELECT t_name, t_symbol, f_CURRENTAMOUNT, i_nbdecimal FROM v_unit WHERE t_type='2'
## returns :no such table: v_unit Unable to execute statement
##WARNING: Audio notification requested, but sound file from notifyrc file was not found, aborting audio notification
##WARNING: libpng warning: iCCP: known incorrect sRGB profile
##WARNING: libpng warning: iCCP: known incorrect sRGB profile
##WARNING: QFSFileEngine::open: No file name specified

Inside Skrooge I get a lot of errors like:

ERR-5]: Document creation failed.
[ERR-5]: Database migration from version to version 1.6 failed
[ERR-10001]: near "г": syntax error Unable to execute statement
[ERR-10001]: CREATE VIEW v_unitvalue_displayname AS SELECT *, (SELECT t_displayname FROM v_unit_displayname WHERE unitvalue.rd_unit_id=v_unit_displayname.id)||' '||IFNULL(TOFORMATTEDD

There is nothing I can do in the program, for example when I click on Operations I get:

[ERR-10001]: no such table: v_rule Unable to execute statement
[ERR-10001]: SELECT * FROM v_rule WHERE t_action_type='A' ORDER BY i_ORDER

[ERR-10001]: no such table: v_suboperation_consolidated Unable to execute statement
[ERR-10001]: SELECT d_DATEMONTH,'All',TOTAL(f_REALCURRENTAMOUNT) FROM (SELECT (CASE WHEN (((((1=0) OR d_date='0000-00-00')) OR d_date='0000-00-00')) AND f_REALQUANTITY<>0 THEN '0000' ELSE d_date END) AS d_date, (CASE WHEN (((((1=0) OR d_date='0000-00-00')) OR d_date='0000-00-00')) AND f_REALQUANTITY<>0 THEN '0000' ELSE d_DATEMONTH||(CASE WHEN 1=0 THEN '999' ELSE '' END) END) AS d_DATEMONTH,* FROM v_suboperation_consolidated) as v_suboperation_consolidated WHERE (((((((1=1) OR d_date='0000') AND d_date!='0000-00-00') OR d_date='0000') AND d_date!='0000-00-00') AND 'All' NOT LIKE '%#NULL#%') AND d_DATEMONTH NOT LIKE '%#NULL#%') AND (d_date>(SELECT date('now', '-50 year')) OR d_date='0000') AND d_date<(SELECT date('now', '+50 year')) GROUP BY d_DATEMONTH,'All' ORDER BY 'All',d_DATEMONTH

I'm using the Debian packages. I tried to run Skrooge under XFce and Gnome. All other KDE apps work OK. Before upgrade everything was working as expected and there were no issues with the upgrade itself. I tried to run Skrooge under a clean new account and it was all the same.
User avatar smankowski
Moderator
Posts
863
Karma
7
OS
Hi,

This is a bug revealed by the date format of your system.
Indeed, your date format is "d.MM.yy 'г".
As you can see, this contains the character '.
This character causes the bug.

I did a correction https://cgit.kde.org/skrooge.git/commit ... 9cc656953e.

You can have now 3 solutions:
1- Change the date format of you system to something like d.MM.yy (with 'r)
2- Build Skrooge from git
3- Ask to debian packager to take into account this correction in the packaging

This solution 1 is the simplest.
Regards.


Skrooge, a personal finances manager powered by KDE
Image
turin
Registered Member
Posts
2
Karma
0
Thanks a lot! Changing the date format did the trick and now it runs ok.
I'll see to either upgrade from git next time, or wait for your changes to get in the package.
Thanks again and keep up the good work!

 
Reply to topic

Bookmarks



Who is online

Registered users: alavarre, Baidu [Spider], Bing [Bot], Eneen, eshahnazi, eveanned, Exabot [Bot], gfielding, Google [Bot], morera, peje, scummos