Reply to topic

Migration failure from 2.11.0 to 2.18.0

yuuyuu
Registered Member
Posts
3
Karma
0
I tried migrating from Skrooge v2.11.0 (Ubuntu bionic (18.04LTS)) to v2.18.0 (Arch Linux), but I was unable to do so. When I try to open any file created with Skrooge v2.11.0 in v2.18.0, it outputs:
Code: Select all
[ERR-5]: Failed to open '/home/esther/doc/test.skg'.
[ERR-5]: Database migration from version 10.1 to version 10.2 failed
[ERR-10001]: error in view v_operation_numbers: no such table: main.operation Unable to fetch row
[ERR-10001]: ALTER TABLE operation2 RENAME TO operation

How to fix that? Any help is appreciated.
User avatar smankowski
Moderator
Posts
945
Karma
7
OS
Hi,

You have the same issue than another user: viewtopic.php?f=210&t=158685

But, I'm not able to reproduce the issue. Are you able to reproduce the issue if an anonymized file? If YES, could you send me this file for analysis (my email is in the "About" of Skrooge).

What is your distribution?
What is your sqlcipher version (returned by "sqlcipher --version")?

Regards.


Skrooge, a personal finances manager powered by KDE
Image
yuuyuu
Registered Member
Posts
3
Karma
0
smankowski wrote:Are you able to reproduce the issue if an anonymized file? If YES, could you send me this file for analysis (my email is in the "About" of Skrooge).

Yes, the same happens with anonymized files. Just sent the anonymized file to your email.

smankowski wrote:What is your distribution?

Distribution with Skrooge v2.11.0: [L]Ubuntu bionic (18.04.2 LTS). Package: https://packages.ubuntu.com/bionic/skrooge
Distribution with Skrooge v2.18.0: Arch Linux. Package: https://www.archlinux.org/packages/community/x86_64/skrooge

smankowski wrote:What is your sqlcipher version (returned by "sqlcipher --version")?

On [L]Ubuntu:

$ sqlcipher --version
Command 'sqlcipher' not found, but can be installed with:
sudo apt install sqlcipher


On Arch Linux:

$ sqlcipher --version
3.26.0 2018-12-01 12:34:55 bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238alt1
User avatar smankowski
Moderator
Posts
945
Karma
7
OS
Could you try to install Skrooge 2.18.0 on Ubuntu ?
You can do it like this https://skrooge.org/ubuntu_installation

I would like to know if the issue is due to sqlcipher or not.

Regards.


Skrooge, a personal finances manager powered by KDE
Image
yuuyuu
Registered Member
Posts
3
Karma
0
smankowski wrote:Could you try to install Skrooge 2.18.0 on Ubuntu ?

Installing Skrooge from your ppa solved the issue. I installed Skrooge v2.18 on Ubuntu with the commands below:
sudo apt remove skrooge
sudo apt autoremove

sudo add-apt-repository ppa:s-mankowski/ppa-kf5
sudo apt update
sudo apt install skrooge-kf5


Following, I was able to open the file created with Skrooge v2.11 in v2.18 on Ubuntu. Then, I "save[d] as" this file and successfully opened it with Skrooge on Arch Linux, also with v2.18.

smankowski wrote:I would like to know if the issue is due to sqlcipher or not.
So, it means it was due to sqlcipher?

And thank you so much for your time and support! Skrooge is awesome!
User avatar smankowski
Moderator
Posts
945
Karma
7
OS
Hi,

Yes, I think the issue is due to sqlcipher.

Thank you.


Skrooge, a personal finances manager powered by KDE
Image
User avatar smankowski
Moderator
Posts
945
Karma
7
OS
Hi,

As you can see here https://sqlite.org/lang_altertable.html the issue is due to a change in sqlite 3.25.0.
I know how to fix it.
I will try to do it soon.


Skrooge, a personal finances manager powered by KDE
Image
User avatar smankowski
Moderator
Posts
945
Karma
7
OS
Hi,

For your information:
1- I did a correction: https://cgit.kde.org/skrooge.git/commit ... 8712cf6f61
2-I opened a bug on Arch to package ASAP this correction: https://bugs.archlinux.org/task/61940


Skrooge, a personal finances manager powered by KDE
Image

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], gfielding, Google [Bot], hiteshshah, lucianosalomoni, Majestic-12 [Bot], pseco, Sentinel, TheBeheader, Yahoo [Bot]