Arithmetic operation resulted in an overflow when execute SQL statement.

Hi guys,
I have reveived this error msg Arithmetic operation resulted in an overflow. when execute my SQL statement. (mysql database)
it's working fine when tested in localhost, but error occured when i uploaded to my VPS.
SELECT *, (SELECT cg1.name1 FROM category_general cg1 WHERE cg1.type = 'parent' AND cg1.ID = pg.ParentCatID) as ParentCatName, (SELECT cg2.name1 FROM category_general cg2 WHERE cg2.type = 'child' AND cg2.ID = pg.ChildCatID) as ChildCatName FROM product_general pg INNER JOIN product_detail pd ON pg.ID = pd.ID INNER JOIN product_pricing pp ON pg.ID = pp.ID INNER JOIN product_inventory pi ON pg.ID = pi.ID INNER JOIN product_shipping ps ON pg.ID = ps.ID INNER JOIN product_images pim ON pg.ID = pim.ID WHERE pg.ChildCatID = (SELECT ID FROM category_general WHERE type = 'child' AND name1 = 'samsung' AND remark1 = 'smartphone' AND status = 'A')
Try ...