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

[David Villasmil]

Hello,

During startup, i only get that one.
I really appreciate your help

David

On Mon, Sep 17, 2018, 21:04 Henning Westerholt <hw at kamailio.org> wrote:

> Am Montag, 17. September 2018, 14:40:43 CEST schrieb David Villasmil:
> > 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)
>
> Hi David,
>
> do you get this error during startup or during run-time? Is this the only
> error that you get?
>
> Best regards,
>
> Henning
>
> --
> Henning Westerholt
> https://skalatan.de/blog/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180917/9ba20d52/attachment.html>