下訂單後,查看商品頁就變成這樣,請問有人可以幫我嗎

2016-07-07 15:13 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status FROM `chituma_oscom`.`ecs_order_info` AS oi LEFT JOIN `chituma_oscom`.`ecs_users` AS u ON oi.user_id = u.user_id, `chituma_oscom`.`ecs_order_goods` AS og WHERE oi.order_id = og.order_id AND 1348156347 - oi.add_time < 2592000 AND og.goods_id = 6 ORDER BY oi.add_time DESC LIMIT 5 ) [2] => Array ( [error] => BIGINT UNSIGNED value is out of range in '(1348156347 - `chituma_oscom`.`oi`.`add_time`)' ) [3] => Array ( [errno] => 1690 ) )

回答:
帮顶吧,我也不太懂~~~~~~





有回覆好感動阿~
但不知有沒有更詳細的說明?門外漢看這些東西真的是沒辦法,可能需要一個步驟慢慢教
比如說運算放在sql外?那是需要從哪去找到運算?又需要放在sql外的哪裡?
1348156347-oi.add_time這裡有是放在哪的?

未知的谜题哦。。。