Re: Re: Re: SQLBill problem. SQL query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This query was clear of time params.
LOG:  statement: UPDATE voipcall SET
	acctstoptime = (now() - '0'::INTERVAL),
	duration = '20',
	terminatecause = '10',
	acctstopdelay = '0',
	setuptime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE,
	connecttime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE,
	disconnecttime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE
	WHERE acctsessionid = '4373fdec00000002'
		AND gkip = 'Y.Y.Y.Y'::INET AND acctstoptime IS NULL

It is set in config like:
UpdateQuery=UPDATE voipcall SET duration = '%d', connecttime =
NULLIF('%{connect-time}','')::TIMESTAMP(0) WITH TIME ZONE,
acctupdatetime = now() WHERE acctsessionid = '%s' AND gkid = '%g' AND
acctstoptime IS NULL

is it bug? =\

thx

/Farid



--
,,, ^ .. ^ ,,,


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id?49
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/


[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux