Добрый день!
An error occurred while sending sms: DEBUG: sql: INSERT INTO sent_sms ( sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data ) VALUES ( NULL, 'DLR', 'SNGB', '+79682012971', NULL, 'id:33303613023 sub:001 dlvrd:001 submit date:1602051127 done date:1602051127 stat:DELIVRD err:0 text: ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''id:33303613023 sub:001 dlvrd:001 submit date:1602051127 done date:1602051127 st' at line 1 2016-02-05 13:32:57 [57147] [4] DEBUG: smsbox_to_bearerbox: sms received SMPP dump: 2016-02-05 13:33:01 [57268] [6] DEBUG: Optional parameter length read as 12 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP[smstraffic_test]: Got PDU: 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP PDU 0x7f259c000a30 dump: 2016-02-05 13:33:01 [57268] [6] DEBUG: type_name: deliver_sm 2016-02-05 13:33:01 [57268] [6] DEBUG: command_id: 5 = 0x00000005 2016-02-05 13:33:01 [57268] [6] DEBUG: command_status: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: sequence_number: 404759 = 0x00062d17 2016-02-05 13:33:01 [57268] [6] DEBUG: service_type: NULL 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr_ton: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr_npi: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: source_addr: "79682012971" 2016-02-05 13:33:01 [57268] [6] DEBUG: dest_addr_ton: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: dest_addr_npi: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: destination_addr: "SNGB" 2016-02-05 13:33:01 [57268] [6] DEBUG: esm_class: 4 = 0x00000004 2016-02-05 13:33:01 [57268] [6] DEBUG: protocol_id: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: priority_flag: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: schedule_delivery_time: NULL 2016-02-05 13:33:01 [57268] [6] DEBUG: validity_period: NULL 2016-02-05 13:33:01 [57268] [6] DEBUG: registered_delivery: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: data_coding: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2016-02-05 13:33:01 [57268] [6] DEBUG: sm_length: 116 = 0x00000074 2016-02-05 13:33:01 [57268] [6] DEBUG: short_message: 2016-02-05 13:33:01 [57268] [6] DEBUG: Octet string at 0x7f259c000d60: 2016-02-05 13:33:01 [57268] [6] DEBUG: len: 116 2016-02-05 13:33:01 [57268] [6] DEBUG: size: 117 2016-02-05 13:33:01 [57268] [6] DEBUG: immutable: 0 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 69 64 3a 33 33 33 30 33 37 37 32 35 31 35 20 73 id:33303772515 s 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 75 62 3a 30 30 31 20 64 6c 76 72 64 3a 30 30 31 ub:001 dlvrd:001 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 20 73 75 62 6d 69 74 20 64 61 74 65 3a 31 36 30 submit date:160 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 32 30 35 31 31 33 32 20 64 6f 6e 65 20 64 61 74 2051132 done dat 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 65 3a 31 36 30 32 30 35 31 31 33 33 20 73 74 61 e:1602051133 sta 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 74 3a 44 45 4c 49 56 52 44 20 65 72 72 3a 30 20 t:DELIVRD err:0 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 74 65 78 74 3a 54 65 73 74 20 44 4c 52 20 53 4d text:Test DLR SM 2016-02-05 13:33:01 [57268] [6] DEBUG: data: 50 50 20 33 PP 3 2016-02-05 13:33:01 [57268] [6] DEBUG: Octet string dump ends. 2016-02-05 13:33:01 [57268] [6] DEBUG: message_state: 2 = 0x00000002 2016-02-05 13:33:01 [57268] [6] DEBUG: receipted_message_id: "33303772515" 2016-02-05 13:33:01 [57268] [6] DEBUG: SMPP PDU dump ends. Send code: my $resp = $smpp->submit_sm( source_addr => 'SNGB', source_addr_ton => 0x05, source_addr_npi => 0x01, destination_addr => $phone, dest_addr_ton => 0x01, dest_addr_npi => 0x01, data_coding => 0x08, message_payload => $msg_ucs2, esm_class => 0x00, registered_delivery => 1);
