Schedule plugin eMail don#t work

[kissinger]

Hallo!

I tested the eMail - schedule - plugin, but it don't send eMails.

I published the Fabrik schedule system plug-in.

It runs all 5 minutes, but I don't get an eMail.

Help please!

 

[kissinger]

It seems that the whole schedule-system does not work in 3.1b

 

[kissinger]

For a test I create a php-cron test file:

<?php
// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();
$db =&JFactory::getDBO();
$db->setQuery("UPDATE `ect_kontostand` SET `kontostand` = kontostand + 1");
$db->query();

I run it manually and als cron-job many time. But there is no change in the database

My settings:

What's the matter?

 

[cheesegrits]

Looking at this now.

-- hugh

 

[cheesegrits]

Hmm, seems to work for me.

Can you try just putting:

exit;

... as the first line of your script? See if you just get a blank page when you hit the "Run" button.

-- hugh

 

[kissinger]

Hallo Hugh,

yes I get a blank page.

 

[cheesegrits]

OK, in which case the code is executing.

So next place to look is see if the query errored out.

Try:

JError::raiseError(500, "Err? " . $db->getErrorMsg());

... as the last line. Oh, and obviously take the exit out now.

-- hugh

 

[kissinger]

I get an error-message:

An error has occurred.

500 Err?​

Return to Control Panel

 

[cheesegrits]

OK, but no actual error from MySQL.

Is the ect_kontostand table on the default J! site database connection?

-- hugh

 

[kissinger]

Yes!

 

[kissinger]

Hallo Hugh,

it works now, the value in the table increses.

Could you please still check out the schedule eMail-plugin?

 

[kissinger]

Oh, I see, the php-plugin works only i I start it manually in the administration, if I take it as cron it dosn't work.

 

[cheesegrits]

Ok, I think that should now be fixed in github.

Thanks for reporting this, it was a bug which prevented the plugins from running via the front end system plugin, where they would run from the backend with the 'Run' button.

-- hugh

 

[kissinger]

Hallo Hugh,

thank you. Yes it seems to work, but I make a test with this data, see Subject:

I get the eMail, but the subject is this:

In the database-table the value of the field "ect_unterrubriken___name" is "Restaurant".

Thank you!

 

[troester]

Try with {ect_unterrubriken___name_raw}

 

[kissinger]

Hallo troester,

thank you. It works now.