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.