https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40292 Paul Derscheid <paul.derscheid@lmscloud.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #183778|0 |1 is obsolete| | --- Comment #32 from Paul Derscheid <paul.derscheid@lmscloud.de> --- Created attachment 187442 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=187442&action=edit Bug 40292: Prevent SQL syntax error when upgrading to 25.05 on MariaDB 10.3 - Change `RENAME COLUMN <OLD> TO <NEW>` to `CHANGE COLUMN <OLD> <NEW> <DATATYPE (required for this syntax)>`. To test (assuming ktd): 1. Checkout upstream/24.11.x 2. Start ktd with `KOHA_IMAGE=24.11-bullseye(-arm64) DB_IMAGE=mariadb:10.3 ktd up -d` 3. Checkout upstream/main 4. Run updatedatabase in the Koha container 5. Observe the error regarding the unsupported syntax. 6. Tear everything down again: ktd down 7. Repeat 1-2. 8. Once started up, checkout upstream/main 9. Apply the patch on top of it 10. Run updatedatabase in the Koha container 11. Observe a successful upgrade 12. Sign off Side Note: I tested this against upstream/25.05.x, but this patch is based on main. Signed-off-by: Martin Renvoize <martin.renvoize@openfifth.co.uk> Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net> Signed-off-by: Paul Derscheid <paul.derscheid@lmscloud.de> -- You are receiving this mail because: You are watching all bug changes.