Error when running cronjob for notifications

I don't believe the notifications are completely 100%, i've been testing them and there's this topic

Mysql error 0 is regarding Mysql Starting serviceMysql error 0 is regarding Mysql Starting service

mhhh... I am not sure to understand what you are talking about, let's see if someone from the official people reply

thanks anyway

Please check if you have lastsend DATETIME column of the fgd7_js_res_user_options table.

this is what I see in phpmyadmin

Can you run this query in PMA and see what error it will report. Because Joomla sql error reporting system sometimes do not show true error.

which query?

I do not see any text in your comment

Ok,

I ran the query in phpmyadmin and here is the error I receive

the query I copied/pasted is this

SQL=SELECT user_id FROM fgd7_js_res_notifications WHERE AND alerted = 0 AND user_id NO IN ( SELECT user_id FROM fgd7_js_res_user_options WHERE schedule > 1 OR lastsend < NOW() - INTERVAL 1 MINUTE)

There seems to be 2 mistakes in the query ...

The AND after where and the NOT instead of NO

SELECT user_id FROM fgd7_js_res_notifications WHERE alerted = 0 AND user_id NOT IN ( SELECT user_id FROM fgd7_js_res_user_options WHERE schedule > 1 OR lastsend < NOW() - INTERVAL 1 MINUTE)

running the query suggested by Sack

SELECT user_id FROM fgd7_js_res_notifications WHERE alerted = 0 AND user_id NOT IN ( SELECT user_id FROM fgd7_js_res_user_options WHERE schedule > 1 OR lastsend < NOW() - INTERVAL 1 MINUTE)

gives back no error

So now I guess I have to wait for sergey feedback on this... ?

you have to also change < to >. The total fix is line 134 of controllers/cron.php

SELECT user_id FROM #__js_res_notifications WHERE alerted = 0 AND user_id NOT IN (

 SELECT user_id FROM #__js_res_user_options WHERE schedule != 1 OR lastsend > NOW() - INTERVAL {$period})

thank you

but is this a bug?

beacuse if so I will just wait for next release, I am not in a hurry for this feature

Yes it is a bug.