Search code examples
magentoproductsql-deletemysql-error-1064outofrangeexception

Error in magento when I try to delete a product


When I try to delete a product in Magento I get the next error and I don't know where is the problem.

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


Solution

  • Please try this:

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

    It works for me.