You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
version: opensips 3.6.0-dev (x86_64/linux)
flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, HP_MALLOC, DBG_MALLOC, CC_O0, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll, sigio_rt, select.
git revision: eea7b4e51
main.c compiled on 10:20:53 Nov 6 2024 with cc 11
Describe the bug
Keeps reporting "invalid parameter value" errors when executing sql_query("update ...").
e.g. sql_query("update users set online=1 where exten='1000'")
No error when do sql_query("select...")
To Reproduce
...
loadmodule "db_oracle.so"
...
event_route[E_UL_CONTACT_INSERT] {
sql_query("update users set is_online=1 where exten='" + $(param(aor){s.escape.common}) + "'");
}
Expected behavior
No error execution sql_query("update...")
Relevant System Logs
Nov 06 10:24:49 xxx opensips[154140]: ERROR:db_oracle:db_oracle_raw_query: invalid parameter value
Nov 06 10:24:49 xxx opensips[154140]: ERROR:sqlops:sql_query: raw_query failed: db0(usr_preferences) update users set is_online=1, reg_flags...
The text was updated successfully, but these errors were encountered:
OpenSIPS version you are running
Describe the bug
Keeps reporting "invalid parameter value" errors when executing sql_query("update ...").
e.g. sql_query("update users set online=1 where exten='1000'")
No error when do sql_query("select...")
To Reproduce
Expected behavior
No error execution sql_query("update...")
Relevant System Logs
The text was updated successfully, but these errors were encountered: