Unknown column 'a.help_text' in 'field list'
Maybe this has been the case for a long time and maybe it it due to an old upgrade that didnt go well, but in my install the field help_text is missing. Using latest civirules 2.21 and CiviCRM 5.34beta1
This is the error message:
SELECT a.id as `id`, a.name as `name`, a.label as `label`, a.object_name as `object_name`, a.op as `op`, a.cron as `cron`, a.class_name as `class_name`, a.is_active as `is_active`, a.help_text as `help_text`, a.created_date as `created_date`, a.created_user_id as `created_user_id`, a.modified_date as `modified_date`, a.modified_user_id as `modified_user_id`
FROM civirule_trigger a
WHERE (a.is_active = "1")
[nativecode=1054 ** Unknown column 'a.help_text' in 'field list']"]
PS> I fixed it by manually adding the field to the civirule_trigger table, but I thought it was good to report this
Edited by magnolia61