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.butle...@gmail.com kg...@arrl.net 253-350-0166 ------------------------------------------- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
