A-A+

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

2013年12月02日 灵犀一指 SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range已关闭评论 阅读 3,192 人 次

在删除目录产品的时候,有时候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;

标签:

评论已关闭!