Error : 1064

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.

Error : 1064

9 years 9 months ago

#92606

Topic Author
Azhar
Offline
Fresh Boarder
Posts: 8
Thank you received: 1

Licenses:

JomSocial Expired iSEO Expired Socialize Expired

I have an issue on my site after upgrading to 3.2.0.7. 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

9 years 9 months ago

#92632

Ashraf
Offline
Junior Boarder
Posts: 1624
Thank you received: 270

Licenses:

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?).
Thanks

extensions.joomla.org/extensions/clients...ies/communities/7608

The following user(s) said Thank You: Azhar

9 years 9 months ago

#92633

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

Licenses:

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

Regards,
Albert

The following user(s) said Thank You: Azhar

Moderators: Piotr Garasiński

Notice

Support Forum

Error : 1064

Licenses:

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere