[Koha-bugs] [Bug 18966] Move of checkouts - Deal with duplicate IDs at DBMS level

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #18 from David Cook <dcook at prosentient.com.au> ---
With a new database, I did the following:

1. Add new biblio named 'Test'
2. Add new item with barcode 'test'
3. Checkout item 'test' to borrower 'test'
4. Checkin item 'test'

5a. Can't restart the mysqld process since I'm currently running other things
on the same db server
5b. Run "OPTIMIZE TABLE issues".
#NOTE: This didn't update the auto_increment on issues. We're on MariaDB
10.0.28
5c. Run "truncate issues"
#NOTE: This did reset the auto_increment to 1.

6. Checkout item 'test' to borrower 'test'
#NOTE: It has a issue_id of 1
7. Checkin item 'test' from the checkout tab and observe message: 'Unable to
check in'. 
8. Try to checkin from header/banner and observe message: 'The item has not
been checked in due to a configuration issue in your system. You must ask an
administrator to take a look at the about page and search for the "data
problems" section'.

--

Functionally, I think this does the trick. 

In terms of messages, I think they could be improved. Maybe something like
"Unable to check in due to duplicate ID. Ask a system administrator for
assistance."

-- 
You are receiving this mail because:
You are watching all bug changes.