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

6,142 人次阅读
没有评论

共计 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;

正文完
 0