Re: GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

[John Ralls]

> On Sep 6, 2017, at 2:59 PM, Art via gnucash-user  
> wrote:
> 
> It reports that it's corrupt when I attempt to save a valid XML db to MySQL 
> and in fact it is, as verfied through the MySQL workbench.
> However, I just downloaded 2.6.17 source from the GC web site and it works 
> perfectly!
> Somehow git cloning 2.6.99 is not the right thing to do.
> Oops.
> Thank you, though I was looking forward to some down and dirty source code 
> and API troubleshooting.

Please go ahead and do the down-and-dirty troubleshooting, just not on your 
production database! The SQL backend has been substantially rewritten for the 
next major release and needs thorough testing.

Since there are foo_back tables it would seem that a safe_save is getting 
interrupted.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Re: GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

[Art via gnucash-user]

 It reports that it's corrupt when I attempt to save a valid XML db to MySQL 
and in fact it is, as verfied through the MySQL workbench.
However, I just downloaded 2.6.17 source from the GC web site and it works 
perfectly!
Somehow git cloning 2.6.99 is not the right thing to do.
Oops.
Thank you, though I was looking forward to some down and dirty source code and 
API troubleshooting.
- Art

On Wednesday, September 6, 2017, 5:11:45 PM EDT, Colin Law 
 wrote:  
 
 On 6 September 2017 at 22:04, Art via gnucash-user
 wrote:
> ...
> ...So I assumed it should be working, but as soon as I do a file open on my 
> db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 
> experienced an error or encountered bad or corrupt data.
> When I look at the db with the workbench I notice that the "accounts" table 
> has been backed up to "accounts_back" and the "accounts" table now has two 
> records with field name "Root Account", account_type="ROOT" with a guid 
> field. At this point, the db is corrupt. I don't want to revert to GC 2.6.15 
> if I can fix this. I want to keep using MySQL and I can't just save an XML to 
> MySQL because it also reports that the db is corrupt. So, I must be making a 
> fundamental mistake or series thereof because I haven't heard anyone else 
> complain about any issues with the MySQL backend. Maybe I'm pulling the wrong 
> version? I am only using git at this point to get the source code.

What happens if you save to a mysql db of a different name (or delete
the current db first)?

Colin  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

[Colin Law]

On 6 September 2017 at 22:04, Art via gnucash-user
 wrote:
> ...
> ...So I assumed it should be working, but as soon as I do a file open on my 
> db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 
> experienced an error or encountered bad or corrupt data.
> When I look at the db with the workbench I notice that the "accounts" table 
> has been backed up to "accounts_back" and the "accounts" table now has two 
> records with field name "Root Account", account_type="ROOT" with a guid 
> field. At this point, the db is corrupt. I don't want to revert to GC 2.6.15 
> if I can fix this. I want to keep using MySQL and I can't just save an XML to 
> MySQL because it also reports that the db is corrupt. So, I must be making a 
> fundamental mistake or series thereof because I haven't heard anyone else 
> complain about any issues with the MySQL backend. Maybe I'm pulling the wrong 
> version? I am only using git at this point to get the source code.

What happens if you save to a mysql db of a different name (or delete
the current db first)?

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

[Art via gnucash-user]

I built it under Ubuntu 17.04 after a git download with,
 ./configure --enable-dbi --prefix=/opt/gnucash-devel --enable-compile-warnings 
--with-html-engine=webkit --enable-ofx Options detected/selected
  -
  gnucash version .. : 2.6.99
  Build for host ... : x86_64-pc-linux-gnu
  Optional components... :  dbi ofx
  Extra Warnings ... :  -Werror -Wdeclaration-after-statement 
-Wno-pointer-sign -D_FORTIFY_SOURCE=2
  CPPFLAGS . : 
  CFLAGS ... : -g -O2 -std=gnu11
  CXXFLAGS . : -g -O2
  LDFLAGS .. :  
  prefix : /opt/gnucash-devel

