cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting Products

Deleting Products

Hello,

 

I have an issue with deleting sample products, I get the following error:

 

 

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`smarthom_mag3`.`q`.`items_count` - 1)', query was: UPDATE `quote` AS `q`
 INNER JOIN `quote_item` AS `qi` ON q.entity_id = qi.quote_id AND qi.parent_item_id IS NULL AND qi.product_id = 2054
SET `q`.`items_qty` = `q`.`items_qty` - `qi`.`qty`, `q`.`items_count` = `q`.`items_count` - 1
Exception #1 (PDOException): SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`smarthom_mag3`.`q`.`items_count` - 1)'

 

Now Everything seems to point to being the "sales_flat_quote" table, but I don't seem to have that table in Magento 2.10. Any ideas how to delete these products for now?

 

Thanks

Sam

1 REPLY

Re: Deleting Products

Hi,

Are you just deleting products for testing purposes?. Have you thought about using the cli to reload a clean copy of the database.

See document here

http://devdocs.magento.com/guides/v2.0/install-gde/install/cli/install-cli-install.html

 

Regards

Developer