👩‍💻 Check out our latest job positions here 👈 or send us a PM for more info.

Errors when something changed

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

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?

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

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

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

Hello ,

We have this problem in logs,

https://paste2.org/bcb60Nd8

with this display error on saving everthing

help pls
thanks

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