Bug 38884

Summary: Upgrade problem
Product: Koha Reporter: Afrane Daniel <afrane55>
Component: bugs.koha-community.orgAssignee: Paul Derscheid <paul.derscheid>
Status: RESOLVED FIXED QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P2 CC: isabel.pineda, jonathan.druart, lasse, mtj, paul.derscheid
Version: 24.11Keywords: accessibility
Hardware: PC   
OS: Linux   
URL: opac.gij.edu.gh
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Afrane Daniel 2025-01-14 09:42:31 UTC
I upgraded from 24.11.00 to 24.11.01 and after the upgrade, Koha rather installed the new version instead of upgrading. I now see system maintenance on the opac and the staff interface is asking me to continue the installation which is usually not the case because I will lose data if I do that.
Comment 1 Paul Derscheid 2025-01-14 13:55:55 UTC
db_rev 241101000.pl misplaced and missing execute permission

I unintentionally placed the db_rev file `241101000.pl` in the wrong location.

Steps to Reproduce:
1. Run the update process

Expected Results:
- The update should apply successfully.

Actual Results:
- The update fails because the db_rev file is placed in the wrong location (and missing permissions).

Fix:
- Move the file to the correct location:

mv installer/data/mysql/{,db_revs/}241101000.pl

- Set the execute permission:
Bash

chmod +x installer/data/mysql/db_revs/241101000.pl
Additional Information:

A fixed package will be available shortly (within a few hours).
I apologize for any inconvenience this may have caused.
Comment 2 Lasse Kliemann 2025-01-14 14:42:55 UTC
Thanks for taking care of this. I think my installation suffered from the same problem. Instead of the usual (internal) login, I got:

Welcome to the Koha 24.11 web installer

After logging in:

Web installer › Update database
We are upgrading from Koha 24.11.00.002 to 24.11.01.000
[ Update your database ]

Clicking on the button [ Update your database ] only gives:

Web installer › Updating database structure
[ Try again ]

Clicking [ Try again ] only yields this page again.

I also ran 'koha-upgrade-schema bib' which gave no errors, but also did not fix the problem.

I understand you already analyzed the cause and will provide a fix.

*However, did I damage anything by conducting the steps above? Should I revert to the last backup?*

Thanks!
Comment 3 Isabel Pineda 2025-01-14 15:01:11 UTC
(In reply to Paul Derscheid from comment #1)
> db_rev 241101000.pl misplaced and missing execute permission
> 
> I unintentionally placed the db_rev file `241101000.pl` in the wrong
> location.
> 
> Steps to Reproduce:
> 1. Run the update process
> 
> Expected Results:
> - The update should apply successfully.
> 
> Actual Results:
> - The update fails because the db_rev file is placed in the wrong location
> (and missing permissions).
> 
> Fix:
> - Move the file to the correct location:
> 
> mv installer/data/mysql/{,db_revs/}241101000.pl
> 
> - Set the execute permission:
> Bash
> 
> chmod +x installer/data/mysql/db_revs/241101000.pl
> Additional Information:
> 
> A fixed package will be available shortly (within a few hours).
> I apologize for any inconvenience this may have caused.


Is it possible to do this fix by myself in order to make my installation work again now?
It says:
> - Move the file to the correct location:
> mv installer/data/mysql/{,db_revs/}241101000.pl

-> Can I do this on my installation? To which folder do I have to go to execute this command?
Comment 4 Paul Derscheid 2025-01-14 16:13:29 UTC
Regarding comment #2: I think that no data loss could have occurred in the steps lined out in your comment, Lasse.

Regarding comment #3: It might be better to wait for the fixed package if you're unsure on how to apply the steps lined out in comment #1.
Comment 5 Paul Derscheid 2025-01-14 20:47:45 UTC
Alright, the latest debian packages should now have resolved this bug.