Saving with new mysql 5.7 triggers in db

[Derek Atkins]

Geert Janssens <geert.gnucash at kobaltwit.be> 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"
tables?

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