Magento M2ePro ‘1690 BIGINT UNSIGNED’ Database Error

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 `listing_title`, 1 AS `is_m2epro_listing`, `cisi`.`is_in_stock` FROM `m2epro_listing_product` AS `main_table` INNER JOIN `m2epro_ebay_listing_product` AS `second_table` ON `second_table`.`listing_product_id` = `main_table`.`id` INNER JOIN `m2epro_listing` AS `l` ON `l`.`id` = `main_table`.`listing_id` INNER JOIN `m2epro_ebay_marketplace` AS `em` ON `em`.`marketplace_id` = `l`.`marketplace_id` INNER JOIN `catalog_product_entity` AS `cpe` ON cpe.entity_id = `main_table`.product_id LEFT JOIN `catalog_product_entity_varchar` AS `cpev` ON `cpev`.`entity_id` = `main_table`.`product_id` AND `cpev`.`attribute_id` = 71 AND `cpev`.`store_id` = 0 LEFT JOIN `m2epro_ebay_item` AS `ebit` ON (`ebit`.`id` = `second_table`.`ebay_item_id`) LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON (`cisi`.`product_id` = `main_table`.`product_id` AND `cisi`.`stock_id` = 1) WHERE (`main_table`.`component_mode` = ‘ebay’) UNION SELECT DISTINCT `main_table`.`account_id`, `main_table`.`marketplace_id`, `main_table`.`product_id`, `second_table`.`title` AS `product_name`, `second_table`.`sku` AS `product_sku`, `second_table`.`currency`, `second_table`.`item_id` AS `ebay_item_id`, `main_table`.`status`, NULL AS `online_sku`, NULL AS `online_title`, (second_table.online_qty – second_table.online_qty_sold) AS `online_qty`, `second_table`.`online_qty_sold`, `second_table`.`online_price` AS `online_buyitnow_price`, NULL AS `listing_id`, NULL AS `listing_title`, 0 AS `is_m2epro_listing`, `cisi`.`is_in_stock` FROM `m2epro_listing_other` AS `main_table` INNER JOIN `m2epro_ebay_listing_other` AS `second_table` ON `second_table`.`listing_other_id` = `main_table`.`id` LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON (`cisi`.`product_id` = `main_table`.`product_id` AND cisi.stock_id = 1) WHERE (`main_table`.`component_mode` = ‘ebay’)) AS `main_table`)'”

This issue can be relatively easily fixed but does require corrections to be made directly to your database, if you have this problem and would like us to fix your M2ePro installation then get in touch.

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *