Hi RRowley, thanks for your continuing hard work on SimpleInvoices.
I followed the upgrade instructions, to the latest version of 2019 on github ‘Version: 2019.2.30 — 20200805’. I used the backup function in SimpleInvoices and then used PHPMyAdmin to import the backed up version to a new database. This gave the following error;
EDIT: See attachment; error 1.
If I uncheck; Other options: Enable foreign key checks
The database imports OK after that and appears to work OK (I can manage customers in this version). I similarly had to uncheck ‘Enable foreign key checks’ to import that version to a fresh database to proceed with the upgrade to ‘Version: 2020.0.06 — 20201109’ otherwise I get this (same) error;
EDIT: See attachment; error 2.
Firstly is this storing up problems ? What am I risking by disabling foreign key checks ?
I tried duplicating the 2020 database in PHPMyAdmin and got the following error;
EDIT: See attachment; error 3.
My original post was falling foul of the bot test.. I’m hoping this makes it on to the board OK!