Post-by-email: Kunena Notifications Not Sent, [added as new function in latest version] Options

[Reggie]

I have subscribers to Kunena Categories that expect e-mail notification for new post. However when Post-by-email inserts new posts into Kunena, notifications are not being sent. Is there a way to achieve this?

[Adler]

I've got the same issue - can you please look into this/let us know?
Thank you!

[Web Design Seo]

Will check. I think that component dont have such a function.

[Chris Grant]

I have just installed the latest post_by_email_pro_j25_1.6.2 - for Kunena 2.0 and over which is running Joomla 1.7 and Kunena 2.0

I have seven different Kunena categories set up in admin with individual email address boxes. When I perform import, I find:

- New postings work fine and go to the correct category as a new topic.
- Reply postings Re' etc go to the wrong category.

I cannot see what I can have done with my setup, all looks fine. On looking in the code of controller.php line 969 seems to be missing the category id in the query.

Код

$db->setQuery("SELECT parent, thread, catid FROM #__kunena_messages WHERE subject={$db->quote($subject_to_match)} ORDER BY time DESC");
if($message_match = $db->loadObject()) {
    $thread = $message_match->thread;
    $catid = $message_match->catid;
    $subject = 'Re: '.$subject_to_match;
}

Without it, I can't see the point of defining the category against a mailbox in the admin settings. This query is looking for a subject match in ANY messages regardless of the category set in the mailbox loop. We often have common topic titles in different forum categories.

Even when I add the AND catid=$catid it still fails to insert the reply email into the correct topic.

Can you please advise.

This is a great component potentially but even if the above can be fixed, it doesn't actually do what I thought it would do to allow remote postings into Kunena because it fails to email the new message out to subscribers which of course Kunena does if you post a message on-line. All this needs is a call to the Kunena email subscribers library after the new post has been inserted. I will try to add this myself as I am in a hurry to get a proper solution, otherwise I can't see any point in using it because subscribers will never get an alert.

Hoping you can help me quickly to get this otherwise great component working as it should.

Thanks

Chris

[Chris Grant]

Reggie

I have subscribers to Kunena Categories that expect e-mail notification for new post. However when Post-by-email inserts new posts into Kunena, notifications are not being sent. Is there a way to achieve this?

I agree and have posted today a new topic on this. The component is not complete without notifications. It really isn't hard to achieve by calling the Kunena library function 'message' to send out notifications to a new message.

I don't suppose you ever got a reply?

[Web Design Seo]

Your recommendation is ok. I have not answer you, because we work on this function. Is ready - this function is built-in in next version of Post by Email plus one more.

The new version will be published in next 1-2 days.

[Web Design Seo]

v.1.6.3 of Post by Email for Joomla is here! Added are options:

- "Notify subscribers" option for Kunena
- storing of information from messages in database - sender's name and/or e-mail address.



Is updated Joomla 2.5 version only!

[Chris Grant]

Thanks, I've downloaded it and will try it

Your recommendation is ok. I have not answer you, because we work on this function. Is ready - this function is built-in in next version of Post by Email plus one more.

The new version will be published in next 1-2 days.

Can you also please reply to my question about missing category in the loop and why replies get posted to the wrong category. New postings seem to work fine.

Thanks

Chris

[Web Design Seo]

Our programmer say me that there is no missing category in query and code is ok. You have option to post reply in topic, category have nothing about. If you have setup the id of right topic with write permissions, reply will be posted.

Work or not this function in your site? If not, we can check again.

[Chris Grant]

Thanks for getting back again

Pleae ask your programmer to look again. The controller.php loops through each email box (which is effectively a category set in the admin page) and the query in line 969

$db->setQuery("SELECT parent, thread, catid FROM #__kunena_messages WHERE subject={$db->quote($subject_to_match)} ORDER BY time DESC");
if($message_match = $db->loadObject()) {
$thread = $message_match->thread;
$catid = $message_match->catid;
$subject = 'Re: '.$subject_to_match;
}

makes no check of the category. If you have many categories as most forums do, it may find the topic subject in more than one category meaning that $catid and $thread are now set to post this reply into the wrong category.

I wonder if you have tested it on a Kunena setup where there are identical message subjects in more than one category? Please try it and see what I mean.

My apologies if I am missing something but I just can't see how this code can work correctly.

Thanks and regards

Chris

[Ivan Stamenov]

Thanks for getting back again

Pleae ask your programmer to look again. The controller.php loops through each email box (which is effectively a category set in the admin page) and the query in line 969

$db->setQuery("SELECT parent, thread, catid FROM #__kunena_messages WHERE subject={$db->quote($subject_to_match)} ORDER BY time DESC");
if($message_match = $db->loadObject()) {
$thread = $message_match->thread;
$catid = $message_match->catid;
$subject = 'Re: '.$subject_to_match;
}

makes no check of the category. If you have many categories as most forums do, it may find the topic subject in more than one category meaning that $catid and $thread are now set to post this reply into the wrong category.

I wonder if you have tested it on a Kunena setup where there are identical message subjects in more than one category? Please try it and see what I mean.

My apologies if I am missing something but I just can't see how this code can work correctly.

Thanks and regards

Chris

Hi, Mr. Grant.

You are absolutely right. To fix this bug, please replace lines 1012 to 1017 in controller.php:

Код

$db->setQuery("SELECT parent, thread, catid FROM #__kunena_messages WHERE subject={$db->quote($subject_to_match)} ORDER BY time DESC");
if($message_match = $db->loadObject()) {
    $thread = $message_match->thread;
    $catid = $message_match->catid;
    $subject = 'Re: '.$subject_to_match;
}

with:

Код

$db->setQuery("SELECT thread FROM #__kunena_messages WHERE catid=$catid AND subject={$db->quote($subject_to_match)} LIMIT 1");
if($thread = (int) $db->loadResult())
    $subject = 'Re: '.$subject_to_match;

I remain with

Best regards,

Ivan

[Chris Grant]

Ivan

Hi, Mr. Grant.

You are absolutely right. To fix this bug, please replace lines 1012 to 1017 in controller.php:

[code]$db->setQuery("SELECT parent. . . . . . . .

Thanks for checking, I have updated my script but I have run out of downloads on my account for this so I wonder if you might give me another so I can get the next version including this fix when its ready.

The 'notify subscribers' works in theory but any Kunena language headers and footers are not processed but appear in the email message as 'COM_KUNENA_POST_EMAIL_FOOTER' instead of the language file text. This does not happen with posts directly from Kunena so there may be a library missing in your cron base file or something.

Best regards

Chris

[Ivan Stamenov]

Ivan



Thanks for checking, I have updated my script but I have run out of downloads on my account for this so I wonder if you might give me another so I can get the next version including this fix when its ready.

The 'notify subscribers' works in theory but any Kunena language headers and footers are not processed but appear in the email message as 'COM_KUNENA_POST_EMAIL_FOOTER' instead of the language file text. This does not happen with posts directly from Kunena so there may be a library missing in your cron base file or something.

Best regards

Chris

Hi, Chris.

I'll check with our admin about the additional downloads...

Regarding the missing language variables - I was unable to locate 'COM_KUNENA_POST_EMAIL_FOOTER' in any of the Kunena language files (using Comodo and "Search in files" on Kunena latest version's install package). Most of the notification language variables are defined in /administrator/components/com_kunena/language/xx-XX/xx-XX.com_kunena.libraries.ini and this file do gets loaded on line 622 in the Post By Email's controller...

Best regards,

Ivan