OK, so I’m running self-hosted docker-compose from GIT. I’m currently running 4.5.17 and want to get to 4.5.38 to migrate to 5.
4.5.17 is running like a champ, so I’ve not touched it. Hence why it’s so old.
Here’s what I’ve done like 25 times
- copy existing env file
- git pull (which totally changes the directory stucture
- splice in old env into new one (where it make sense, leaving new env if it wasn’t defined in old one)
- edit docker-compose.yml and uncomment the v4 stuff at the bottom
- change the invoiceninja:5 line to invoiceninja:4 (tried leaving it alone too)
- chmod 755 docker/app/public
- chown -R 1500:1500 docker/app
- docker pull
- docker-compose up
- shut down docker-compose
- reran chown/chmod
- foreign key issue with gateways (
removed with ```
ALTER TABLEinvninja
.gateways
DROP FOREIGN KEYgateways_payment_library_id_foreign
;
At that point, it drops into a new install and my invoices table is blank even if I didn’t continue with the startup wizard. I’m not sure if it was before or after my alter table. but this is a bloody mess.
I’m just about tempted to csv export it and import it into V5, but I have lots of documents attached to the expense reports that I don’t want to lose. I’m not sure what the key/filename structure is for that.
Any help would be appreciated before I take the nuclear option.