XML works fine, but the MySQL db now gets corrupted. It was working fine with 
GC v2.6.15.I am not familiar enough with the backend dbi to troubleshoot, but I 
see that,/tmp/gnucash.trace:* 16:51:34  INFO  [gnc_hook_lookup] no 
hook lists
* 16:51:35  INFO  [gnc_module_init_backend_dbi] GNC_DBD_DIR 
not set: using libdbi built-in default
* 16:51:35  INFO  [gnc_module_init_backend_dbi] 1 DBD drivers 
found
* 16:51:35  INFO  [gnc_module_init_backend_dbi] Driver: mysql
* 16:51:36 MESSG  Could not locate optional module 
gnucash/import-export/aqbanking interface v.0
* 16:51:40 MESSG  Could not locate optional module gnucash/python 
interface v.0
* 16:51:40 MESSG  loading system configuration
...So I assumed it should be working, but as soon as I do a file open on my db, 
I get a pop-up, The server at URL mysql://root@localhost/gc2017 experienced an 
error or encountered bad or corrupt data.
When I look at the db with the workbench I notice that the "accounts" table has 
been backed up to "accounts_back" and the "accounts" table now has two records 
with field name "Root Account", account_type="ROOT" with a guid field. At this 
point, the db is corrupt. I don't want to revert to GC 2.6.15 if I can fix 
this. I want to keep using MySQL and I can't just save an XML to MySQL because 
it also reports that the db is corrupt. So, I must be making a fundamental 
mistake or series thereof because I haven't heard anyone else complain about 
any issues with the MySQL backend. Maybe I'm pulling the wrong version? I am 
only using git at this point to get the source code.

Thanks,Art


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Receivable accounts not showing up?

[Derek Atkins]

It will only show you accounts of the correct currency. . Check your 
customer currency. If its wrong you will need to change it and then edit 
the invoice and reselect the customer.


-derek
Sent using my mobile device. Please excuse any typos.



On September 6, 2017 4:47:32 PM Macho Philipovich  wrote:


Hi again,

When I go to post my invoices, not all of the accounts receivable I've
(tried to) set up are selectable.

What criteria does it use to determine what goes there? I would think it
would be anything of type "A/Receivable", but of the 6 I've set up (all
but two as a test), only two of them are showing up, and only ones that
are in the main currency.

The context is that I'm trying to create a second account receivable in
a different currency to invoice a client in another country.

Thanks for your help!

Macho



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Receivable accounts not showing up?

[Macho Philipovich]

Hi again,

When I go to post my invoices, not all of the accounts receivable I've
(tried to) set up are selectable.

What criteria does it use to determine what goes there? I would think it
would be anything of type "A/Receivable", but of the 6 I've set up (all
but two as a test), only two of them are showing up, and only ones that
are in the main currency.

The context is that I'm trying to create a second account receivable in
a different currency to invoice a client in another country.

Thanks for your help!

Macho



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re : Re : Re : Could not obtain the lock

[Alain Dormoy]

Tank you. Will do.

Alain




De : David Carlson 
Date : samedi 2 septembre 2017 21:44
À : Alain Dormoy 
Cc : Robert Heller ; gnucash-user@gnucash.org ; Colin Law 
Objet : Re: Re : Re : Could not obtain the lock


Alain, sometimes Windows does some weird things if its settings get messed up. 


Next time you want to see if it is already running try Alt-Tab several times to 
see all the programs that are running.   There are other ways to check as well. 


David C 


On Sep 2, 2017 3:26 AM, "Alain Dormoy"  wrote:


  Thank you David.
  I don't think I'm starting GC more times than I'm shutting it down. If it's 
running I access it through the icon at the base of my desk, it's only if the 
icon is missing that I "start" GC. 
  If I don't intend to use it for a long while I save whatever still needs to 
be saved and I click on the cross in the upper right corner of my screen (am I 
missing something?) 
  Alain


  De : David Carlson 
  Date : samedi 2 septembre 2017 12:37
  À : Alain Dormoy 
  Cc : Colin Law ; Robert Heller ; gnucash-user@gnucash.org 
  Objet : Re: Re : Could not obtain the lock


  It sounds like you are starting GnuCash more times than you are shutting it 
down.  GnuCash can open more than one instance at a time, which would cause the 
same message.


  Take care to return to the open instance rather than starting a new instance 
when you return, because it is possible to lose data from the first instance 
when the second instance is shut down.


  David C



  On Sat, Sep 2, 2017 at 1:40 AM, Alain Dormoy  wrote:



--
De : "Colin Law" 
Date : vendredi 1 septembre 2017 13:12
À : "Alain Dormoy" 
Cc : 
Objet : Re: Could not obtain the lock


  On 1 September 2017 at 11:51, Alain Dormoy  wrote:

Hi!

More often than not, when I launch GnuCash, I get the message:

Gnucash could not obtain the lock for file:\...\filename.gnucash

I click "Open anyway" and it works normally. So I can't say I really 
care
but it's a bit puzzling.

Anyone has an explanation and can I do something to change that?


  That normally happens when GC has not been closed down correctly. How
  are you closing it?
  Also which operating system are you using and which version GC?

  Colin




I'm using Windows 7.
I normally close GC before turning my computer off. But I hardly turn it 
off more than once a week and the "incident" I'm refering to happens most every 
day.

Alain 

---
L'absence de virus dans ce courrier électronique a été vérifiée par le 
logiciel antivirus Avast.
https://www.avast.com/antivirus


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



   Garanti sans virus. www.avast.com  


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie Question

