Error : 11:19:02 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > authentic - 31 | {
    "code": "ER_BAD_FIELD_ERROR",
    "errno": 1054,
    "sqlMessage": "Unknown column 'LoginId' in 'where clause'",
    "sqlState": "42S22",
    "index": 0,
    "sql": "SELECT * FROM SecurityUser WHERE LoginId = 'undefined'  and Status = 'Active'; SELECT Password as MasterPassword FROM SecurityUser WHERE SecurityUserId = 'Master' ;"
}

Error : 11:19:24 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 11:20:49 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 11:26:31 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 12:34:34 : D:\ValueCare\Valuecare_Backend\app\services\appointment.service.js > getBookAppointment - 21 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.BookAppointment' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spGetBookAppointmentData('{}','')"
}

Error : 12:35:39 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 12:35:42 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 12:36:50 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 12:38:47 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {}

Error : 12:41:34 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {
    "code": "ER_INVALID_JSON_TEXT_IN_PARAM",
    "errno": 3141,
    "sqlMessage": "Invalid JSON text in argument 1 to function json_extract: \"Invalid escape character in string.\" at position 1015.",
    "sqlState": "22032",
    "index": 1,
    "sql": "CALL spAddUpdateSecurityUser('{\"UserTypeId\":\"3b8e503e-f848-11ec-86e0-fa163ebffd39\",\"Appointment\":\"1\",\"CoordinatorEmail\":\"sohan@12@gmail.com\",\"CoordinatorName\":\"Sohan\",\"CoordinatorPhone\":\"6543210987\",\"Country\":\"India\",\"DOB\":\"2000-01-19\",\"GroupHome\":\"home\",\"IsNdisDocument\":\"1\",\"IsLiving\":\"1\",\"RelativeEmail\":\"kusum@gmail.com\",\"RelativeName\":\"Kusum\",\"RelativePhone\":\"9876543210\",\"RelativePostalCode\":\"777777\",\"RelativeState\":\"Banglore\",\"RelativeStreetAddress\":\"Flora institute for technology\",\"RelativeStreetName\":\"khopi ,shivapur\",\"RelativeStreetSuburb\":\"pune\",\"Services\":\"Daily Persional Activities,Therapeutic Services for Children,Early Childhood Services\",\"AddrLine1\":\"saswad shmbhu raje marag\",\"AddrLine2\":\"katraj road\",\"Email\":\"chhayabagwan.cognisun@gmail.com\",\"FirstName\":\"chhaya\",\"IsNdisRegistered\":\"1\",\"LastName\":\"Jaiswal\",\"MiddleName\":\"\",\"NDISNumber\":\"998877\",\"Password\":\"Ritu@12\",\"PhoneNumber\":\"6688442233\",\"PostalCode\":\"12121\",\"State\":\"MadhayaPradesh\",\"Suburb\":\"Khategaon\",\"UserName\":\"vivek.cognisun@gmail.com\",\"Document\":\"C:\\\\fakepath\\\\phpsysinfo.conf\",\"Relation\":\"father\",\"RelationType\":\"father\"}',' ')"
}

Error : 12:47:52 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {
    "code": "ER_INVALID_JSON_TEXT_IN_PARAM",
    "errno": 3141,
    "sqlMessage": "Invalid JSON text in argument 1 to function json_extract: \"Invalid escape character in string.\" at position 1015.",
    "sqlState": "22032",
    "index": 1,
    "sql": "CALL spAddUpdateSecurityUser('{\"UserTypeId\":\"3b8e503e-f848-11ec-86e0-fa163ebffd39\",\"Appointment\":\"1\",\"CoordinatorEmail\":\"sohan@12@gmail.com\",\"CoordinatorName\":\"Sohan\",\"CoordinatorPhone\":\"6543210987\",\"Country\":\"India\",\"DOB\":\"2000-01-19\",\"GroupHome\":\"home\",\"IsNdisDocument\":\"1\",\"IsLiving\":\"1\",\"RelativeEmail\":\"kusum@gmail.com\",\"RelativeName\":\"Kusum\",\"RelativePhone\":\"9876543210\",\"RelativePostalCode\":\"777777\",\"RelativeState\":\"Banglore\",\"RelativeStreetAddress\":\"Flora institute for technology\",\"RelativeStreetName\":\"khopi ,shivapur\",\"RelativeStreetSuburb\":\"pune\",\"Services\":\"Daily Persional Activities,Therapeutic Services for Children,Early Childhood Services\",\"AddrLine1\":\"saswad shmbhu raje marag\",\"AddrLine2\":\"katraj road\",\"Email\":\"chhayabagwan.cognisun@gmail.com\",\"FirstName\":\"chhaya\",\"IsNdisRegistered\":\"1\",\"LastName\":\"Jaiswal\",\"MiddleName\":\"\",\"NDISNumber\":\"998877\",\"Password\":\"Ritu@12\",\"PhoneNumber\":\"6688442233\",\"PostalCode\":\"12121\",\"State\":\"MadhayaPradesh\",\"Suburb\":\"Khategaon\",\"UserName\":\"vivek.cognisun@gmail.com\",\"Document\":\"C:\\\\fakepath\\\\phpsysinfo.conf\",\"Relation\":\"father\",\"RelationType\":\"father\"}',' ')"
}

