[SR-Users] Can't get from cache: $sqlrows(asg)

[David Villasmil]

Hello guys,

i've got this in my config:

Module config:

modparam("sqlops","sqlcon","asg=>mysql://DB_USER:DB_PASS@DB_HOST/kamailio")

Route:
        sql_query("asg", "insert ignore dispatcher (id, setid, destination,
flags, priority, attrs, description) values (NULL, $var(dispatcher_id),
'sip:$si:5080', 0, 0, 'weight=$var(new_weight);maxload=50', '$fU')");
        xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] Affected rows:
$sqlrows(asg)\n");
        if ($sqlrows(asg)>0) {
            ds_reload();
        } else {
            xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] COULD NOT ADD THE NEW
GATEWAY WITH IP $si AND USERNAME $fU\n");
        }

and i'm getting:

 0(3929) CRITICAL: <core> [core/cfg.y:3447]: yyerror_at(): parse error in
config file /etc/kamailio/kamailio.cfg, line 1261, column 20-32: Can't get
from cache: $sqlrows(asg)

I can't figure out where the problem might be.

Can anyone help?

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
ᐧ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180917/907f372e/attachment.html>