Consumables break if large number of items is checked-out #15853
Description
Debug mode
- I have enabled debug mode
- I have read checked the Common Issues page
Describe the bug
If more that 8300 pieces of consumable are checked-out, page shows 'No matching records found' for that consumable.
If user has more than 10k pieces of consumables assigned - users part of SnipeIT is bricked - page shows 'No matching records found'.
Reproduction steps
- Create consumables with large quantity - 44444
- Check-out 9000 consumables to the user
- Visit page where list of users, that consumable was checked-out to, is shown.
Expected behavior
That list shows entries, not the message 'No matching records found'. On a side note, that list would should show single line for check-out action with number of items checked-out, instead of entry for every single item.
Screenshots
Snipe-IT Version
latest demo
Operating System
Web Server
PHP Version
Operating System
No response
Browser
No response
Version
No response
Device
No response
Operating System
No response
Browser
No response
Version
No response
Error messages
No response
Additional context
Currently, you can't remove assigned consumables and there's no other way to remove consumables from the user. I understand that 8000+ pieces of consumables may look like overkill, but our company goes through 500 packs of A4 sheets per week and if we would decide to track paper, we would brick the system unintentionally. Also, someone could make a mistake checking-out consumables by putting 9999 as quantity.