Monthly Archives - Jan 2015

Magento M2ePro ‘1690 BIGINT UNSIGNED’ Database Error

Recently we have come across a few clients that have an SQL database error appear in the search tab of the M2ePro eBay Listings page. The error looks like this; Fatal error occurred: “SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in ‘(SELECT COUNT(*) FROM (SELECT DISTINCT `l`.`account_id`, `l`.`marketplace_id`, `main_table`.`product_id`, `cpev`.`value` AS `product_name`, `cpe`.`sku` AS `product_sku`, `em`.`currency`, `ebit`.`item_id` AS `ebay_item_id`, `main_table`.`status`, `second_table`.`online_sku`, `second_table`.`online_title`, (second_table.online_qty - second_table.online_qty_sold) AS `online_qty`, `second_table`.`online_qty_sold`, `second_table`.`online_buyitnow_price`, `l`.`id` AS `listing_id`, `l`.`title` AS [...]