{"success":false,"error":" [wrapped: Could not execute query [Native Error: Incorrect DATETIME value
By dariobillo - Mon Jun 06, 2022 8:50 am
- Mon Jun 06, 2022 8:50 am
#829967
I'm running PM 3.7 and I have a problem as follow. I'm trying to create new users (in a new installation), but I'm unable to select roles because they simply don't appear in the dropdown menu.
So I tried by devOps and I find that userAjax answers in this way for this field
"{"success":false,"error":" [wrapped: Could not execute query [Native Error: Incorrect DATETIME value: ''] [User Info: SELECT RBAC_ROLES.ROL_UID, RBAC_ROLES.ROL_PARENT, RBAC_ROLES.ROL_SYSTEM, RBAC_SYSTEMS.SYS_CODE, RBAC_ROLES.ROL_CODE, RBAC_ROLES.ROL_CREATE_DATE, RBAC_ROLES.ROL_UPDATE_DATE, RBAC_ROLES.ROL_STATUS FROM RBAC_ROLES, RBAC_SYSTEMS WHERE RBAC_ROLES.ROL_UID<>'' AND RBAC_ROLES.ROL_CODE<>'PROCESSMAKER_GUEST' AND RBAC_SYSTEMS.SYS_CODE='PROCESSMAKER' AND RBAC_ROLES.ROL_CREATE_DATE<>'' AND RBAC_ROLES.ROL_UPDATE_DATE<>'' AND RBAC_ROLES.ROL_SYSTEM=RBAC_SYSTEMS.SYS_UID]]"}"
I've yet verified mySQL doesn't accept "RBAC_ROLES.ROL_CREATE_DATE<>'' AND RBAC_ROLES.ROL_UPDATE_DATE<>''", it wants "RBAC_ROLES.ROL_CREATE_DATE IS NOT NULL AND RBAC_ROLES.ROL_UPDATE_DATE IS NOT NULL", so I'm trying to change the SQL construction in the code.
I found the BusinessModel\User and the classes UserRoles and BaseUserRoles, but I'm unable to prosecute, to find where I have to modify the code.
Please, are you able to indicate me where I have to prosecute? Thank you in advance
So I tried by devOps and I find that userAjax answers in this way for this field
"{"success":false,"error":" [wrapped: Could not execute query [Native Error: Incorrect DATETIME value: ''] [User Info: SELECT RBAC_ROLES.ROL_UID, RBAC_ROLES.ROL_PARENT, RBAC_ROLES.ROL_SYSTEM, RBAC_SYSTEMS.SYS_CODE, RBAC_ROLES.ROL_CODE, RBAC_ROLES.ROL_CREATE_DATE, RBAC_ROLES.ROL_UPDATE_DATE, RBAC_ROLES.ROL_STATUS FROM RBAC_ROLES, RBAC_SYSTEMS WHERE RBAC_ROLES.ROL_UID<>'' AND RBAC_ROLES.ROL_CODE<>'PROCESSMAKER_GUEST' AND RBAC_SYSTEMS.SYS_CODE='PROCESSMAKER' AND RBAC_ROLES.ROL_CREATE_DATE<>'' AND RBAC_ROLES.ROL_UPDATE_DATE<>'' AND RBAC_ROLES.ROL_SYSTEM=RBAC_SYSTEMS.SYS_UID]]"}"
I've yet verified mySQL doesn't accept "RBAC_ROLES.ROL_CREATE_DATE<>'' AND RBAC_ROLES.ROL_UPDATE_DATE<>''", it wants "RBAC_ROLES.ROL_CREATE_DATE IS NOT NULL AND RBAC_ROLES.ROL_UPDATE_DATE IS NOT NULL", so I'm trying to change the SQL construction in the code.
I found the BusinessModel\User and the classes UserRoles and BaseUserRoles, but I'm unable to prosecute, to find where I have to modify the code.
Please, are you able to indicate me where I have to prosecute? Thank you in advance