AOW Emails fail - PHP errors

šŸ’¬ General Discussion
1

7.2.2 MAX on Windows Server 2008 with IIS, PHP 5.3
Was a fresh install a couple months ago, with some customizing since then.

Iā€™m puzzled by an issue I canā€™t resolve. Iā€™ve made a workflow where the action is Send Email upon New Record. When the proper record is saved, it does get created, but the email isnā€™t sent, and the user is taken only to a blank page.

With error logging set to Error, nothing appears in the CRM log. At the PHP log, I see:

PHP Fatal error: Class name must be a valid object or a string in C:\inetpub\wwwroot\suitecrm\modules\AOW_Actions\actions\templateParser.php on line 110

Iā€™ve learned a lot in the past year, but am not adept enough to figure out exactly what the problem here is. Not sure it isnā€™t file permission issues, or something else. When I look in that file, here are the lines Iā€™m seeing:

101 static function parse_template($string, &$bean_arr) {
102 global $beanFiles, $beanList;
103
104 $person = array();
105
106 foreach($bean_arr as $bean_name => $bean_id) {
107
108 require_once($beanFiles[$beanList[$bean_name]]);
109
110 $focus = new $beanList[$bean_name];
111 $focus->retrieve($bean_id);
112
113 $string = aowTemplateParser::parse_template_bean($string, strtolower($beanList[$bean_name]), $focus);
114
115 if($focus instanceof Person){
116 $person[] = $focus;
117 }
118
119 }

Any tips or assistance would be GREATLY appreciated!

Thanks,
Darrel

2

Hi Darrel,
Would it be possible to post a screenshot of the Workflow itself?

Thanks, John

3

Here it is. I have it inactive since it causes that issue, and set to me instead of the user Andy for now.
Also, the same issue occurs if I pick any of the stock (yet irrelevant) templates, too.

4

Hi Darrel,

Can that userā€™s E-mail address successfully receive E-mails? You can test it by Going to Admin > Email Settings and Sending a Test E-mail with their address.

If the E-mail is received then it is likely that the issue lies with your chosen E-mail Template as it is not one that comes with SuiteCRM.
If you have any Templates you can test with then you could Send an E-mail using those, this would act as testing to see if it is the ā€œNew Opportunity Alertā€ Template causing Issue

5

I edited my last reply to include that Iā€™ve tried the other templates with the same result. And the user thatā€™s on the workflow now is myself, and I do successfully receive other emails from the system.

Any other thoughts?

6

Now Iā€™ve even tried an almost totally blank template, just to see if it was a field on them that was causing the issue. Still no luck.

My ugly workaround is to create tasks for people that link to the opportunities I wanted to email them in the first place. :frowning:

Any other suggestions to troubleshoot would be greatly appreciated!

7

Hi Darrel,

It may be worth re-checking that your permissions and owner/group user settings are correct.
Also, In your config.php file, ensure that :
dir_mode => 1517
file_mode => 420

Do any errors appear in the console during the process, even at the blank screen? You can open the console with ctrl+shift+k in firefox

Thanks, John

8

Does all that apply to a Windows 2008 environment?

I checked those lines in config.php and they were 1528 and 432, respectively.
I made the changes, then saved, then restarted Apache. No luck.

I also noticed the User and Group are blank here. Are they required, and could you suggest what the should be?

Thanks John.

9

I canā€™t seem to edit my last reply ā€“ I wanted to correct it to add new info:

Iā€™ve started a XAMPP (Apache) installation to test with, inside a Windows Server 2008 machine. I copied my entire SuiteCRM prod folder into it. Now I see some more info when my workflow with email gets triggered - the browser only shows a page with these, from the PHP error log:

Warning: require_once(C:\XAMPP\xampp\htdocs\crm) [function.require-once]: failed to open stream: Permission denied in C:\XAMPP\xampp\htdocs\crm\modules\AOW_Actions\actions\templateParser.php on line 109

Fatal error: require_once() [function.require]: Failed opening required ā€˜ā€™ (include_path=ā€˜C:\XAMPP\xampp\htdocs\crm;C:\XAMPP\xampp\htdocs\crm\include\HTMLPurifier/standalone;C:\XAMPP\xampp\htdocs\crm\include/ā€¦;.;C:\XAMPP\xampp\php\PEAR;modules/AOD_Index/Libā€™) in C:\XAMPP\xampp\htdocs\crm\modules\AOW_Actions\actions\templateParser.php on line 109