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.

Error : 1064

5 years 11 months ago
  • Azhar's Avatar
    Topic Author
  • Azhar
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 1
JomSocial Expired iSEO Expired Socialize Expired

I have an issue on my site after upgrading to JomSocial Home page is returning an error:

Error: 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 `wottide_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`

Please use development site details

5 years 11 months ago
JomSocial Expired GURU Expired Publisher Expired AdAgency Expired iSEO Expired Socialize Expired

Hi Azhar,
As I am testing with the given test/development site.
It seems all working fine.
Is the problem fixed already.
BTW the above mentioned problem should be fixed with the jomsocial version 3.2.05
So let me know if the problem still persist with a bit detail (when actually the problem causing?).

The following user(s) said Thank You: Azhar
5 years 11 months ago

Hi Azhar

please check the table wottide_community_groups_members
and execute this query:

SELECT `member`.groupid, `group`.id 
FROM `wottide_community_groups_members` AS `member` LEFT JOIN `wottide_community_groups` AS `group` ON (`member`.groupid = `group`.id ) WHERE `group`.id IS NULL

If the result not empty, please provide that result. I need to make the query to delete that groupid from wottide_community_groups_members


The following user(s) said Thank You: Azhar
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