Author Topic: No such message template: option group msg_tpl_workflow_uf, option value uf_noti (Read 4430 times)

Dave Greenberg · November 23, 2010, 05:49:47 pm

Ok - and you said this query returned 0 rows?

SELECT * FROM `civicrm_option_value`
WHERE option_group_id
IN (
SELECT id FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf'
);

If so, the requisite civicrm_option_value record is missing. This SQL snippet should insert the needed record. Please test on a copy of the DB first.

Code: [Select]

  SELECT @tpl_ogid_uf := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf';
  INSERT INTO civicrm_option_value
  (option_group_id,        name,       label,   value,                                  weight)
  VALUES
  (@tpl_ogid_uf, 'uf_notify', 'Profiles - Admin Notification',            1, 1) ;

I would probably run the first SELECT query for the other msg_tpl_workflow_* entries in civicrm_option_group and see if their option value records are also missing. If so, you could run this set of commands instead of the above:

Code: [Select]

  SELECT @tpl_ogid_case := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_case';
  SELECT @tpl_ogid_contribution := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_contribution';
  SELECT @tpl_ogid_event := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_event';
  SELECT @tpl_ogid_friend := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_friend';
  SELECT @tpl_ogid_membership := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_membership';
  SELECT @tpl_ogid_meta := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_meta';
  SELECT @tpl_ogid_pledge := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_pledge';
  SELECT @tpl_ogid_uf := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf';

INSERT INTO civicrm_option_value
  (option_group_id,        name,       label,   value,                                  weight) VALUES
      (@tpl_ogid_case, 'case_activity', 'Cases - Send Copy of an Activity',            1, 1) ,      (@tpl_ogid_contribution, 'contribution_dupalert', 'Contributions - Duplicate Organization Alert',            1, 1) ,      (@tpl_ogid_contribution, 'contribution_offline_receipt', 'Contributions - Receipt (off-line)',            2, 2) ,      (@tpl_ogid_contribution, 'contribution_online_receipt', 'Contributions - Receipt (on-line)',            3, 3) ,      (@tpl_ogid_contribution, 'contribution_recurring_notify', 'Contributions - Recurring Start and End Notification',            4, 4) ,      (@tpl_ogid_contribution, 'pcp_notify', 'Personal Campaign Pages - Admin Notification',            5, 5) ,      (@tpl_ogid_contribution, 'pcp_status_change', 'Personal Campaign Pages - Supporter Status Change Notification',            6, 6) ,      (@tpl_ogid_contribution, 'pcp_supporter_notify', 'Personal Campaign Pages - Supporter Welcome',            7, 7) ,      (@tpl_ogid_event, 'event_offline_receipt', 'Events - Registration Confirmation and Receipt (off-line)',            1, 1) ,      (@tpl_ogid_event, 'event_online_receipt', 'Events - Registration Confirmation and Receipt (on-line)',            2, 2) ,      (@tpl_ogid_event, 'participant_cancelled', 'Events - Registration Cancellation Notice',            3, 3) ,      (@tpl_ogid_event, 'participant_confirm', 'Events - Registration Confirmation Invite',            4, 4) ,      (@tpl_ogid_event, 'participant_expired', 'Events - Pending Registration Expiration Notice',            5, 5) ,      (@tpl_ogid_friend, 'friend', 'Tell-a-Friend Email',            1, 1) ,      (@tpl_ogid_membership, 'membership_offline_receipt', 'Memberships - Signup and Renewal Receipts (off-line)',            1, 1) ,      (@tpl_ogid_membership, 'membership_online_receipt', 'Memberships - Receipt (on-line)',            2, 2) ,      (@tpl_ogid_meta, 'test_preview', 'Test-drive - Receipt Header',            1, 1) ,      (@tpl_ogid_pledge, 'pledge_acknowledge', 'Pledges - Acknowledgement',            1, 1) ,      (@tpl_ogid_pledge, 'pledge_reminder', 'Pledges - Payment Reminder',            2, 2) ,      (@tpl_ogid_uf, 'uf_notify', 'Profiles - Admin Notification',            1, 1) ;

petednz · May 08, 2011, 11:33:31 pm

Quote from: Dave Greenberg on November 23, 2010, 05:49:47 pm

