search

csun / simple_gnucash_budget_plots

Simple budget plots for GnuCash - discussed in https://www.csun.io/2020/05/17/gnucash-finance.html
MIT License
21 stars 2 forks source link

"Unsupported Table Versions" #1

Closed peterb12 closed 4 years ago

peterb12 commented 4 years ago

I get this when I try to run this, with Gnucash 3.10.

(venv) simple_gnucash_budget_plots % python budget.py ~/Desktop/main.gnucash
Traceback (most recent call last):
  File "budget.py", line 246, in <module>
    main()
  File "budget.py", line 208, in main
    book = open_book(args.gnucash_file, open_if_lock=True)
  File "/Users/user/venv/lib/python3.7/site-packages/piecash/core/session.py", line 350, in open_book
    raise ValueError("Unsupported table versions")
ValueError: Unsupported table versions
(venv)simple_gnucash_budget_plots % file ~/Desktop/main.gnucash 
/Users/user/Desktop/main.gnucash: SQLite 3.x database, last written using SQLite version 3018000
csun commented 4 years ago

Thanks for finding this. I've just pushed a fix.

This is a bug in the piecash library where it doesn't support GnuCash 3.7+. They have a fix, but it's pretty recent so they haven't released a new build with it yet. I've added a flag --unsupported_table_hotfix. Please pass that when running the script and it should work. Please let me know if it doesn't.

peterb12 commented 4 years ago

That worked great. Thanks!