The error message is self-explanatory. You don’t have a “boxc_id” field in your mysql dlr table.
From: [email protected] [mailto:[email protected]] On Behalf Of Vijay kumar Dadhich Sent: Wednesday, 07 March, 2012 14:37 To: [email protected]; Willy Mularto; K.V.Shiva Kumar Subject: Fwd: dlr problem; Hello , I am not getting dlr and i mention the log below. 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 69 64 3a 65 35 37 66 35 37 38 62 20 73 75 62 3a id:e57f578b sub: 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 30 30 31 20 64 6c 76 72 64 3a 30 30 31 20 73 75 001 dlvrd:001 su 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 62 6d 69 74 20 64 61 74 65 3a 31 32 30 33 30 37 bmit date:120307 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 31 39 30 34 20 64 6f 6e 65 20 64 61 74 65 3a 31 1904 done date:1 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 32 30 33 30 37 31 39 30 34 20 73 74 61 74 3a 44 203071904 stat:D 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 45 4c 49 56 52 44 20 65 72 72 3a 30 30 30 20 74 ELIVRD err:000 t 2012-03-07 19:04:59 [28511] [6] DEBUG: data: 65 78 74 3a 20 20 32 35 31 32 31 37 39 37 2d 30 ext: 25121797-0 2012-03-07 19:04:59 [28511] [6] DEBUG: Octet string dump ends. 2012-03-07 19:04:59 [28511] [6] DEBUG: message_state: 2 = 0x00000002 2012-03-07 19:04:59 [28511] [6] DEBUG: receipted_message_id: "e57f578b" 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP PDU dump ends. 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP[route1] handle_pdu, got DLR 2012-03-07 19:04:59 [28511] [6] DEBUG: DLR[mysql]: Looking for DLR smsc=route1, ts=e57f578b, dst=TEST, type=1 2012-03-07 19:04:59 [28511] [6] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxc_id` FROM `sms_dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1 2012-03-07 19:04:59 [28511] [6] ERROR: MYSQL: Unable to prepare statement: Unknown column 'boxc_id' in 'field list' 2012-03-07 19:04:59 [28511] [6] WARNING: DLR[mysql]: DLR from SMSC<route1> for DST<TEST> not found. 2012-03-07 19:04:59 [28511] [6] ERROR: SMPP[route1]: got DLR but could not find message or was not interested in it id<e57f578b> dst<TEST>, type<1> 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP[route1]: Sending PDU: 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP PDU 0xb35025b8 dump: 2012-03-07 19:04:59 [28511] [6] DEBUG: type_name: deliver_sm_resp 2012-03-07 19:04:59 [28511] [6] DEBUG: command_id: 2147483653 = 0x80000005 2012-03-07 19:04:59 [28511] [6] DEBUG: command_status: 0 = 0x00000000 2012-03-07 19:04:59 [28511] [6] DEBUG: sequence_number: 8 = 0x00000008 2012-03-07 19:04:59 [28511] [6] DEBUG: message_id: NULL 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP PDU dump ends. 2012-03-07 19:04:59 [28511] [6] DEBUG: SMPP[route1]: throughput (-0.00,0.00) i face this problem please send the solution for this. i need your help. -- Thanks & Regards, -- Thanks & Regards, -Vijay Kumar Dadhich Entrepreneur Motivational speaker [email protected] Mob. No.:- 09891993899 :- 09887729709
