Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-30 Thread maniek
OK, I saved this to a new DB and then worked. Thx! -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://l

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-30 Thread maniek
yes, it helped a little bit. Now I can see all transactions however when I try to add a new one: " unable to save to database". -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnu

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-30 Thread maniek
No. Tables: MariaDB [gnucash_2018]> show tables; ++ | Tables_in_gnucash_2018 | ++ | accounts | | accounts_back | | billterms | | billterms_back | | books | | books_back | | bud

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-29 Thread John Ralls
FWIW I did "create table accounts_save from accounts;" in the mysql shell then started GnuCash and got all of the tables empty. I don't know yet if that's your issue but it's probably the issue for https://bugzilla.gnome.org/show_bug.cgi?id=796117. Regards, John Ralls > On May 28, 2018, at 8:

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread John Ralls
Does the database have a table named something like “foo_save”? If so, try dropping it before starting GnuCash. Regards, John Ralls > On May 27, 2018, at 9:56 AM, maniek wrote: > > OK, I turned on query logs. > > when my 2018 DB (a problematic one): > > > Tcp port: 0 Unix socket: /var/lib/

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
OK, I turned on query logs. when my 2018 DB (a problematic one): Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 180527 18:51:29 8 Connect root@localhost as anonymous on gnucash_2018 8 Query SET NAMES 'utf8'

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
Nope, just opening a GnuCash after recovering my DB from backup. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscr

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
Unfortunately anything in MariaDB log: 2018-05-27 18:22:34 140224845301504 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255). 2018-05-27 18:22:34 140224845301504 [ERROR] Incorrect definition of t

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-27 Thread John Ralls
> On May 26, 2018, at 5:13 AM, maniek wrote: > > I installed GnuCash 2.6.x on Fedora 27 on virtual machines. Everything works > fine. > > I did again a test on fedora 28 and GnuCash erases all records during > opening a database. I can't find anything special in logs except /No > pre-existing

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-27 Thread John Ralls
> On May 26, 2018, at 10:12 AM, maniek wrote: > > Logs: > > * 19:09:19 INFO [main] System locale returned en_US.UTF-8 > * 19:09:19 INFO [main] Effective locale set to en_US.UTF-8. > * 19:09:19 INFO [gnc_load_app_icons] The icon theme search path > has 12 elements. > * 19:09:19 INFO [gn

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-26 Thread maniek
Logs: * 19:09:19 INFO [main] System locale returned en_US.UTF-8 * 19:09:19 INFO [main] Effective locale set to en_US.UTF-8. * 19:09:19 INFO [gnc_load_app_icons] The icon theme search path has 12 elements. * 19:09:19 INFO [gnc_load_app_icons] Path 0: /home/gnucash_user/.local/share/icons *

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-26 Thread maniek
As a quick workaround, I saved my transactions, accounts to XML under 2.6.x and imported to 3.1 and saved to the database. It worked. Looks like one of my databases is not recognized by 3.1. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html __

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-26 Thread maniek
I installed GnuCash 2.6.x on Fedora 27 on virtual machines. Everything works fine. I did again a test on fedora 28 and GnuCash erases all records during opening a database. I can't find anything special in logs except /No pre-existing state found, creating new one/: * 13:58:41 INFO [main] Syste

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-26 Thread John Ralls
> On May 25, 2018, at 3:42 PM, maniek wrote: > > Hello, > > I've been using GnuCash for 6 years now. Today I upgraded my fedora from 27 > to 28 so GnuCash as well (from 2.6.x to 3.1). Unfortunately, it does not > work correctly. My database is automatically cleaned. After typing a > password to

[GNC] Gnucash 3.1 and fedora 28

2018-05-25 Thread maniek
Hello, I've been using GnuCash for 6 years now. Today I upgraded my fedora from 27 to 28 so GnuCash as well (from 2.6.x to 3.1). Unfortunately, it does not work correctly. My database is automatically cleaned. After typing a password to the database, I can see an only blank page. I generated a g