03-06-2026 08:24:56 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ##  ## ClientType: Mobile
03-06-2026 08:24:56 ## Error ##  ## DataAccess.SetData ##  ## Error ## ClientType: Mobile
03-06-2026 08:24:56 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 08:24:56 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 08:26:36 ## Error ##  ## DataAccess.SetData ##  ## Error
03-06-2026 08:26:36 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 20:02:16 ## Error ##  ## DataAccess.SetData ##  ## Error ## ClientType: Mobile
03-06-2026 20:02:16 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ##  ## ClientType: Mobile
03-06-2026 20:02:16 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 20:02:16 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 21:11:22 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ##  ## ClientType: Mobile
03-06-2026 21:11:22 ## Error ##  ## DataAccess.SetData ##  ## Error ## ClientType: Mobile
03-06-2026 21:11:22 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 21:11:22 ## Exception ## Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ##  ## 
03-06-2026 21:13:20 ## Exception ## 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 '! = ( 2)  order by t.vdate' at line 1 ## DataAccess.GetData ##  ## ABCRM_ManageTask
select t.id, t.vno, t.vdate, t.title, t.description, mst_task_type.name as task_type_name,  (Case IFNULL(t.status, 0) when 0 then 'Open'  when 1 then 'Completed'  when 2 then 'Cancel'  when 3 then 'Reopen'  when 4 then 'InProgress'  else '' end)  as last_task_status,  t.start_datetime, t.due_datetime,  (Case IFNULL(t.priority, 0) when 0 then 'Low'  when 1 then 'Medium'  when 2 then 'High'  else '' end)  as priority, mst_owner.name as owner_name,   t.related_to_id, mst_location.name as location_name,  (case when mst_related_to.id is not null then mst_related_to.name else abcrm_tr_lead.vno end) as related_to_name,  (case when mst_related_to.id is not null then mst_related_to.name else lead_contact.name end) as related_to_contact,  (case when mst_related_to.id is not null then mst_related_to.off_phone else lead_contact.off_phone end) as related_to_phone,  (Case IFNULL(t.related_to_type, 0) when 0 then 'None'  when 150 then 'Lead'  when 155 then 'CustomerCareTicket'  when 175 then 'Installation'  when 2084 then 'Contact'  else '' end)  as related_to_type,  (select group_concat(con.name) from abcrm_collaborators collab left outer join abcrm_mst_contact con on con.id = collab.contact_id  where collab.vid = t.id) as collaborators, ent_user.full_name as created_by  from abcrm_tr_task t  left outer join mst_location on mst_location.id = t.branch_id  left outer join mst_common mst_task_type on mst_task_type.id = t.task_type_id  left outer join abcrm_mst_contact mst_owner on mst_owner.id = t.owner_id  left outer join abcrm_mst_contact mst_related_to on mst_related_to.id = t.related_to_id  left outer join abcrm_tr_lead on abcrm_tr_lead.id = t.related_to_id  left outer join abcrm_mst_contact lead_contact on lead_contact.id = abcrm_tr_lead.contact_id  left outer join log_edit on (log_edit.vid = t.id and log_edit.action_type = 0 )  left outer join ent_user on ent_user.id = log_edit.user_id  where t.enterprise_id = 'f2afc785-e051-4c64-b09d-05402d42093a' and t.company_id = '19b9ce22-dfd4-4db5-a3e4-95619d1192e3'  and DATE(t.vdate) BETWEEN '2026-04-01 00:00:00' and '2027-03-31 00:00:00'    and IFNULL(t.status, 0) ! = ( 2)  order by t.vdate 
 Inner Exception: NULL 
 Error: 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 '! = ( 2)  order by t.vdate' at line 1
 Source: MySql.Data
 ## ClientType: Mobile