Resolving the “Numeric value out of range: 1690 BIGINT UNSIGNED” error in Magento

Recently when making some changes on a Magento based store we encountered a mySQL error in the Magento administration pages when trying to delete products which prevented any further products from being deleted. The error message SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`YOURDB`.`q`.`items_count` – 1)’ Resolving
Source