Database Error 1064
Posted: 16 Apr 2024, 07:02
Hi,
We are having a database error when editing a record. Below is a screenshot for reference.
As you can see in the screenshot, we are having a database error when editing "INVESTIGATION#1" and "INVESTIGATION#2". The troubleshooting steps we did was we created a new INVESTIGATION record with the same values of the INVESTIGATION#1 and we are NOT getting a databse error in the new INVESTIGATION Record, the error only occurs when we try to edit "INVESTIGATION#1" and "INVESTIGATION#2", we are able to edit the rest of the INVESTIGATION records, we are also able to view "INVESTIGATION#1" and "INVESTIGATION#2", the only problem is that we are not able to edit the records for those 2 INVESTIGATIONS. We have not put any SQL Query in the INCIDENT INVESTIGATION entity. We are thinking that maybe a user was set to inactive because in the database error you can see in the where clause "u.id in ()" the query is comparing an ID to a name but the records for "INVESTIGATION#1" and "INVESTIGATION#2" are not created or linked to the user that was sent to inactive.
We are hoping someone can help us with these so that we can understand why the error is happening and we can prevent this happening in the future. Thank you.
We are having a database error when editing a record. Below is a screenshot for reference.
As you can see in the screenshot, we are having a database error when editing "INVESTIGATION#1" and "INVESTIGATION#2". The troubleshooting steps we did was we created a new INVESTIGATION record with the same values of the INVESTIGATION#1 and we are NOT getting a databse error in the new INVESTIGATION Record, the error only occurs when we try to edit "INVESTIGATION#1" and "INVESTIGATION#2", we are able to edit the rest of the INVESTIGATION records, we are also able to view "INVESTIGATION#1" and "INVESTIGATION#2", the only problem is that we are not able to edit the records for those 2 INVESTIGATIONS. We have not put any SQL Query in the INCIDENT INVESTIGATION entity. We are thinking that maybe a user was set to inactive because in the database error you can see in the where clause "u.id in ()" the query is comparing an ID to a name but the records for "INVESTIGATION#1" and "INVESTIGATION#2" are not created or linked to the user that was sent to inactive.
We are hoping someone can help us with these so that we can understand why the error is happening and we can prevent this happening in the future. Thank you.