Error : 13:03:27 : D:\ValueCare\Valuecare_Backend\app\services\authentic.service.js > addUpdateUser - 76 | {
    "code": "ER_INVALID_JSON_TEXT_IN_PARAM",
    "errno": 3141,
    "sqlMessage": "Invalid JSON text in argument 1 to function json_extract: \"Invalid escape character in string.\" at position 1015.",
    "sqlState": "22032",
    "index": 1,
    "sql": "CALL spAddUpdateSecurityUser('{\"UserTypeId\":\"3b8e503e-f848-11ec-86e0-fa163ebffd39\",\"Appointment\":\"1\",\"CoordinatorEmail\":\"sohan@12@gmail.com\",\"CoordinatorName\":\"Sohan\",\"CoordinatorPhone\":\"6543210987\",\"Country\":\"India\",\"DOB\":\"2000-01-19\",\"GroupHome\":\"home\",\"IsNdisDocument\":\"1\",\"IsLiving\":\"1\",\"RelativeEmail\":\"kusum@gmail.com\",\"RelativeName\":\"Kusum\",\"RelativePhone\":\"9876543210\",\"RelativePostalCode\":\"777777\",\"RelativeState\":\"Banglore\",\"RelativeStreetAddress\":\"Flora institute for technology\",\"RelativeStreetName\":\"khopi ,shivapur\",\"RelativeStreetSuburb\":\"pune\",\"Services\":\"Daily Persional Activities,Therapeutic Services for Children,Early Childhood Services\",\"AddrLine1\":\"saswad shmbhu raje marag\",\"AddrLine2\":\"katraj road\",\"Email\":\"chhayabagwan.cognisun@gmail.com\",\"FirstName\":\"chhaya\",\"IsNdisRegistered\":\"1\",\"LastName\":\"Jaiswal\",\"MiddleName\":\"\",\"NDISNumber\":\"998877\",\"Password\":\"Ritu@12\",\"PhoneNumber\":\"6688442233\",\"PostalCode\":\"12121\",\"State\":\"MadhayaPradesh\",\"Suburb\":\"Khategaon\",\"UserName\":\"vivek.cognisun@gmail.com\",\"Document\":\"C:\\\\fakepath\\\\phpsysinfo.conf\",\"Relation\":\"father\",\"RelationType\":\"father\"}',' ')"
}

Error : 17:37:29 : D:\ValueCare\Valuecare_Backend\app\services\appointment.service.js > getBookAppointment - 21 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.BookAppointment' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spGetBookAppointmentData('{}','')"
}

Error : 17:38:14 : D:\ValueCare\Valuecare_Backend\app\services\appointment.service.js > addUpdateAppointment - 56 | {
    "code": "ER_INVALID_JSON_TEXT_IN_PARAM",
    "errno": 3141,
    "sqlMessage": "Invalid JSON text in argument 1 to function json_extract: \"Missing a name for object member.\" at position 282.",
    "sqlState": "22032",
    "index": 0,
    "sql": "CALL spAddUpdateAppointment('{\"SecurityUserId\":\"e60a67f3-13c8-11ed-bbd5-6618c4d40f69\",\"Service\":\"service1,service2\",\"ModeOfCommunication\":\"test123@\",\"AppointmentTime\":\"19:38:00\",\"AppointmentDate\":\"2022-10-19\",\"Location\":\"test123@\",\"VCofficeLocation\":\"test123@\",\"CallType\":\"VideoCall\",\"PhoneNumber\":\"8734658445\"}','')"
}

Error : 17:38:31 : D:\ValueCare\Valuecare_Backend\app\services\appointment.service.js > deleteAppointment - 67 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.BookAppointment' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spAppointmentDelete('{}')"
}

Error : 18:27:00 : D:\ValueCare\Valuecare_Backend\app\services\Referral.service.js > getReferralData - 44 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.Referral' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spGetReferalData('{}','')"
}

Error : 18:27:11 : D:\ValueCare\Valuecare_Backend\app\services\Referral.service.js > deleteReferral - 33 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.Referral' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spDeleteReferral('{\"ReferralId\":\"42897d1d-0f3d-11ed-bbd5-6618c4d40f69\"}')"
}

Error : 18:28:40 : D:\ValueCare\Valuecare_Backend\app\services\Referral.service.js > deleteReferral - 33 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.Referral' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spDeleteReferral('{\"ReferralId\":\"42897d1d-0f3d-11ed-bbd5-6618c4d40f69\"}')"
}

Error : 18:28:42 : D:\ValueCare\Valuecare_Backend\app\services\Referral.service.js > getReferralData - 44 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.Referral' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spGetReferalData('{}','')"
}

Error : 18:28:45 : D:\ValueCare\Valuecare_Backend\app\services\Referral.service.js > getReferralData - 44 | {
    "code": "ER_NO_SUCH_TABLE",
    "errno": 1146,
    "sqlMessage": "Table 'valuecarecognisu_dev.Referral' doesn't exist",
    "sqlState": "42S02",
    "index": 0,
    "sql": "CALL spGetReferalData('{}','')"
}