[GNC] mysql setup in linux (debian)

Stephen M. Butler Stephen.M.Butler51 at gmail.com
Mon Feb 1 13:50:31 EST 2021


On 2/1/21 10:36 AM, gnu Gord wrote:
> Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace'
> file, I think I have discovered the problem.
> It appears that mysql (or somewhere in the backend of gnuCash) does not
> like a back slash character as the last character in a field. The data I
> was trying to save had one entry with a 'notes' field that had a backslash
> as the last character. The text was "2 books one for A one for\". It
> appears when I save this as an XML file there is no problem but if I try to
> save this as a mysql I get an error message. A backslash other than at the
> end of the field does not appear to cause a problem.
> BTW if I remove the backslash and successfully save to a mysql file and
> then go back into the register GnuCash will not let me add a backslash to a
> field. However, if I save it as an XML file the backslash is allowed.
>

Looks like you are on a Linux/Unix box.  The backslash is the escape 
character.  It probably ate the ending quote mark.
I think you can get the backslash by escaping it!  Yes, escape the 
escape character.  \\

-- 
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8



More information about the gnucash-user mailing list