CiviCRM Community Forums (archive)

Please help!

My cronjob configured like:
http://www.xxx.dk/administrator/components/com_civicrm/civicrm/bin/cli.php?job=process_mailing&name=xxx&pass=xxx&key=xxx
is running fine.

But no jobs are sent from my scheduled mailing list.

In the list of log entries for: Mailings scheduler I see:

Date:
2012-06-25 12:36:09   

Job Name:
Mailings scheduler      

Command/Job Status/Additional Information:
0
Summary
Starting execution of Mailings scheduler

Details
Parameters raw (From cron.php):
a:11:{s:6:"__utma";s:54:"48560305.244398191.1329394059.1340357730.1340618242.73";s:6:"__utmz";s:92:"48560305.1331894914.26.7.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not provided)";s:32:"31cf23dd51a31064667c8c2115341d91";s:32:"134d9b543f48bdf08b084e057a3a4c63";s:13:"bb2_screener_";s:23:"1340618137 80.71.135.52";s:6:"__utmb";s:24:"48560305.3.10.1340618242";s:6:"__utmc";s:8:"48560305";s:32:"74c5086950321a83a59fe55e5a4988ab";s:32:"c8acd7492023f0f939f817bec88d4549";s:26:"jpanesliders_panel-sliders";s:1:"0";s:26:"jpanesliders_position-icon";s:1:"0";s:9:"PHPSESSID";s:32:"a694d175282c59398134841f5bdc9516";s:7:"version";s:1:"3";}

Parameters parsed (and passed to API method):
a:11:{s:6:"__utma";s:54:"48560305.244398191.1329394059.1340357730.1340618242.73";s:6:"__utmz";s:92:"48560305.1331894914.26.7.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not provided)";s:32:"31cf23dd51a31064667c8c2115341d91";s:32:"134d9b543f48bdf08b084e057a3a4c63";s:13:"bb2_screener_";s:23:"1340618137 80.71.135.52";s:6:"__utmb";s:24:"48560305.3.10.1340618242";s:6:"__utmc";s:8:"48560305";s:32:"74c5086950321a83a59fe55e5a4988ab";s:32:"c8acd7492023f0f939f817bec88d4549";s:26:"jpanesliders_panel-sliders";s:1:"0";s:26:"jpanesliders_position-icon";s:1:"0";s:9:"PHPSESSID";s:32:"a694d175282c59398134841f5bdc9516";s:7:"version";s:1:"3";}

Full message:
Starting execution of Mailings scheduler

Best Regards

Pelle

Thanks

Fixed my problem to.

I now get:

Full message:
Finished execution of Mailings scheduler with result: Success (a:0:{})

Thanks for the hint.

Best Regards

Pelle

Hi osep

I simply followed the guide from Andy...

Best Regards

Pelle



civicrm/CRM/Utils/System/Joomla.php function loadBootStrap

1. line 533: joomlaBase needs a trailing slash or it loses the final path component (again, my site's in a subdirectory so maybe that's why)
$joomlaBase = dirname(dirname(dirname(dirname(dirname(dirname(dirname(dirname(__FILE__)))))))) . "/";

2. line 540: JPATH_BASE is set as the administrator path. When JFactory::getApplication("administrator") is later called in civicrm/CRM/Utils/Hook/Joomla.php, if I trace the instantiation through to the JApplication::getInstance method, the path to the JAdministrator application.php has "administrator" twice in it (e.g. "<JPATH_BASE>/administrator/administrator/includes/application.php"). That, of course, fails.  I redefined JPATH_BASE to be the base Joomla path, without "/administrator".  This may be something I don't understand about Joomla and a red herring.
define('JPATH_BASE', $joomlaBase);

3. after line 544: To instantiate the JAdministrator class (e.g. through JFactory::getApplication in Hook/Joomla.php), the JURI class needs to be defined, which it was not. Include that after libraries/import.php:
require $joomlaBase . '/libraries/joomla/environment/uri.php';

That seems to now correctly boostrap Joomla when running the cron script via REST, getting past the 500 error.


The separate issue I mentioned with the user database prefix seems to be benign for Joomla; doesn't seem to get used.  But a step towards fixing it is:

civicrm/CRM/Core/Config.php function _setUserFrameworkConfig

1. Around line 58, when attempting to set the user table name, change the "global $mainframe" line to:
$mainframe = null;
if(class_exists("JFactory")) $mainframe = & JFactory::getApplication();

This is only a step towards fixing it, not a final solution, since it only applies when running CiviCRM through the Joomla admin console - not when running the cron script directly via URL.  Just wanted to point out that this code is wrong but can be fixed, provided it's not vestigial or unneeded for Joomla.

Regards,
Andy

Hi again

I use the standard setup from the manual.

And I use the following cronjob setup on my webhotel.

wget -O - -q -t 1  "http://www.name.dk/administrator/components/com_civicrm/civicrm/bin/cron.php?job=process_mailing&name=Postmand&pass=password&key=key#"

Hope this helps