Ideally, I'd like to leverage the fire_object_event utility method, as I'm basically replicating the core aspects of it right now. The fire_test_notification method is returning as a successful event, but the osrferror log shows a severe query error when checking for the org.bounced_emails setting, where it's not finding what I'm assuming is the org id. This error also appears when I utilize fire_object_event, and I'm not entirely sure why it's not picking up the org id. I'm also unsure as to where or why this check is being made. As of now, the SQL file to create the new entries in event_hooks and event_definition are nonexistent, but the entries are present on my environment:
Hook: key: au.email.test, core_type: au, description: "A test email has been requested for a user.", passive: false
Definition: active: true, owner: 1, name: "Email Test Notification", Hook: au.email.test, Validator: NOOP_True, reactor: SendEmail, delay_interval: 00:01:00, template: https://gist.github.com/khuckins/4f8994064a3669e4d0bce8853ed675ba
The particular error I'm running into is:
2018-09-17 16:38:10 kcls-greenlandic open-ils.cstore: [ERR :32145:oils_sql.c:5898:15372022753212029] open-ils.cstore: Error with query [SELECT * FROM actor.org_unit_ancestor_setting( 'org.bounced_emails', '' ) AS "actor.org_unit_ancestor_setting" ;]: 3484946 3484946: ERROR: invalid input syntax for integer: ""
LINE 1: ....org_unit_ancestor_setting( 'org.bounced_emails', '' ) AS "a... ^
I've pushed up a WIP branch here: http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ khuckins/ lp1777677- test-notificati on-method
Ideally, I'd like to leverage the fire_object_event utility method, as I'm basically replicating the core aspects of it right now. The fire_test_ notification method is returning as a successful event, but the osrferror log shows a severe query error when checking for the org.bounced_emails setting, where it's not finding what I'm assuming is the org id. This error also appears when I utilize fire_object_event, and I'm not entirely sure why it's not picking up the org id. I'm also unsure as to where or why this check is being made. As of now, the SQL file to create the new entries in event_hooks and event_definition are nonexistent, but the entries are present on my environment: /gist.github. com/khuckins/ 4f8994064a3669e 4d0bce8853ed675 ba
Hook: key: au.email.test, core_type: au, description: "A test email has been requested for a user.", passive: false
Definition: active: true, owner: 1, name: "Email Test Notification", Hook: au.email.test, Validator: NOOP_True, reactor: SendEmail, delay_interval: 00:01:00, template: https:/
The particular error I'm running into is: oils_sql. c:5898: 153720227532120 29] open-ils.cstore: Error with query [SELECT * FROM actor.org_ unit_ancestor_ setting( 'org.bounced_ emails' , '' ) AS "actor. org_unit_ ancestor_ setting" ;]: 3484946 3484946: ERROR: invalid input syntax for integer: "" unit_ancestor_ setting( 'org.bounced_ emails' , '' ) AS "a...
^
2018-09-17 16:38:10 kcls-greenlandic open-ils.cstore: [ERR :32145:
LINE 1: ....org_