[Colin Law]

All the account data is in a single file, whose name depends on what
you called it when you did the first save, something like
myaccounts.gnucash.  If you have moved that file then when you open GC
it will try to reopen the original and will show an error when it
can't find it. Just ignore that error then use File > Open to browse
to the file wherever you have put it. Don't open one of the ones with
numbers in, those are timestamps of the backups made each time you
save.

Colin

On 6 September 2017 at 13:57, Nigel Snow  wrote:
> Thanks,
> That was the answer I was looking for
>
> However I now have a more serious problem; in the process of trying to move 
> all the GnuCash files and application to their own directory, I have lost all 
> the work I have done the last 3 days
> the application has lost links to all the accounts and data
> How do I retrieve that?
>
>
>
>> On 6 Sep 2017, at 15.02, Mike or Penny Novack 
>>  wrote:
>>
>>> On 9/6/2017 6:00 AM, Nigel Snow wrote:
>>> Hi,
>>> I am new to GnuCash.
>>> I have finished setting up my chart of accounts manually, but now I need to 
>>> populate Opening Balances.
>>> I understand that option was only available in the wizard.
>>> The question is how to set up Opening Balances Manually?
>>>
>> Exactly, you enter the transaction manually (just like you will be entering 
>> other transactions). In other words, this is simply the first transaction of 
>> the accounting period.
>>
>> BUT -- because doing a two way split transaction is tricky, I suggest you 
>> use TWO transactions, one for the credit side of equity and one for the 
>> debit side.
>>
>> You want a BALANCE SHEET from your old method of accounting that would be 
>> valid for the first day of your new set of books under gnucash. Look at the 
>> total assets amount. Create a transaction to credit equity for that amount 
>> and hit split. Change the split amount to the first asset account amount and 
>> specify the account. Repeat till there is nothing left in Imbalance. Then 
>> that side of the split is done. OK, now do the same for the total amount of 
>> liabilities except this time you are doing a debit to equity.
>>
>> Michael D Novack
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Newbie Question

[Nigel Snow]

Thanks,
That was the answer I was looking for

However I now have a more serious problem; in the process of trying to move all 
the GnuCash files and application to their own directory, I have lost all the 
work I have done the last 3 days 
the application has lost links to all the accounts and data
How do I retrieve that?



> On 6 Sep 2017, at 15.02, Mike or Penny Novack 
>  wrote:
> 
>> On 9/6/2017 6:00 AM, Nigel Snow wrote:
>> Hi,
>> I am new to GnuCash.
>> I have finished setting up my chart of accounts manually, but now I need to 
>> populate Opening Balances.
>> I understand that option was only available in the wizard.
>> The question is how to set up Opening Balances Manually?
>> 
> Exactly, you enter the transaction manually (just like you will be entering 
> other transactions). In other words, this is simply the first transaction of 
> the accounting period.
> 
> BUT -- because doing a two way split transaction is tricky, I suggest you use 
> TWO transactions, one for the credit side of equity and one for the debit 
> side.
> 
> You want a BALANCE SHEET from your old method of accounting that would be 
> valid for the first day of your new set of books under gnucash. Look at the 
> total assets amount. Create a transaction to credit equity for that amount 
> and hit split. Change the split amount to the first asset account amount and 
> specify the account. Repeat till there is nothing left in Imbalance. Then 
> that side of the split is done. OK, now do the same for the total amount of 
> liabilities except this time you are doing a debit to equity.
> 
> Michael D Novack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: For UK users: Will gnucash get ready for Making Tax, Digital ?

[Wm via gnucash-user]

On 23/08/2017 18:11, mike.m...@gmx.net wrote:

A little more reading.

[1]https://www.cchdaily.co.uk/lords-probe-software-companies-lack-readiness-m

aking-tax-digital


Please note that this link is mostly outdated, espcially the deadlines
mentioned are not any more applicable.

The general gist of the linked article is worth reading though.

HMRC's official statements, last updated 13 July 2017, are here.
https://www.gov.uk/government/publications/making-tax-digital/overview-
of-making-tax-digital

References

1. 
https://www.cchdaily.co.uk/lords-probe-software-companies-lack-readiness-making-tax-digital



I think this is a non-issue for gnc and most people that need to account 
for themselves and other people to HMRC.#


Why make gnc do something when the government haven't even said what 
they want in a spreadsheet.


Fellow travellers, this is not a big issue for the vast majority of UK 
users of gnc (the grand body doesn't exist)


--
Wm

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Newbie Question

[Nigel Snow]

Hi,
I am new to GnuCash.
I have finished setting up my chart of accounts manually, but now I need to 
populate Opening Balances.
I understand that option was only available in the wizard.
The question is how to set up Opening Balances Manually?

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.