Summary: | Web-based installer failing on db upgrade for 30060 | ||
---|---|---|---|
Product: | Koha | Reporter: | Magnus Enger <magnus> |
Component: | Installation and upgrade (web-based installer) | Assignee: | Jonathan Druart <jonathan.druart> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | blocker | ||
Priority: | P5 - low | CC: | fridolin.somers, gmcharlt, jonathan.druart, kyle, sonia.bouis |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30060 | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: |
22.05.00
|
Circulation function: | |
Bug Depends on: | 30060 | ||
Bug Blocks: | |||
Attachments: | Bug 30276: (bug 30060 follow-up) Fix 21.12.00.016 |
Description
Magnus Enger
2022-03-11 08:43:05 UTC
user_permissions was empty before the upgrade too. Guess this test install only has superlibrarians, no detailed permissions. MariaDB [koha_kohadev]> ALTER TABLE user_permissions DROP INDEX IF EXISTS `PRIMARY`; Query OK, 0 rows affected, 1 warning (0.000 sec) Records: 0 Duplicates: 0 Warnings: 1 MariaDB [koha_kohadev]> show warnings; +-------+------+----------------------------------------------------+ | Level | Code | Message | +-------+------+----------------------------------------------------+ | Note | 1091 | Can't DROP 'PRIMARY'; check that column/key exists | +-------+------+----------------------------------------------------+ 1 row in set (0.000 sec) Created attachment 132326 [details] [review] Bug 30276: (bug 30060 follow-up) Fix 21.12.00.016 ERROR 1832 (HY000): Cannot change column 'code': used in a foreign key constraint 'user_permissions_ibfk_2' Test plan: Checkout a commit prior to 30060 (c023f63abcce53d71c9492aea4bc7aa30fdc5d73) reset_all checkout master+this patch updatedatabase Pushed to master for 22.05, thanks to everybody involved [U+1F984] |