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 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Relaterede artikler

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...

How to add and edit attribute sets in Magento

Each product that you add in Magento can be configured thanks to a set of attributes. These are...

How to add and edit product ratings and reviews in Magento

In Magento each product can be rated and reviewed. Customers (both guests and registered ones)...

How to Show or hide out of stock products in Magento

The process is fairly straight forwardShow out of stock products in Magento   Login to the...

How to add and edit admin users and user roles in Magento

In addition to the admin account that's created while installing your Magento you can add more...

Powered by WHMCompleteSolution