https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40708

Jonathan Druart <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #185945|0                           |1
        is obsolete|                            |

--- Comment #9 from Jonathan Druart <[email protected]> ---
Created attachment 186468
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=186468&action=edit
Bug 40708: Return the specific error to the checkin page

When implemented, the message here was believed to either be about Duplicate
IDs, or guarantor issues.
We are now seeing a wider variety of issues possible from SQL errors, lock
timeout or missings rows as examples

This patch adds an 'ErrorMessage' message to the return from AddReturn and
displays it to the user.

To test:
1 - Issue an item to a patron, note the itemnumber
2 - On the command line, lock the row:
    sudo koha-mysql kohadev
    START TRANSACTION;
    SELECT * FROM issues WHERE itemnumber=975 FOR UPDATE;
    leave mysql open at this point
3 - On the interface, check in the item, wait a bit
4 - After a bit you get the error to check the config page, but nothing is
there
5 - close mysql, apply patch, restart all
6 - Repeat 2
7 - Check in the item, wait a bit
8 - Note you now get the error from the DB:
    Error: (DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception:
DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting
transaction at /kohadevbox/koha/Koha/Object.pm line 174 )
9 - Sign off!

Signed-off-by: Brendan Lawlor <[email protected]>

Signed-off-by: Jonathan Druart <[email protected]>

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
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/

Reply via email to