CiviCRM Community Forums (archive)

Looks like you've configured this Profile to "Notify when profile form is submitted?" - i.e. send email to someone in your organization whenever the profile form is submitted. However, for some reason the "System Workflow Message Template" that is used to format that email seems to be missing or disabled on your site.

Navigate to Administer > Configure > Message Templates and select System Workflow Messages tab. You should see a list of templates used for various automated emails, including one labeled "Profiles - Admin Notification". If this is missing, then either some upgrade process wasn't run or didn't insert the required data OR something else happened to remove or modify this required record.

Are you running the site in a language other than English - might be a localisation bug?

You can see what "should be there" on the public demo after logging in:
http://drupal.demo.civicrm.org/civicrm/admin/messageTemplates?selectedChild=workflow&reset=1

Are you running the site in English?
Have you upgraded to latest version (3.2.3) - your profile shows 3.2 beta?

It seems like somethings not quite right with your meta-data - possibly an upgrade bug or ??

Can you run this SQL statement and post back the results:
SELECT * FROM `civicrm_option_value`
WHERE option_group_id
IN (
SELECT id FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf'
);
[code]

You should get back one row with Label column = 'Profiles - Admin Notification'. If you get no rows, try this query:
[code]
SELECT * FROM `civicrm_option_value` where `label` = 'Profiles - Admin Notification';


(See info under your user name in left column for your "profile". Click Profile above to update it.)[/code][/code]

The text in the 'name' column in that row should be 'uf_notify'. If it's some other string - than that would explain the error and I guess you could update that row and set name = 'uf_notify'. However, if this is the case do post back here so we might get a clue about where things went wrong.

If the 'name' column text is correct, then you'll need to debug the query that's failing inside the code. It's in CRM/Core/BAO/MessageTemplates.php. The query is constructed starting on line 356 (it's a SELECT statement). You'll need to print out the values of the 2 parameters passed to it, and then try running the query in your DB - that should help you figure out what's wrong. In a "working" site:

$params['groupName'] is 'msg_tpl_workflow_uf'
$params['valueName'] is 'uf_notify'

(relooking at the query, it might be that the civicrm_msg_template row joined by the query does NOT have is_default = 1, so I'd look at that too)

hi dave - hit the same error msg

No such message template: option group msg_tpl_workflow_uf, option value uf_notify.

Ran the two SQl above and got zero rows on both.

Can you suggest a next step?

had another thought to just resave the default Profiles - Admin Notification but no joy

If it helps, this is an 'old' site that has been regularly upgraded, so probably from pre 2.x maybe. Now on 3.2.5

Actually, the upgrade code is there:

CRM/Upgrade/3.1.alpha1.msg_template/civicrm_msg_template.tpl

Would be good to see if any of the msg template option groups got inserted:
SELECT * FROM `civicrm_option_group` WHERE name like 'msg_tpl_workflow%';