Module - Members - JomSocial Forum

Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated

Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Module - Members

11 years 10 months ago

#111648

Topic Author
Danny
Offline
Fresh Boarder
Posts: 87
Thank you received: 1

Licenses:

JomSocial Active

Since i install JomSocial Professional 3.2.1.5 i have i big problem. When i click members i get this error:

Fout: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND a.`username` != "" ORDER BY a.`registerDate` DESC' at line 1 SQL=SELECT COUNT(DISTINCT(a.`id`)) FROM `jos_users` AS a LEFT JOIN `jos_session` AS b ON a.`id`=b.`userid` WHERE a.`block`='0' AND a.`id` NOT IN() AND a.`username` != "" ORDER BY a.`registerDate` DESC

Can please somebody help me?

Attachments:

11 years 10 months ago

#111658

Albertus
Offline
User is blocked
Posts: 3296
Thank you received: 2582

Licenses:

Hi Danny,

because at jomsocial privacy, you set Show Administrators in Member's Lists = No
please create or assign new user from Joomla backend as Super User (user group). Because on that query always looking Super User too.

Regards,
Albert

The following user(s) said Thank You: Danny

11 years 10 months ago

#111692

Topic Author
Danny
Offline
Fresh Boarder
Posts: 87
Thank you received: 1

Licenses:

JomSocial Active

Thank you Albert, at simple as that... :)

Moderators: Piotr Garasiński

Notice

Support Forum

Module - Members

Licenses:

Attachments:

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere