Numeric value out of range: 1690 BIGINT UNSIGNED

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

  1. Log into phpMyAdmin (or yyour prefered DBA tool)
  2. Do a backup (always do a backup first)
  3. Select the Magento database for your store
  4. Select the sales_flat_quote table
  5. Select the structure tab
  6. Select ‘change‘ on the ‘items_count‘ row
  7. 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‘ .
  8. 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.
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

How to add and manage currencies in Magento

In Magento you can allow customers to view the prices of the products in your shop in different...

How to add and edit polls in Magento

Adding and editing polls in Magento is easy. You can do that from the admin panel. Go to...

Reindexing

In some situation when you want to re-index Magento catalog you will get an error message or...

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2828-148-1-471' for key 'PRIMARY'

While trying to reindex your store using the command line, you stumble on the following...

Clearing cache from the shell

Magento often needs to refresh it's cache. In some occasion, you may want to flush either...

Powered by WHMCompleteSolution