I edit the request using the /api/v2/contact/get/ method
request body:
{
"filter": {
"phones": [
"0504131703"
]
}
}
It was a pardon:
errorArray:
0: "Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND users.deleted='0' ORDER BY users.id ASC LIMIT 50' at line 1 in query: SELECT users.* FROM users WHERE users.id IN (SELECT userid FROM shopuserphone WHERE phone IN ()) AND users.deleted='0' ORDER BY users.id ASC LIMIT 50"
status: 0
Why is it that the CRM API itself is bad?
I edit the request using the /api/v2/contact/get/ method request body: { "filter": { "phones": [ "0504131703" ] } } It was a pardon: errorArray: 0: "Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND users.deleted='0' ORDER BY users.id ASC LIMIT 50' at line 1 in query: SELECT users.* FROM users WHERE users.id IN (SELECT userid FROM shopuserphone WHERE phone IN ()) AND users.deleted='0' ORDER BY users.id ASC LIMIT 50" status: 0 Why is it that the CRM API itself is bad?
I'm sorry, I don't want to change! Log: [2022-07-04 04:44:38] host: inox-trade.1b.app url: /api/v2/contact/get/ contentID: api-v2-contact-get point: /shop.starter.php engine_sessionid: 1656899078_305 data: Array( [filter] => Array ( [phones] => Array ( [0] => 0504131708 ) ) ) Suggestion: errorArray: 0: "Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND `users`.`deleted`='0' ORDER BY ` users`.`id` ASC LIMIT 50' at line 1 in query: SELECT `users`.* FROM `users` WHERE users.`id` IN (SELECT `userid` FROM `shopuserphone` WHERE `phone` IN ()) AND `users`.`deleted`='0' ORDER BY `users`.`id` ASC LIMIT 50" status: 0
I'm sorry, I don't want to change!
Log:
[2022-07-04 04:44:38]
host: inox-trade.1b.app
url: /api/v2/contact/get/
contentID: api-v2-contact-get
point: /shop.starter.php
engine_sessionid: 1656899078_305
data: Array(
[filter] => Array (
[phones] => Array (
[0] => 0504131708
)
)
)
Suggestion:
errorArray:
0: "Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND `users`.`deleted`='0' ORDER BY ` users`.`id` ASC LIMIT 50' at line 1 in query: SELECT `users`.* FROM `users` WHERE users.`id` IN (SELECT `userid` FROM `shopuserphone` WHERE `phone` IN ()) AND `users`.`deleted`='0' ORDER BY `users`.`id` ASC LIMIT 50"
status: 0
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up