Describe the issue or problem
Upgrading from 3_4_0-5 (or 3_4_0-6) to 3_4_0-7 fails with this error:
2024-08-29 09:38:48 [migration: PKP\migration\upgrade\v3_4_0\I10249_FixProfileImageDataLoss]
ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘setting_type’ in ‘field list’ (SQL: update user_settings set setting_value = {“name”:“profileImage-1858.jpg”,“uploadName”:“profileImage-1858.jpg”,“width”:640,“height”:426,“dateUploaded”:“2024-08-19 11:48:25”}, setting_type = object where user_id = 1858 and setting_name = profileImage)
The current state of the database does not have a setting_type value in version 3_4_0-5/6?
I am guessing it is related to the work Jonas did here pkp/pkp-lib#10249 Clear invalid images and setup the setting_type · pkp/pkp-lib@80670e3 · GitHub.
Steps I took leading up to the issue
Started with my production database which is on version 3_4_0-5 and pulled it on to my test instance which I use a modified version Marc Bria’s (thanks for your work on this if you see this btw!) Docker image to build version 3_4_0-7.
Run my ansible-playbook to deploy to my test instance.
Run the upgrade tool.
See the error.
What application are you using?
OJS 3_4_0-5
Additional information
Let me know if I can try to provide further info as I could have made a mistake in my understanding and it might be a me (or proprietary) problem but would appreciate any advice if possible.
Thanks for all y’all do!