[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 306119] New: Can't open document created in 1.3.0 with 1.3.2
From:       A Rojas <nqn1976 () gmail ! com>
Date:       2012-09-01 8:24:17
Message-ID: bug-306119-17878 () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=306119

            Bug ID: 306119
          Severity: normal
           Version: unspecified
          Priority: NOR
                CC: stephane@mankowski.fr
          Assignee: guillaume.debure@gmail.com
           Summary: Can't open document created in 1.3.0 with 1.3.2
    Classification: Unclassified
                OS: Linux
          Reporter: nqn1976@gmail.com
          Hardware: Archlinux Packages
            Status: UNCONFIRMED
         Component: general
           Product: skrooge

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

-- 
You are receiving this mail because:
You are watching all bug changes.
[prev in list] [next in list] [prev in thread] [next in thread]