Magento SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED

SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`DB`.`tag_summary`.`products` – 1)’

Magento Version 1.9.0.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 ‘(`DB`.`tag_summary`.`products` – 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 tag_summary
5. Select structure tab
6. Select ‘change‘ on row called ‘products ‘
7. In column named ‘attrubute‘ and change value to the very top value which is blank ‘(no value)‘.
8. Click save, and you’re good to go!

After deleted all necessary products , set attribute of products tab to “Unsigned” again.