Bug 40767

Summary: `RENAME COLUMN` not supported by old DBMS
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: david, magnus
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Crowdfunding goal: 0
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 38663, 39837, 39838    
Bug Blocks:    

Description Jonathan Druart 2025-09-08 10:28:08 UTC
installer/data/mysql/db_revs/241200018.pl:            $dbh->do(q{ ALTER TABLE additional_field_values RENAME COLUMN new_record_id TO record_id; });
installer/data/mysql/db_revs/241200042.pl:                        ALTER TABLE aqbookseller_aliases RENAME COLUMN alias_id TO vendor_alias_id;
installer/data/mysql/db_revs/241200043.pl:                        ALTER TABLE aqbookseller_interfaces RENAME COLUMN interface_id TO vendor_interface_id;

This block the upgrade for people using old DBMS.
Comment 1 Magnus Enger 2025-09-22 09:03:52 UTC
Is this the same problem as bug 40292?
Comment 2 Jonathan Druart 2025-09-22 09:42:44 UTC
(In reply to Magnus Enger from comment #1)
> Is this the same problem as bug 40292?

Yes.

*** This bug has been marked as a duplicate of bug 40292 ***