[GNC] mysql setup in linux (debian)

[gnu Gord]

I would be happy to open a bug report but I have no idea how to do it.
Can you point me in the right direction?


On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt <list+gnucash at jdlh.com> wrote:

> Good catch, Gord!
>
> On 2021-02-01 10:36, gnu Gord wrote:
> > …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 …  was
> > "2 books one for A one for\".…
> >
> > Here are the relevant lines from the 'gnucash.trace' file:
> >
> > * 09:09:43 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 1064: You
> > have an error in your SQL syntax; check the manual that corresponds to
> your
> > MariaDB server version for the right syntax to use near '1970-01-01
> > 00:00:00',0,1)' at line 1
> > * 09:09:43 ERROR <gnc.backend.dbi>
> > [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> > INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR <gnc.backend.sql>
> > [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR <gnc.backend.sql> [GncSqlTransBackend::commit()]
> > Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
> > Slots save failed. Check trace log for SQL errors.
>
> I encourage you to write a bug report in the GnuCash bug tracker about
> this problem. As a general matter, GnuCash should not let any text you
> type into a Notes field turn into a syntax error for the database. It
> should wrap the Notes text in a way that prevents the syntax error from
> happening. I suspect that GnuCash does this kind of wrapping the XML way
> if the backend is XML, but doesn't do it the SQL way if the database is
> SQL.
>
> It's good to have people turn up errors with nice solid evidence like
> you collected. Thanks!
>
> Best regard,
>       —Jim DeLaHunt
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>