<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Ignore the warnings they're harmless.</div><div><br></div><div>If you want to fix it then wrap another set of curly braces %{} around the conditional expansion.</div><div><br></div><div>-Arran</div><div><br><div><div>On 31 Aug 2011, at 06:54, <a href="http://EasyHorpak.com">EasyHorpak.com</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta http-equiv="content-type" content="text/html; charset=TIS-620">
<div text="#000000" bgcolor="#ffffff">
This error by the update query has ":-" but on my update query it
have not ":-" .<br>
Why debug still show errors and insert instead update !!<br>
<br>
my debug ..<br>
<br>
<span class="Apple-style-span" style="font-family: Sans; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium; ">
<pre style="word-wrap: break-word; white-space: pre-wrap;">Wed Aug 31 11:45:08 2011 : Info: +- entering group accounting {...}
Wed Aug 31 11:45:08 2011 : Info: [sql] expand: %{User-Name} -> ez68044
Wed Aug 31 11:45:08 2011 : Info: [sql] sql_set_user escaped user --> 'ez68044'
Wed Aug 31 11:45:08 2011 : Info: [sql] expand: UPDATE radacct SET ClientIPAddress='%{Client-IP-Address}',FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}',AcctStatusType='%{Acct-Status-Type}',AcctOutputOctets = '%{Acct-Output-Octets}' ,NASIdentifier='%{NAS-Identifier}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime=0 -> UPDATE radacct SET ClientIPAddress='124.122.22.45',FramedIPAddress = '192.168.182.8', AcctSessionTime = '602', AcctInputOctets = '2061724',AcctStatusType='Interim-Update',AcctOutputOctets = '87498073' ,NASIdentifier='112' WHERE AcctSessionId = '4e5dd06400000007' AND UserName = 'ez68044' AND NASIPAddress= '0.0.0.0' AND AcctStopTime=0
Wed Aug 31 11:45:08 2011 : Debug: rlm_sql (sql): Reserving sql socket id: 2
Wed Aug 31 11:45:08 2011 : Info: [sql] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details
Wed Aug 31 11:45:08 2011 : Info: [sql] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details
Wed Aug 31 11:45:08 2011 : Info: [sql] expand: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStatusType,NASIdentifier,now_stamp,ClientIPAddress) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0' ,'%{Acct-Status-Type}','%{NAS-Identifier}',unix_timestamp('%S'),'%{Client-IP-Address}') -> INSERT into radacct (AcctSessionId, AcctUniqu
eId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStart
Wed Aug 31 11:45:08 2011 : Debug: rlm_sql (sql): Released sql socket id: 2
Wed Aug 31 11:45:08 2011 : Info: ++[sql] returns ok</pre>
</span><br>
where can i fix it? please advice me.<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html;
charset=TIS-620">
<a href="http://www.easyzonecorp.net/">http://www.easyzonecorp.net</a>
- โปรแกรมจัดการอินเตอร์เน็ต EasyZone Hotspot Billing, EasyZone
PPPoE Billing, EasyZone Radius Billing, EasyZone VPN Billing <br>
<a href="http://www.easyhorpak.com/">http://www.EasyHorpak.com</a>
- แหล่งค้นหาหอพัก,อพาร์ทเมนท์,แมนชั่น,คอนโด<br>
<a href="http://www.EasyHorpak.com/internet">http://www.EasyHorpak.com/internet</a>
- ผู้ให้บริการติดตั้งอินเตอร์เน็ตในหอพัก <br>
<a href="http://www.EasyHorpak.com/move">http://www.EasyHorpak.com/move</a>
- ผู้ให้บริการรับขนย้าย <br>
<a href="http://www.EasyHorpak.com/software">http://www.EasyHorpak.com/software</a>
- แหล่งรวมโปรแกรมบริหารอพาร์ทเมนท์<br>
<a href="http://www.efooddata.com/">http://www.efooddata.com</a> -
แหล่งขายส่งอาหารออนไลน์ ได้แก่ อาหารทะเล, หมู, เนื้อ, วัว, เป็ด,
ไก่,ปู, ปลา, ผัก, ผลไม้<br>
<a href="http://www.thai-school.net/">http://www.thai-school.net</a>
- เว็บไซต์โรงเรียนสำเร็จรูป ใช้ง่าย สะดวก ปลอดภัย <br>
<a href="http://www.SeamTour.com/">http://www.SeamTour.com</a> -
แหล่งค้นหา บริษัททัวร์ แพคเกจทัวร์, ท่องเที่ยว, ตั๋วเครื่องบิน,
รถให้เช่า, สืบราคา, จอง, ทั่วโลก<br>
</div>
</div>
-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Arran Cudbard-Bell</div><div><a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a></div><div><br></div><div>RADIUS - Half the complexity of Diameter</div></div></span></span>
</div>
<br></div></body></html>