errorArray ( [0] => HY000 [1] => 1615 [2] => Prepared statement needs to be re-prepared )
query SELECT COUNT(S.code) AS TOT_CS_CNT, ifnull(SUM(CASE WHEN S.PROCSTATE = 1 THEN 1 ELSE 0 END), 0) TOT_RCPT_CNT, ifnull(SUM(CASE WHEN S.PROCSTATE = 2 THEN 1 ELSE 0 END), 0) TOT_WAREHOUSING_CNT, ifnull(SUM(CASE WHEN S.PROCSTATE IN(3,5,6) THEN 1 ELSE 0 END), 0) TOT_PROC_CNT, ifnull(SUM(CASE WHEN S.PROCSTATE = 4 THEN 1 ELSE 0 END), 0) TOT_COMPL_CNT, ifnull(SUM(CASE WHEN S.STATE = 1 AND S.PROCSTATE = 1 THEN 1 ELSE 0 END),0) TOT_AS_RCPT_CNT, ifnull(SUM(CASE WHEN S.STATE = 1 AND S.PROCSTATE IN(2,3,5,6) THEN 1 ELSE 0 END),0) TOT_AS_PROC_CNT, ifnull(SUM(CASE WHEN S.STATE = 1 AND S.PROCSTATE = 4 THEN 1 ELSE 0 END),0) TOT_AS_COMPL_CNT, ifnull(SUM(CASE WHEN S.STATE = 2 AND S.PROCSTATE = 1 THEN 1 ELSE 0 END),0) TOT_RTN_RCPT_CNT, ifnull(SUM(CASE WHEN S.STATE = 2 AND S.PROCSTATE IN(2,3,5,6) THEN 1 ELSE 0 END),0) TOT_RTN_PROC_CNT, ifnull(SUM(CASE WHEN S.STATE = 2 AND S.PROCSTATE = 4 THEN 1 ELSE 0 END),0) TOT_RTN_COMPL_CNT FROM B2B_COLLECT.CS_ORDER_ITEMS S JOIN B2B_COLLECT.COMPUTER_CS C ON C.CODE = S.CSCODE AND C.ISDEL = 0 WHERE S.CUST = :memberId AND TO_DAYS(S.INSERTDATE) BETWEEN TO_DAYS(DATE_ADD(CURDATE(), INTERVAL -1 MONTH)) AND TO_DAYS(CURDATE())
paramArray ( [memberId] => )
file/home/comkoweb/public_html/index.php (line:178)
/home/comkoweb/public_html/lib/class.order.php (line:1316)
infoArray ( [0] => HY000 [1] => 1615 [2] => Prepared statement needs to be re-prepared )