Bug 306119 - Can't open document created in 1.3.0 with 1.3.2
Summary: Can't open document created in 1.3.0 with 1.3.2
Status: RESOLVED FIXED
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Arch Linux Linux
: NOR normal
Target Milestone: ---
Assignee: Stephane MANKOWSKI
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-01 08:24 UTC by Antonio Rojas
Modified: 2012-09-01 20:38 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Antonio Rojas 2012-09-01 08:24:17 UTC
A document which was last modified in v. 1.3.0 can't be opened in v. 1.3.2. It gives the following error when trying to load it:

[ERR-5]: Failed to open '/home/antonio/Documentos/Cuentas.skg'.
[ERR-5]: Database migration from version 1.4 to version 1.4 failed
[ERR-10001]: no such table: main.vm_category_display_tmp Unable to execute statement
[ERR-10001]: CREATE VIEW  v_category_display AS SELECT *,f_REALCURRENTAMOUNT+(SELECT TOTAL(c.f_REALCURRENTAMOUNT) FROM vm_category_display_tmp c WHERE c.t_fullname LIKE vm_category_display_tmp.t_fullname||' > %') AS f_SUMCURRENTAMOUNT, i_NBOPERATIONS+(SELECT CAST(TOTAL(c.i_NBOPERATIONS) AS INTEGER) FROM vm_category_display_tmp c WHERE c.t_fullname like vm_category_display_tmp.t_fullname||' > %') AS i_SUMNBOPERATIONS, (CASE WHEN t_bookmarked='Y' THEN 'Y' WHEN EXISTS(SELECT 1 FROM category c WHERE c.t_bookmarked='Y' AND c.t_fullname like vm_category_display_tmp.t_fullname||' > %') THEN 'C' ELSE 'N' END) AS t_HASBOOKMARKEDCHILD, (CASE WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT<0 THEN '-' WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT=0 THEN '' ELSE '+' END) AS t_TYPEEXPENSE,(CASE WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT<0 THEN 'Expenditure' WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT=0 THEN '' ELSE 'Income' END) AS t_TYPEEXPENSENLS FROM vm_category_display_tmp

Reproducible: Always
Comment 1 Stephane MANKOWSKI 2012-09-01 15:15:30 UTC
In fact, it seems that some temporary materialized views (vm_category_display_tmp) have been deleted. I don't understand how?

But somebody else using Archlinux too has the same issue.
I will do a correction recreating the missing table.

In any case, you data are not lost.
Comment 2 Stephane MANKOWSKI 2012-09-01 20:38:38 UTC
Corrected