HI.

I am using latest Groupjive 3.0.1.BUILD.2016.02.11.02.54.56.E.54.E.77.D.6.C on Joomla 3.4.8 and I have problems when I set notifications to ON.

Whenever someone joines the group, uploads a file or image I get this mysql error:

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 ') )' at line 13 SQL=SELECT DISTINCT n.*, u.`status` FROM `wmpt_groupjive_notifications` AS n LEFT JOIN `wmpt_groupjive_users` AS u ON u.`user_id` = n.`user_id` AND u.`group` = n.`group` LEFT JOIN `wmpt_comprofiler` AS cb ON cb.`id` = u.`user_id` LEFT JOIN `wmpt_users` AS j ON j.`id` = cb.`id` LEFT JOIN `wmpt_user_usergroup_map` AS g ON g.`user_id` = j.`id` WHERE n.`group` = 1 AND n.`user_id` != 1822 AND n.`user_id` NOT IN (1822, 1822) AND cb.`approved` = 1 AND cb.`confirmed` = 1 AND j.`block` = 0 AND ( n.`user_id` = 62 OR u.`status` >= 2 OR g.`group_id` IN () )

If I disably the automatic notificiations the error is gone and only email message to group users is beeing sent..

How can I fix automatic notifications?

Regards,

Rok

Hi there!

I'm unfortunately getting the error below when a new group event is created. I'm being able to get the group created, without any problem, but it seems that when the notification is going to be send (either by email or private message) the below error comes up.

I have just upgraded to the "Latest Night Release" for ALL GroupJive, Auto Actions and Activity plugins.

Any ideas?

* * * I don't get this error when I DISABLE the notifications * * *


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 ') )' at line 13 SQL=SELECT DISTINCT n.*, u.`status` FROM `ECiu_groupjive_notifications` AS n LEFT JOIN `ECiu_groupjive_users` AS u ON u.`user_id` = n.`user_id` AND u.`group` = n.`group` LEFT JOIN `ECiu_comprofiler` AS cb ON cb.`id` = u.`user_id` LEFT JOIN `ECiu_users` AS j ON j.`id` = cb.`id` LEFT JOIN `ECiu_user_usergroup_map` AS g ON g.`user_id` = j.`id` WHERE n.`group` = 1 AND n.`user_id` != 421 AND n.`user_id` NOT IN (421, 421) AND cb.`approved` = 1 AND cb.`confirmed` = 1 AND j.`block` = 0 AND ( n.`user_id` = 421 OR u.`status` >= 1 OR g.`group_id` IN () )

Hi,

Thanks, this has solved it.

But now I see if a group user want to post on a group wall, message appears "thanks for posting" but wall message is hidden for user and moderator also (not visible).

Is there something else I need to check?

Regards,

Hi,

Post from user to group wall started to work, after I deleted one older "corrupted" post in adminmenu - Groupjive - wall posts.

Now posts are working again.