Resolving The Infamous Magento Deleting Issue (SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`YOURDBNAME`.`q`.`items_count` – 1)

From :

https://www.golocalexpert.com/resolving-the-infamous-magento-deleting-issue-sqlstate22003-numeric-value-out-of-range-1690-bigint-unsigned-value-is-out-of-range-in-yourdbname-q-items_count-1/

Project Fix:

I recently had to resolve this issue for a customer, and since it was quite easy to fix, I figured I’d share with all you developer and do it yourselfers.

Error Message:
SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`YOURDBNAME`.`q`.`items_count` – 1)’

How to Fix:

1. Go into your database using PhpMyAdmin.
2. Do a backup (always a good practice to back-up first).
3. Select the Magento database you’re using.
4. Select table sales_flat_quote (on second page).
5. Select structure tab
6. Select ‘change‘ on row called ‘items_count‘
7. Go to the drop-down on the column named ‘Attributes‘ and change value to the very top value which is blank ‘(no value)‘, as opposed to the default selection ‘UNSIGNED‘ .
8. Click save, and you’re good to go!

You should now be able to delete your products with no more error. This would have costed you at least $200 dollars, my complements to you all for free.

Magento Version 1.9.0.1