CiviCRM Community Forums (archive)

I have created a petition, but when I sign it, I get the following error:

No such message template: option group msg_tpl_workflow_petition, option value petition_confirmation_needed.

The signature is succesful (the contact data is submitted), but no e-mail confirmation is sent, as well as the problem with the message.

I imagine this has to do with some missing template, but I don't have a good knowledge of CiviCRM templating system, so I'm completely dark on where to look for this. I appreciate any help.

1. No, there it works ok

2. An upgrade (from 2.x, 2.2.x, if I'm not mistaken)

3. Drupal 6.5, CiviCRM 3.3.5

On a second thought, I the problem might not appear to a registered user because he does not require an e-mail confirmation (I guess I read this was the default behaviour for petitions).

Any clues?

Followed the suggestion and extracted missing templates from original install DB dump.

INSERT INTO `civicrm_option_group` VALUES
( 76, 'msg_tpl_workflow_petition', 'Message Template Workflow for Petition',
'Message Template Workflow for Petition', 0, 1 );

INSERT INTO `civicrm_option_value` VALUES
(684,76,'Petition - need verification','2','petition_confirmation_needed',NULL,NULL,0,2,NULL,0,0,1,NULL,NULL,NULL),
(685,76,'Petition - signature added','1','petition_sign',NULL,NULL,0,1,NULL,0,0,1,NULL,NULL,NULL);


Still giving the same error... the only thing I changed from the original dump was the id number (67 was the original, but already taken). Trying disabling and re-enabling civicrm module, but no change :(

Hi,
WHat you have are the config to say that the message to send is petition_confirmation_needed

You still need to INSERT it into the message table.

Search on the dump you have another petition_confirmation_needed, don't you?

X+

I was still missing the inserts into civicrm_msg_template. However, this is still not enough. The same error occurs.

As I did not find any field mapping between civicrm_msg_template and civicrm_option_group, I suspect there might be missing two to four inserts elsewhere, that are capable of making this link. However, I'm completely lost here.

Here the newly inserted rows.

INSERT INTO civicrm_msg_template VALUES
(104,'Petition - signature added','Thank you for signing {$petition.title}','Thank you for signing {$petition.title}.\n','<p>Thank you for signing {$petition.title}.</p>\n\n{include file=\"CRM/Campaign/Page/Petition/SocialNetwork.tpl\" petition_id=$survey_id noscript=true email=true}\n',1,556,1,0),
(105,'Petition - signature added','Thank you for signing {$petition.title}','Thank you for signing {$petition.title}.\n','<p>Thank you for signing {$petition.title}.</p>\n\n{include file=\"CRM/Campaign/Page/Petition/SocialNetwork.tpl\" petition_id=$survey_id noscript=true email=true}\n',1,556,0,1),
(106,'Petition - need verification','Confirmation of signature needed for {$petition.title}\n','Thank you for signing {$petition.title}.\n\nIn order to complete your signature, we must confirm your e-mail. \nPlease do so by visiting the following email confirmation web page:\n\n{$petition.confirmUrlPlainText} \n\nIf you did not sign this petition, please ignore this message.\n','<p>Thank you for signing {$petition.title}.</p>\n\n<p>In order to <b>complete your signature</b>, we must confirm your e-mail. \n<br />\nPlease do so by visiting the following web page by clicking\non the link below or pasting the link into your browser.\n<br /><br />\nEmail confirmation page: <a href=\"{$petition.confirmUrl} \">{$petition.confirmUrl}</a></p>\n\n<p>If you did not sign this petition, please ignore this message.</p>\n',1,557,1,0),
(107,'Petition - need verification','Confirmation of signature needed for {$petition.title}\n','Thank you for signing {$petition.title}.\n\nIn order to complete your signature, we must confirm your e-mail. \nPlease do so by visiting the following email confirmation web page:\n\n{$petition.confirmUrlPlainText} \n\nIf you did not sign this petition, please ignore this message.\n','<p>Thank you for signing {$petition.title}.</p>\n\n<p>In order to <b>complete your signature</b>, we must confirm your e-mail. \n<br />\nPlease do so by visiting the following web page by clicking\non the link below or pasting the link into your browser.\n<br /><br />\nEmail confirmation page: <a href=\"{$petition.confirmUrl} \">{$petition.confirmUrl}</a></p>\n\n<p>If you did not sign this petition, please ignore this message.</p>\n',1,557,0,1);


That was the missing link! When I imported the records from the vanilla DB, I missed that workflow_id was supposed to match the id in civicrm_option_value.

Now it works perfectly.

Special thanks to dlobo, dgg and xavier in IRC #civicrm!

Did you also make an upgrade from 2.x?