Wednesday, August 9, 2017

Fix for Magento issue: (SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in (DB_NAME.q.items_count – 1)

There is Error in Magento admin when user try to delete product and get error

SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '('DB_NAME'.'q'.'items_count' – 1)'

To fix this error go to magento database and change the table
sales_flat_quote.
Go to the structure of the table and change the value of  items_count to blank as shown below;

 Now you can Delete the product from database and it is solved.
Thanks.


No comments:

Post a Comment