https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40292
Bug ID: 40292
Summary: SQL syntax error when upgrading to 25.05 on MariaDB
10.3, RENAME COLUMN unsupported
Change sponsored?: ---
Product: Koha
Version: 25.05
Hardware: All
OS: All
Status: NEW
Severity: blocker
Priority: P5 - low
Component: Installation and upgrade (command-line installer)
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Got this report on Mattermost for 25.05:
Configurando koha-common (25.05.01-1) ...
Upgrading database schema for biblio
Upgrade to 24.12.00.042 [07:56:03]: Bug 39838
(https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39838) - Rename
alias_id -> vendor_alias_id
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an
error in your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near 'COLUMN alias_id TO
vendor_alias_id' at line 1 at /usr/share/koha/lib/C4/Installer.pm line 825
After investigation and confirmation, the usage of RENAME COLUMN is the
problem. This syntax is unsupported in versions of MariaDB prior to 10.5.3,
here's the relevant documentation for reference: mariadb dot
com/docs/server/reference/sql-statements/data-definition/alter/alter-table#rename-column
The solution is to fix the usage of RENAME COLUMN in the current db_revs and to
write a coding guideline and a QA test to accompany it.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
