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!
You should always disable check foreign key constraints when importing or deleting database content. This only removed the test for the import or delete process. Once data is imported, the constraints are enforced.