âerrorsâ: {
âstatusâ: 400,
âtitleâ: null,
âdetailâ: âDatabase failure. Please refer to suitecrm.log for details.â
}
}Database failure. Please refer to suitecrm.log for details.
In the suitecrm.log i have
Mon Oct 12 20:57:37 2020 [][][FATAL] Mysqli_query failed.
Mon Oct 12 20:57:37 2020 [][][FATAL] Error retrieving Contact list: Query Failed: SELECT contacts.id , contacts.assigned_user_id FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c where (contacts.phone_home = âXXXXXXXXXâ OR contacts.phone_mobile = âXXXXXXXXXâ OR contacts.phone_work = âXXXXXXXXXâ OR contacts.phone_other = âXXXXXXXXXâ OR contacts.deleted = â0â) AND contacts.deleted=0 LIMIT 0,-98: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near â-98â at line 1
If i run the query manualy with 98 instead of -98, no errors found and with results.
Is there someone with same issue?
Thanks