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

Nick Clemens (kidclamp) <[email protected]> changed:

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

--- Comment #2 from Nick Clemens (kidclamp) <[email protected]> ---
Created attachment 185912
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=185912&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!

-- 
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