Errors when something changed

SuiteCRM Forum - English Language
1

Hi,
When I save some records or edit something, I have this error:

image
image810×162 4.88 KB

In my log is such condition:

Mon 02 Aug 2021 02:10:01 PM UTC [3258087][1][FATAL] Query Failed: SELECT a16_employee_leave.id AS id FROM a16_employee_leave WHERE a16_employee_leave.a6_employe0dbarmation_ida = a16_employee_leave.a6_employe0dbarmation_ida AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘254cb8f1-d01f-4035-74c2-6065715a9fa7’ AND aow_processed.parent_id=a16_employee_leave.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND a16_employee_leave.deleted = 0 : MySQL error 1054: Unknown column ‘a16_employee_leave.a6_employe0dbarmation_ida’ in ‘where clause’
Mon 02 Aug 2021 02:11:01 PM UTC [3258149][1][FATAL] Mysqli_query failed.

Can anyone help me?

2

Try several repairs from Admin/Repairs, including Repair relationships.

3

Did not justify, I tried to repair everything. :frowning:

4

I guess you messed up some file somewhere…

Try looking for those table names and field names in your database. Are they there?

And also look for them in the PHP files under custom.

1 Like
5

Hello ,

We have this problem in logs,

https://paste2.org/bcb60Nd8

image
image810×162 4.88 KB

with this display error on saving everthing

help pls
thanks

6

You have a corrupted index in the database, look for MySQL documentation how to rebuild that index.