SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range

共计 525 个字符，预计需要花费 2 分钟才能阅读完成。

在删除目录产品的时候，有时候Magento会不执行，反而出现标题所述错误。

SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(`magento_store`.`q`.`items_count` – 1)’

这里三个选择，你可以挨个试试：

1、

DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);

2、

DELETE FROM sales_flat_quote WHERE customer_is_guest = 0;

3、

SET FOREIGN_KEY_CHECKS=0;
#truncate customer_sales_flat_quote;
#truncate customer_sales_flat_quote_address;
truncate flat_quote;
truncate flat_quote_item;
truncate flat_quote_address;
truncate flat_quote_shipping_rate;
SET FOREIGN_KEY_CHECKS=1;