On Wed, Aug 26, 2009 at 12:11 AM, Mauro Sergio Ferreira Brasil<mauro.bra...@tqi.com.br> wrote: > Hello there! > > Problem found. > > For some reason, the update statement below is generated with an invalid > atribution of empty value '' to field "port" that is an integer. > Because of that, this record keeps with prior "fullcontact" information > that was updated by another client (which uses a different port) what > leads to wrong client rtp packets routing... wow... that was weird... :-) > > [Aug 25 17:57:43] DEBUG[20801] res_config_mysql.c: MySQL RealTime: > Query: UPDATE sip_buddies SET fullcontact = '', ipaddr = '', port = '', > regseconds = '0', username = '', regserver = '' WHERE name = '101' > [Aug 25 17:57:43] DEBUG[20801] res_config_mysql.c: MySQL RealTime: Query > Failed because: Incorrect integer value: '' for column 'port' at row 1 > > First of all... my appologies by the false alarm. > But now I need your help to identify why is this update statement being > generated wrongly. > > Does someone have any idea ?
Asterisk Realtime Architecutre currently treats all fields as strings. I wish too that it would take into account actual field type retrieved from DESCRIBE statement and add the quotes only if it's string. You can safely do ALTER TABLE sip_buddies CHANGE COLUMN port port VARCHAR(5); Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, IQ Labs Inc, a...@iq-labs.net Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users