Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] "invalid parameter value" when do sql_query("update ...") #3505

Open
GangZhuo opened this issue Nov 6, 2024 · 0 comments · May be fixed by #3504
Open

[BUG] "invalid parameter value" when do sql_query("update ...") #3505

GangZhuo opened this issue Nov 6, 2024 · 0 comments · May be fixed by #3504

Comments

@GangZhuo
Copy link
Contributor

GangZhuo commented Nov 6, 2024

OpenSIPS version you are running

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...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant