06-07-2023 09:47:54 ## Exception ## Incorrect string value: '\xF0\x9F\x98\x815\xF0...' for column 'description' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Incorrect string value: '\xF0\x9F\x98\x815\xF0...' for column 'description' at row 1
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-06 09:47:54', 40920, 101, '😁5𝖙', '88721_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\40920\88721_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\40920\88721_Clickedfile.png', '', 48.290848, 28.7116066, '2023-07-06 09:47:22') 
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-07-2023 03:00:05 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 50442177 is not a valid phone number.
06-07-2023 03:25:40 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 66572326 is not a valid phone number.
06-07-2023 07:09:51 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
select A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.name as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2023-07-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
06-07-2023 07:29:29 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
select A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.name as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2023-07-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data