Ok - and you said this query returned 0 rows?
Code: [Select]
SELECT * FROM `civicrm_option_value` WHERE option_group_id IN ( SELECT id FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf' );

Dave - this is bad that i can't recall which site the above related to - but suspect it is not the one I am now hitting it on because when i run the above I get two results (or maybe it is the same site and this is a subsequent problem)

So there are two rows for Profiles - Admin Notification (presumably as we are using an edited version of the tpl) - they both have uf_notify in the name field

In civicrm_option_group there is
78   msg_tpl_workflow_uf   Message Template Workflow for Profiles   Message Template Workflow for Profiles

and in civicrm_option_value is
520   78   Profiles - Admin Notification   1   uf_notify
540   78   Profiles - Admin Notification   1   uf_notify

not sure if above helps but maybe it provides a pointer

Dave Greenberg · May 09, 2011, 01:08:35 pm

I suspect having duplicates in the option_value table is not a good thing and I think you can delete one of those rows. The "linkage" you need to check is the one that connects the actual message templates to that option_value row. So, you need to make sure that the workflow_id in the civicrm_msg_template table for the HTML and TEXT versions of that message template match the option_value ID of the row that you're leaving (not deleting) in that table:

SELECT *
FROM `civicrm_msg_template`
WHERE msg_title = 'Profiles - Admin Notification'

workflow_id in that query result needs to be either 520 or 540 (the id of whichever civicrm_option_value row one you're leaving in place). HTH

ChrisChinchilla · June 19, 2011, 02:54:04 pm

I've managed to fix this after having the same problem, I think due to some sort of wonky upgrade at some point...

Basically...

If I looked in 'civicrm_msg_template' at the 'workflow_id' it didn't match any of the correct entries in 'civicrm_option_value', so I went into 'civicrm_option_value' and changed the appropriate ID to match what was displayed in 'workflow_id', along the way I encountered a few other values with those IDs but none of them were for anything I used, so though that would be OK...

Hope that helps!

gnowak · August 15, 2011, 11:44:04 am

Code: [Select]

SELECT *
FROM `civicrm_msg_template`
WHERE msg_title = 'Profiles - Admin Notification'

SQL result

Code: [Select]

id Message Template ID	msg_title Descriptive title of message	msg_subject Subject for email message.	msg_text Text formatted message	msg_html HTML formatted message	is_active	workflow_id a pseudo-FK to civicrm_option_value	is_default is this the default message template for the workflow referenced by workflow_id?	is_reserved is this the reserved message template which we ship for the workflow referenced by workflow_id?

39	Profiles - Admin Notification	{$grouptitle} {ts 1=$displayName}Submitted by %1{/...	{ts}Submitted For:{/ts} {$displayName}
{ts}Date:{/...	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Trans...	1	509	1	0

40	Profiles - Admin Notification	{$grouptitle} {ts 1=$displayName}Submitted by %1{/...	{ts}Submitted For:{/ts} {$displayName}
{ts}Date:{/...	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Trans...	1	509	0	1

Remark the 1 - 0 and 0 - 1 at the end I think the two entries are OK, because they are not the same.

My workflow_id is 509 in both cases.

and the SQL

Code: [Select]

SELECT * FROM `civicrm_option_value`
WHERE option_group_id
IN (
SELECT id FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_uf'
);

Gives med ID 303

I guess I will change the workflow_id to 303 then :-) Reporting back soon.

BR. GrN.dk

luthien · May 18, 2012, 08:43:19 pm

what about if the id is correct but I still get the error?

Dave Greenberg · May 21, 2012, 09:55:23 am

Might be best to start a new forum post with complete information about the error and what you've done so far to diagnose and solve the problem utilizing the info and queries above.

luthien · May 21, 2012, 09:57:39 am

Hi, why a new forum post if the error is the same and I followed the advice from the post?

CiviCRM Community Forums (archive)

News:

Author Topic: No such message template: option group msg_tpl_workflow_uf, option value uf_noti (Read 4430 times)

Dave Greenberg

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

petednz

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

Dave Greenberg

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

ChrisChinchilla

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

gnowak

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

luthien

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

Dave Greenberg

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti

luthien

Re: No such message template: option group msg_tpl_workflow_uf, option value uf_noti