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.

1064 error MySQL

11 years 4 days ago
  • Eugene's Avatar
    Topic Author
  • Eugene
  • Offline
  • Fresh Boarder
  • Posts: 27
  • Thank you received: 0
Licenses:
JomSocial Active

I cannot identify what caused this error. Please advise on the correct method/procedure to fix it. Thanks, Eugene

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 'GROUP BY `groupid`' at line 1 SQL=SELECT `groupid` FROM `ggi_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`

Attachments:
11 years 4 days ago
Licenses:

Hi, Eugene.

Please try this fix.
Upload it to:
(make safe copy of original file first)
ROOT/components/com_community/libraries/user.php

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you

This message has an attachment file.
Please log in or register to see it.

11 years 4 days ago
  • Eugene's Avatar
    Topic Author
  • Eugene
  • Offline
  • Fresh Boarder
  • Posts: 27
  • Thank you received: 0
Licenses:
JomSocial Active

Thanks. I will try it now and let you know soon.

11 years 4 days ago
  • Eugene's Avatar
    Topic Author
  • Eugene
  • Offline
  • Fresh Boarder
  • Posts: 27
  • Thank you received: 0
Licenses:
JomSocial Active

It worked! Thanks. I was using JFBconnect and I think it contributed to this error. I will no longer use any extension that depends on Facebook connections as Facebook can change the rules in the middle of the game without warning. I have uninstalled JFBConnect and will not use it again.

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved