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

[Henning Westerholt]

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/