Saving with new mysql 5.7 triggers in db

Derek Atkins warlord at MIT.EDU
Mon May 15 11:24:45 EDT 2017

Geert Janssens <geert.gnucash at> writes:

> On zondag 14 mei 2017 18:22:24 CEST Ciarán wrote:
>> However from this point onwards GNUcash will not save when new transcations
>> are created.
>> A msgbox appears with unable to save to database.
>> To resolve, I have re-save the db file overwriting the additional columns in
>> the transactions table.
>> and... back to square one.
>> Any ideas how to maintain new mysql triggers on save in gnucash? Is this
>> possible?
> I don't have much experience with mysql triggers. However it looks to me your 
> trigger is a bit odd. You specify that after the new row is inserted the 
> trigger should insert something again, but don't specify a full row. I don't 
> think you want to insert another row in the same table. You want to alter the 
> row being inserted.

Is it possible that GnuCash just isn't being happy with the "modified"

       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-devel mailing list