Magento Bug
SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`relaunch_ultimo`.`q`.`items_count` - 1)', query was: UPDATE `dpm_sales_flat_quote` AS `q` INNER JOIN `dpm_sales_flat_quote_item` AS `qi` ON q.entity_id = qi.quote_id AND qi.parent_item_id IS NULL AND qi.product_id = 34395 SET `q`.`items_qty` = `q`.`items_qty` - `qi`.`qty`, `q`.`items_count` = `q`.`items_count` - 1
Lösung/Solution: Change in Table sales_flat_quote the row items_count the attribute “default” zero to blank
Another Solution is to edit the file
app/code/core/Mage/Sales/Model/Resource/Quote.php at row 221 outcomment the line and add this 'items_count' => new Zend_Db_Expr("CASE WHEN q.items_count>0 THEN " . $adapter->quoteIdentifier('q.items_count') . ' - 1 ELSE 0 END') its better to do this only temporarly, just delete the products and then reverse the changes












