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:
- Go into your database using PhpMyAdmin.
- Do a backup (always a good practice to back-up first).
- Select the Magento database you’re using.
- Select table tag_summary
- Select structure tab
- Select ‘change‘ on row called ‘products ‘
- In column named ‘attrubute‘ and change value to the very top value which is blank ‘(no value)‘.
- Click save, and you’re good to go!
After deleted all necessary products , set attribute of products tab to “Unsigned” again.
POST HASN'T TAG.
