Hi
We are not getting notifications for group events created through the status box. We have implemented the bug fix below, but it does not work. So no email notifications are being created. Also, whilst the event is appearing in the stream of a group member, it isn't showing as a notification on their notifications icon either.
www.jomsocial.com/forum/groups/21987-mai...gh-status-box#112807
NB the developer said the line number was different to the one given
This is urgent as we have users upset that their event hasn't been emailed out.....
You can look at our dev site below to see two events I have created since doing the fix, which didn't trigger notifications.
Hi, Susan.
I assign developer to this thread.
Hi Susan,
could you please provide me FTP access detail. I need to have a look the code at your site for debugging purpose.
you can edit your first post at this topic at put any credential information at site info form
Regards
Hi Susan,
could you please provide me administrator access detail for dev5?
I tried all access detail from site info. I cannot find any valid access detail for administrator.
please edit your first past at this topic. and update any credential information at there.
Regards
Hi Susan,
there is no notification because there is error with some SQL, I still looking it from where it come from.
maybe your site got some query modification at jomsocial core? becuase your site still using 3.2.1.5
Regards
Hi Susan,
Here the fix:
1. put this new code at /components/com_community/controllers/system.php line 1504,
CEvents::addGroupNotification($event);
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 startdate asc' at line 1 SQL=SELECT * from ufe8m_community_events where parent = ORDER BY startdate asc