Description
Recently when making some cleanup on a Magento based store that was having over 550K products and we encountered a mySQL error in the Magento administration pages when trying to mass delete products. It also prevented any further products from being deleted.The solution isn't too far...
Error message
SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`YOURDB`.`q`.`items_count` – 1)’
Resolving the error
- Log into phpMyAdmin (or yyour prefered DBA tool)
- Do a backup (always do a backup first)
- Select the Magento database for your store
- Select the sales_flat_quote table
- Select the structure tab
- Select ‘change‘ on the ‘items_count‘ row
- Go to the drop-down list on the column named ‘Attributes‘ and change the value to the top option in the list, which is blank (no value), as opposed to the default selection ‘UNSIGNED‘ .
- Click save, and you're finished. You should now be able to delete your products without the error
Feel free to contact us if help is needed.
