[Home]

Summary:ASTERISK-19350: [Regression] Asterisk realtime via ODBC - null is inserted in brackets '()'
Reporter:Maciej Krajewski (jamicque)Labels:
Date Opened:2012-02-13 10:56:36.000-0600Date Closed:2012-02-13 15:24:08.000-0600
Priority:MajorRegression?Yes
Status:Closed/CompleteComponents:Resources/res_config_odbc
Versions:1.8.9.2 Frequency of
Occurrence
Constant
Related
Issues:
Environment:Attachments:
Description:I've updated asterisk 1.6 to 1.8 and I've noticed a bug while using odbc (on postgres). When asterisk is trying to insert or update a tble with "null" value it inserts "(null)" (no 4 chars but 6). It can be seen in log bellow:

{code}
UPDATE sip_ps SET ipaddr=E'(null)', port=E'(null)', regseconds=E'1329151764', defaultuser=E'test001', useragent=E'Zoiper rev.11137', lastms=E'0', fullcontact=E'sip:test001@192.168.5.130:5060^3Brinstance=af819e94697f1ee4^3Btransport=UDP' WHERE name=E'test001'
{code}

The easiest way to reproduce the problem is to unregister the registered phone.
Comments:By: Michael L. Young (elguero) 2012-02-13 14:59:29.914-0600

I believe this was just fixed as part of the patch for ASTERISK-19172.

By: Maciej Krajewski (jamicque) 2012-02-13 15:24:09.001-0600

patch for ASTERISK-19172 fix the issue