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.

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.

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

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.

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!

Hi,

Yes, I think the issue is due to sqlcipher.

Thank you.

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.

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