×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: PHP
Posted by: bejoy balan
Added: Sep 23, 2014 7:06 AM
Views: 58
Magento deleting product BIGINT UNSIGNED value is out of range
  1. SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`magento_store`.`q`.`items_count` - 1)'
  2. Option 1
  3.  
  4. DELETE FROM magento_sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);
  5. Option 2
  6.  
  7. DELETE FROM magento_sales_flat_quote WHERE customer_is_guest = 0;
  8. Option 3
  9.  
  10. SET FOREIGN_KEY_CHECKS=0;
  11. #truncate magento_enterprise_customer_sales_flat_quote;
  12. #truncate magento_enterprise_customer_sales_flat_quote_address;
  13. truncate magento_sales_flat_quote;
  14. truncate magento_sales_flat_quote_item;
  15. truncate magento_sales_flat_quote_address;
  16. truncate magento_sales_flat_quote_shipping_rate;
  17. SET FOREIGN_KEY_CHECKS=1;