WorkFlow MySQL error

I am use 7.9.6

SuiteCRM.log

LEFT JOIN devza_device_zakaz devza_device_zakaz_notes_1 ON devza_device_zakaz_notes_1.id=devza_device_zakaz_notes_1_c.devza_device_zakaz_notes_1devza_device_zakaz_ida AND devza_device_zakaz_notes_1.deleted=0
LEFT JOIN devza_device_zakaz_cstm devza_device_zakaz_notes_1_cstm ON devza_device_zakaz.id = devza_device_zakaz_notes_1_cstm.id_c WHERE devza_device_zakaz_notes_1_cstm.device_status_c = ‘repair_done’ AND notes.id = ‘cf488b03-9e36-96da-68de-59e4dc52adf1’ LIMIT 0,1: MySQL error 1054: Unknown column ‘devza_device_zakaz.id’ in ‘on clause’
Mon Oct 16 20:22:06 2017 [15522][1][FATAL] Get One Failed:SELECT notes.id AS id FROM notes LEFT JOIN devza_device_zakaz_notes_1_c ON notes.id=devza_device_zakaz_notes_1_c.devza_device_zakaz_notes_1notes_idb AND devza_device_zakaz_notes_1_c.deleted=0

LEFT JOIN devza_device_zakaz devza_device_zakaz_notes_1 ON devza_device_zakaz_notes_1.id=devza_device_zakaz_notes_1_c.devza_device_zakaz_notes_1devza_device_zakaz_ida AND devza_device_zakaz_notes_1.deleted=0
LEFT JOIN devza_device_zakaz_cstm devza_device_zakaz_notes_1_cstm ON devza_device_zakaz.id = devza_device_zakaz_notes_1_cstm.id_c WHERE devza_device_zakaz_notes_1_cstm.device_status_c = ‘repair_done’ AND notes.id = ‘cf488b03-9e36-96da-68de-59e4dc52adf1’: MySQL error 1054: Unknown column ‘devza_device_zakaz.id’ in ‘on clause’

It seems the problem is in a table you made yourself, some customization, right?

When you do a Quick Repair and Rebuild, and scroll down to the bottom, do you see a button to sync database with vardefs? If so, press it.

Thanks for answer.

Yes i can make custom “Print to PDF” button for my custom module, and create automation workflow for this module (notes + custom module).

After “Quick Repair and Rebuild” not show “sync database with vardefs” button…

Well something must have broken your customization (maybe a migration or an upgrade?)…

Can you check for that field “devza_device_zakaz.id” in your database? Maybe add it manually?