Hi,
When I run my cron page (/index.php?option=com_community&task=cron), the follow error is returned:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `id` DESC LIMIT , 1' at line 1 SQL=SELECT id FROM `xxx_community_activities` WHERE `archived`='0' AND DATEDIFF('2015-03-22 06:18:16',`created`)<= ORDER BY `id` DESC LIMIT , 1

The complete sql statement:

SELECT id FROM `xxx_community_activities` WHERE `archived`='0' AND DATEDIFF('2015-03-22 06:01:22',`created`)<=7 ORDER BY `id` DESC LIMIT , 7

The problem is the LIMIT value, without a first integer, generating this issue.

In cron settings, I have those parameters:

Maximum Days of Unarchived Activities: 0
Unarchived Activities Limit: 0

Also, I have tested with those:

Maximum Days of Unarchived Activities: 7
Unarchived Activities Limit: 0

Maximum Days of Unarchived Activities: 7
Unarchived Activities Limit: 99999999


Maximum Days of Unarchived Activities: 2
Unarchived Activities Limit: 2000

How to solve?

Hi Paulo,

I just tested it and seems the cron is working fine, actually this issue caused by this code was empty :

$config->get('archive_activity_max_day') //Maximum Days of Unarchived Activities//

$config->get('archive_activity_limit') //Unarchived Activities Limit//

Hi Dimas,
Where local or page I make this change?

HI Paulo,

I just check on your cron page, and seems working fine, I dont get error like you said..

thank you

Yes, the page don't display the error anymore, after I changed some numbers.

But e-mails are not sent. Only joomla e-mails, no jomsocial. The page shows no error.

Hi Paulo,

I put the fix at:
/components/com_community/libraries/notification.php
line 138

case 'inbox':
    $sendIt = true;
    break;

Some users don't receive mail messages anymore(alerts of new activities) in groups when an user sends a new post.
This function stop works and only few users receive the e-mail message.
The new message is sent to mail queue for some users, but the majority don't receive the e-mail, including the admin.
These users have set mail alert properly in privacy configuration, but the email is not send to queue or to e-mail.
I think there is a problem or some type of bug. But I can't detect where the problem occurs.
Probably in a json on database related to user or group, I did several tests but I cant reproduce the situation where the mail are sent properly.
Can you help me please?

Thank you.

Hi Paulo,

any notifications email must be exist at mail queue. could you please tell me what user not receive the notification?

Regards

The user id: 728 must receive notifications for all activities, but the e-mail is not sent anymore.
This user received emails before, but no e-mail is sent now to him.
The e-mail does not go to the mail queue.
Too many users received the e-mail, now, only few users receive the mail massages.
In this user configurations, is set to send email on community groups activities.

Thank You.
Regards.

Hi Paulo,

There is a some restriction at your server? about limitation for sending email?
Because only 5 email sent only. really strange. please asking to your server support about email security configuration.

Regards

But the messages are not send to mail queue.
Only for few users. Many users mail messages does not go to mail queue.

We received the notifications only for the last group, created days ago.
But does not receive from activities. Eg. messages from new topics is going, but the notifications for responses to this topic not.

Hi Paulo,

I found strange configuration at jomsocial backend. please goto Configuration > Privacy, see Default User Email & Notifications.
all email notifications are unchecked. so by default the users will not receive email notification. you must check all that checkbox, click save, and click reset button at the bottom of that page.

Regards

Yes, by default no message is sent to users.
But a lot of users check this option to receive these messages, including me, and the messages isn't sent to mail queue.

Hi Paulo,

could you please provide me phpmyadmin/cpanel access detail? I need to inspect the database, because I tried with test user to replicate the issue, but still cant.

Regards